Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL-Package

Re: PL/SQL-Package

From: <buckeye714_at_my-deja.com>
Date: 2000/06/09
Message-ID: <8hri1t$f2r$1@nnrp1.deja.com>#1/1

After the last line ....return RCT; you need to end the procedure definition and the pacakage body definition;

END newshopper;

END NEWSHOPPERPKG; HTH,
Patrick

In article <Eja05.896$Qf6.34364_at_nuq-read.news.verio.net>,   "SP" <spant1_at_aol.com> wrote:
> 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;
>
> While I compile the following body I get the message "Encountered the
 symbol
> end of file when expecting one of the following -begin end function
 package
> pragma procedure form"
>
> CREATE OR REPLACE PACKAGE BODY NEWSHOPPERPKG AS
> function newshopper (cn in shopper.cn%type,ref_ in shopper.ref_%type)
 return
> RCT1
> is RCT RCT1;
> begin
> 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;
>
> I would appreciate your input.
> SP
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 09 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US