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>


[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

Original text of this message