laszlo_spamhole_at_freemail.hu wrote:
> Hi. I'm relatively new to plSQL, and I have a bit of a problem. I'd
> like to make a package with one procedure creating some tables, and
> another procedure SELECTing from them.
>
> Is this even possible? My problem is that (as far as I know), plSQL
> only allows creating tables through EXECUTE IMMEDIATE. And if the table
> creator procedure uses EXECUTE IMMEDIATE to create the tables, the
> other procedures can't see that the tables exist, and the whole thing
> refuses to compile, giving a "Table or view does not exist" error.
>
> Any help with this one?
>
> Thanks,
>
> Laszlo
What you want can be done. It is equally true that it should NEVER
be done.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue May 24 2005 - 11:11:06 CDT
