How to fire a stored proc from a query window

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 Mon Aug 16 2004 - 12:23:03 CDT