Re: Table name as a variable in PL/SQL procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 Jan 2002 10:49:16 +0100
Message-ID: <8bdq4uspv54k9pn8qtskh27bi6f7arcujc@4ax.com>

On 22 Jan 2002 00:18:05 -0800, ronench_at_hotmail.com (Ronen) wrote:

>Hello,
>
>I would like to know how to create a procedure out of the following
>anonymous PL/SQL block, and how should I rewrite it in order to accept
>table name as variable(table name equal ‘fixposition').
>
>Thanks in advance,
>
>Ronen

You'll need Native Dynamic SQL (Open <ref cursor var> for <statement>) in 8i and above or dbms_sql in 8.0 and below. This is a FAQ

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jan 22 2002 - 03:49:16 CST