I have an oracle stored procedure that has 4 input parameters and then returns a cursor. I have created a synonym. How do I invoke the stored procedure? The examples just don't have alot of information with multiple parameters. Anyone have a real life example?

This message has been edited. Last edited by: Kerry,

A synonym even is not needed. You can go through the SQL Pass through for calling you SP.

SQL SQLORA
EX &LIBRARY/STORE_PROC_NAME('PARAM1'..'PARAM4');
TABLE FILE SQLOUT
PRINT
*
END

&LIBRARY/STORE_PROC_NAME('PARAM1'..'PARAM4')

Replace with your schema name, SP name, and Param values....