Re: table name as parameter to a PL/SQL procedure?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 22 Jul 1999 20:38:15 +0800
Message-ID: <379710B7.3F52@yahoo.com>

Howard Lee Harkness wrote:
>
> On Wed, 21 Jul 1999 16:37:32 -0700, "Oyvind S. Roed"
> <oroed_at_azstarnet.com> wrote:
>
> >....and then use dynamic PL/SQL to do your thing with the tables in the
>
> Hmmm... a little messier than I had hoped, but I think I understand
> enough to make it work.
>
> BTW, I almost missed your response, since it apparently was entered as
> a new message, and not in the same thread.
>
> Thank you.
> hlh_NOSPAM_at_excite.com is a valid, unmunged address!
> It is also so full of spam(!) that I don't read it.

If you're on 8i, you can use strings in the content of cursors, thus achiecing what you are after without the hassle of dbms_sql

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 22 1999 - 07:38:15 CDT