PL/SQL-Package

From: SP <spant1_at_aol.com>
Date: 2000/06/09
Message-ID: <Eja05.896$Qf6.34364_at_nuq-read.news.verio.net>#1/1


I've this package body:
PACKAGE NEWSHOPPERPKG as
type RT1 is Record(
newcustid Number(10,0),
cn char(18),
ref_ char(20)
);
type RCT1 is ref cursor return RT1;
end;

[Quoted] While I compile the following body I get the message "Encountered the symbol [Quoted] end of file when expecting one of the following -begin end function package pragma procedure form"

CREATE OR REPLACE PACKAGE BODY NEWSHOPPERPKG AS [Quoted] function newshopper (cn in shopper.cn%type,ref_ in shopper.ref_%type) return RCT1
is RCT RCT1;
begin
[Quoted] select custid.nextval into newcustid from shopper; insert into shopper (custid, cn, custdatetime,ref_)

         values (newcustid,sysdate,ref_); open RCT for select custid, cn, ref_from shopper where custid=newcustid; return RCT;

[Quoted] I would appreciate your input.
SP Received on Fri Jun 09 2000 - 00:00:00 CEST

Original text of this message