Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to fire a stored proc from a query window
Lee wrote:
> 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
I would seriously test this app, as it is a ported application from SQL Server (by the looks of it), via Oracle's Migration Workbench (OMWB). Both products have their flaws...
-- Regards, Frank van BortelReceived on Wed Aug 18 2004 - 04:58:43 CDT