Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Object types
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
![]() |
![]() |