Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Global temporary tables v pl/sql tables
"Keld Nielsen" <keldnielsen_at_image.dk> wrote in message news:<fAEW8.120$QP6.36073_at_news010.worldonline.dk>...
>
> CREATE OR REPLACE PACKAGE x AS
>
> PROCEDURE y;
> end;
> /
> CREATE OR REPLACE PACKAGE BODY X AS
> TYPE emp_typ IS TABLE OF emp%ROWTYPE
> INDEX BY BINARY_INTEGER;
> emp_tab emp_typ;
>
> PROCEDURE y IS
> CURSOR emp_cur IS
> SELECT * FROM emp
> ORDER BY empno;
> ...
>
> so the table has been declared, but perhaps not
> DECLARED !
>
> why has the table been declared in the body, do
> you think ?
Well, as you said in another post...
"English is not my native language, so I may not have expressed myself too clearly."
Quite
CE Received on Wed Jul 10 2002 - 03:23:14 CDT