Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL question
Hi.
It is NOT possible ( passing table_name as parameter ).
You have to use dynamic SQL ( use Native Dynamic SQL with Oracle 8i, otherwise you are stuck with DBMS_SQL package ).
HTH. Michael.
In article <915l2d$l4p$1_at_nnrp1.deja.com>,
andyho99_at_yahoo.com wrote:
> Hi,
>
> Is it possible to declare a cursor where treat a table name as a
> variable in PL/SQL (tried to retrieve data from same column name among
> many tables)? I had been using variables in where clause but not table
> name. It seemed that PL/SQL didn't like my idea.
>
> Thanks, Andy
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Received on Tue Dec 12 2000 - 15:36:55 CST