Select to view content in your preferred language

SQL Custom Step - Stored Procedure

3339
2
Jump to solution
02-29-2012 10:35 AM
Jean-GabrielHasbani
New Contributor II
Hello,

I am trying to run a stored procedure, in Oracle, using the SQL custom step. I have WMX 10, Desktop. WMX is installed on the same DB as the stored procedure, I and WMX have execute rights on the procedure.

When running the step, I get the error "An error occurred while trying to execute this step. Underlying DBMS error [Ora-00900: Invalid SQL statement]"

It is not a coding error as I can successfully run the procedure from Oracle, as the WMX user. It is not a permission issue as, for testing, I gave public execution rights on the procedure.

The step is declared as:
/database:jtxsystem /sql:"execute Shema.Package.ProcedureName(param1,param2)"

I have tried, with no luck,the Data DB (same as the jtxsystem DB anyways), and with/without an ending ;

Has anyone succeeded in running a stored procedure from a custom SQl step?

Thanks
0 Kudos
1 Solution

Accepted Solutions
TopeBello
Occasional Contributor III
Hi Jean,

Yes, and this is the argument that you can pass into the custom step
/database:jtxsystem /sql:"BEGIN Shema.Package.ProcedureName(param1,param2); END;"


You can also take a look at this forum post here that is related to what you are doing.
I hope this helps!

Thanks,
Tope

View solution in original post

0 Kudos
2 Replies
TopeBello
Occasional Contributor III
Hi Jean,

Yes, and this is the argument that you can pass into the custom step
/database:jtxsystem /sql:"BEGIN Shema.Package.ProcedureName(param1,param2); END;"


You can also take a look at this forum post here that is related to what you are doing.
I hope this helps!

Thanks,
Tope
0 Kudos
Jean-GabrielHasbani
New Contributor II
Thank you very much! It works perfectly with this syntax!

Jean
0 Kudos