Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Compilation of a package with pl/sql table type
In article <7e1oj3$o6o$1_at_nnrp1.dejanews.com>, nilayo_at_my-dejanews.com
writes
>I used to use 7.3.3 and my scripts worked well. Now I have to port them to
>8.0, 2 of my scripts can not be compiled. in these 2 scripts I use pl/sql
>table types which I define within the package specification, however I have
>to use them in the incoming parameter specifications, so that I have to use
>them before their declaration.
Not quite sure why you say you need to use them before you declare them?
Don't you just declare the datatypes at the head of the spec and then the procedures later?
Andy
--
Andy Hardy. PGP key available on request