Re: variablize from clause in cursor declaration

From: AleX <korrozia_at_my-deja.com>
Date: Fri, 17 Sep 1999 17:00:33 GMT
Message-ID: <7rts39$h90$1@nnrp1.deja.com>

One option would be to use dynamic SQL, and ditch the second cursor altogether. It's a bit messy, but quite doable.

In article <7rtk0q$amm$1_at_nnrp1.deja.com>,   cubical8_at_my-deja.com wrote:
> I was trying to write an oracle procedure with two cursors. The frist
> is opened against a table which provides information such as a table
> name to be used by the second cursor. In theory what I am trying to
do
> is variablize the name of the table in the from clause of the second
> cursor declaration. I have talked this over with Oracle support and
> they say that you can't really do this but I know some folks may have
> already had to do something very similar. I need your ideas on
> possible solutions or work arounds.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

--

                 Alex Shterenberg

"I hate people. I think they should suffer as much as  possible, and therefore I'm into those old communist

         dictatorships." - Euronymous, Mayhem

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 17 1999 - 12:00:33 CDT