help needed on executin a stored proc

From: <rangneka_at_my-deja.com>
Date: 2000/06/26
Message-ID: <8j8b6j$qkn$1@nnrp1.deja.com>#1/1

I have created the following package and proc:

CREATE OR REPLACE PACKAGE PROCCURSORTYPES AS TYPE CHAR100_CUR IS REF CURSOR RETURN CHAR100TABLE%ROWTYPE; END PROCCURSORTYPES;
/

CREATE OR REPLACE PROCEDURE CHAR100PROC ( CHAR100_CV IN OUT PROCCURSORTYPES.CHAR100_CUR, CHAR100_PARAM IN CHAR100TABLE.CHAR100FIELD%TYPE) AS
BEGIN
OPEN CHAR100_CV FOR SELECT * FROM CHAR100TABLE WHERE CHAR100FIELD=CHAR100_PARAM;
END CHAR100PROC;
/

My applications can call and run this procedure no prblem with the corect data returned.

My question is this: How would I call this procedure in SQL Plus?

In SQL Plus I've tried:

execute procedure name (cursor,param)

but to no avail.

Any ideas?
Should the cursor parameter be set to 0?

Any help would be appreciated.

Shantanu

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 26 2000 - 00:00:00 CDT