[ARA] Oracle Action Pack SQLPLUS fails when DB Command contains @ and parameter

Idea created by hoaan02 Employee on Mar 18, 2019
    New
    Score1
    • hoaan02

     

    The action EXEC SQLPLUS of the Oracle Action Pack Failes when the @<sql-file> and a additional parameter 

    PARAM: Command = @'/data/installation_sources/araora.sql' 'featurexyz' 
    --> 
    ERROR[Sql-script file]: Sql-script file '/data/installation_sources/araora.sql' 'featurexyz' does not exist! 

    --> So the parameter of the db command is taken into account when checking the file existence.

     

    This could be fixed by splitting the file path and the parameters of the db command