From: Michael Bialik <michael_bialik@my-deja.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: PL/SQL question
Date: Tue, 12 Dec 2000 21:36:55 GMT
Organization: Deja.com
Lines: 27
Message-ID: <9165pn$4r6$1@nnrp1.deja.com>
References: <915l2d$l4p$1@nnrp1.deja.com>
NNTP-Posting-Host: 212.179.147.234
X-Article-Creation-Date: Tue Dec 12 21:36:55 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
X-Http-Proxy: 1.1 x58.deja.com:80 (Squid/1.1.22) for client 212.179.147.234
X-MyDeja-Info: XMYDJUIDmichael_bialik


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@nnrp1.deja.com>,
  andyho99@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/