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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Object types

Re: Object types

From: Dmitry E. Loginov <lde_at_mpsb.ru>
Date: Mon, 24 May 2004 09:35:14 +0400
Message-ID: <c8s1ih$19b1$1@news.caravan.ru>


Just place declaration of variables to the DECLARE section of the PL/SQL block:

DECLARE

     x myType;
     y myRefCursor;
BEGIN
     x.id := 14;
     y := myPackage.myFunc(myTypeVar => x)
end;

"Mark" <mark.harris.nospam_at_ukonline.co.uk.nospam> wrote in message news:40b0bf78$0$2280$afc38c87_at_news.easynet.co.uk...
> begin
> x myType;
> y myRefCursor;
>
> x.id := 14;
>
> y := myPackage.myFunc(myTypeVar => x)
> end;
>
> But the error message I get back is:
>
> PLS-00103: Encountered the symbol "myType" when expecting one of the
> following:
> := . ( @ % ;
Received on Mon May 24 2004 - 00:35:14 CDT

Original text of this message

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