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

Who-who

Hey, thats pretty funny! I'm just suprised you took your mothers nipple out of your mouth long enough to type it!

Later!

fwoo2_at_hotmail.com (Frank Woo) wrote in message news:<fcdf6638.0408191059.4a4532af_at_posting.google.com>...
> 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 Fri Aug 20 2004 - 11:33:55 CDT