Re: variable cursors in 8.0.4
From: Frank <fbortel_at_home.nl>
Date: Mon, 02 Dec 2002 21:19:01 +0100
Message-ID: <3DEBC035.8070309_at_home.nl>
Date: Mon, 02 Dec 2002 21:19:01 +0100
Message-ID: <3DEBC035.8070309_at_home.nl>
Andre Gehlert wrote:
> Hi all,
>
> does anybody know if it is possible to use a cursor within a procedure
> where the column name and the table name are not known during compile
> time. I want to give the procedure more flexibility and reuseability
> fro more than one table.
>
> Hope that I can get answers!
>
> Thanks a lot,
> Andre Gehlert
Yes, dynamic pl/sql.
Better upgrade, tho, 8.0 isn't supported anymore, and asof 8i
there is execute immediate, which is a lot easier.
Hth, Grtz, Frank Received on Mon Dec 02 2002 - 21:19:01 CET