Unable to call Procedures with parameters from GEL
search cancel

Unable to call Procedures with parameters from GEL


Article ID: 251068


Updated On:


Clarity PPM On Premise


Processes which call stored procedure fail with error ORA-06576: not a valid function or procedure name


Release : 16.0.3+


Broadcom made a decision to change the driver from DataDirect to the Native driver in Clarity 16.0.3, and DataDirect was not mindful of these expectations which native drive does not allow.


Clarity will pass the SQL code to the driver to execute at the database 

  • Review and run your custom code in database client tools like Oracle SQL Developer/Toad/DBeaver first, and use the working code in your GEL script.
  • Use good coding best practices and pass the right datatype.
  • Do not use schema aliasing when calling within Clarity.

Additional Information

Jobs that execute a Stored Procedure fail