Re: How to fire a stored proc from a query window

"Lee" <lduhl_at_corp.realcomp.com> wrote in message news:719532c5.0408160923.6d53584_at_posting.google.com...
> 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
> -- Variable Declarations
> strAgentCode_ VARCHAR(10) := strAgentCode;
>
> -- Query Logic
> BEGIN
>
> 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

what errors do you get? Received on Mon Aug 16 2004 - 14:07:51 CDT