Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to fire a stored proc from a query window
We've been working with Oracle (10g) for a couple months and we are
just now trying to fire a stored proc from a query window (Sql/Plus or
3rd party utility)
I would like to call the proc declared below and have the results returned, but for the life of me I cannot figure out how to call it.
CREATE OR REPLACE PROCEDURE SA.USP_LEES_TEST_SP (
strAgentCode IN CHAR DEFAULT NULL,
RC1 IN OUT Omwb_emulation.globalPkg.RCT1)
AS
OPEN RC1 FOR SELECT * FROM SA.UserInfo WHERE UserCode LIKE USP_LEES_TEST_SP.strAgentCode_ || '%';
END USP_LEES_TEST_SP;
I've tried things like the following, but nothing works:
EXECUTE sa.usp_Lees_Test_Sp('12345'),
CALL sa.usp_Lees_Test_sp('12345') and
EXECUTE sa.usp_Lees_Test_Sp('12345', RC1)
If anyone can give me the command to execute this proc it would be greatly appreciated.
Thanks
Lee
Received on Mon Aug 16 2004 - 12:23:03 CDT