Re: Passing table name to stored procedure?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 15 Dec 1998 09:21:57 +0100
Message-ID: <36761C25.9CCB508E@sybrandb.demon.nl>

I'm not sure what you're trying to accomplish. However, dynamic sql, which will allow you to pass any statement to the server, is in PL/SQL done by using the dbms_sql package.

Hth,
Sybrand Bakker, Oracle DBA

radzi wrote:

> Hi,
>
> I am writing a stored procedure which should take in tablename as parameter.
> I tried several ways but it did not compile. Could anybody who can help me
> on this? Or is it this the limitation which I have to live with the stored
> procedure?
>
> Many thanks.
>
> Radzi.
> IMS Asia (1989) Pte. Ltd.
> Singapore.

Received on Tue Dec 15 1998 - 02:21:57 CST