Re: Procedure, package and ref cursors question

sahcutie wrote:
> 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,

You have an OUT parameter that is undeclared as you define the REF CURSOR in the procedure itself.

Either define the REF CURSOR in a package header or use SYS_REFCURSOR: The weakly typed built-in.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)