PL/SQL-Package
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