Re: Procedure, package and ref cursors question
From: sahcutie <sahcutie_at_yahoo.com>
Date: 18 Oct 2005 07:00:50 -0700
Message-ID: <1129644050.842412.184530_at_z14g2000cwz.googlegroups.com>
Date: 18 Oct 2005 07:00:50 -0700
Message-ID: <1129644050.842412.184530_at_z14g2000cwz.googlegroups.com>
[Quoted] So in the procedure below, what is wrong with the ref cursor or how do I get the cursor to be an out cursor?
PROCEDURE "WEBSERVICE".VENDORIDANDADDINFO
(
"LASTNAME" IN VARCHAR2, VendorCursor OUT REF CURSOR) IS
TYPE ref_info IS REF CURSOR RETURN VendorRecord; C_Vendor ref_info; TYPE vend_rec IS RECORD ( VenNum VARCHAR2(10), VenAdd1 VARCHAR2(35), VenAdd2 VARCHAR2(35), VenCity VARCHAR2(30), VenState VARCHAR2(6), VenPostal VARCHAR2(12), VenCountry VARCHAR2(3) ); VendorRecord vend_rec;
BEGIN -- executable part starts here
OPEN C_Vendor FOR select a.VENDOR_ID, c.ADDRESS1, c.ADDRESS2, Received on Tue Oct 18 2005 - 16:00:50 CEST