Re: PL/SQL cursor : from VARIABLE

Can't be done this way. Use DBMS_SQL to define and use dynamic cursors.

regards,
M. Armaghan Saqib

• SQL PlusPlus : Add power to SQL Plus command line
• SQL Link for XL : Integrate Oracle with XL
• Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

  ---

<ulysse51_at_my-deja.com> wrote in message news:<8356q7$qu6 $1_at_nnrp1.deja.com>...
> hi all
>
> in PL/SQL, i want to declare a cursor
> where the table name is a variable like
>
> cursor rec (table_name in varchar2) is
> select *
> from table_name;
>
> but it doesn't work
> thank you for your help
> FRED
Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 07:09:44 CST