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

Lee,

I have reviewed your posts to this use-group and I have determined one thing common in all your Oracle requests. You are an idiot. You could do your company a favor by quitting and getting someone actually qualified to work on a database structure.

There are plenty here at MIT. Maybe a good education is something you lack.

Either way, you bore me with your requests.

Frank Woo
Graduate Assistant
MIT lduhl_at_corp.realcomp.com (Lee) 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
Received on Thu Aug 19 2004 - 13:59:27 CDT