Re: Tablename as Parameter in Stored Procedure

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 20 Aug 1999 03:44:53 GMT
Message-ID: <37cbcba6.52310067@netnews.worldnet.att.net>

On Thu, 19 Aug 1999 15:31:50 +0800, "Chittesh Mehta" <chittesh_at_swi.com.sg> wrote:

>Is there any way to pass a tableName as parameter and
>get the certain value out of that table.

Yes, but you need to use dynamic SQL. Find a copy of the Application Developer's Guide and read up on the DBMS_SQL package.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Thu Aug 19 1999 - 22:44:53 CDT