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

Home -> Community -> Usenet -> c.d.o.server -> Re: Compilation of a package with pl/sql table type

Re: Compilation of a package with pl/sql table type

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Sun, 11 Apr 1999 00:26:54 +0100
Message-ID: <gtEsvYA+49D3Ewq2@ahardy.demon.co.uk>


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


Received on Sat Apr 10 1999 - 18:26:54 CDT

Original text of this message

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