Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to fire a stored proc from a query window

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

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 18 Aug 2004 11:58:43 +0200
Message-ID: <cfv8sf$m5k$1@news3.tilbu1.nb.home.nl>


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 Bortel
Received on Wed Aug 18 2004 - 04:58:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US