Re: owner name as parameter in a stored procédure

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 30 Apr 2003 15:37:07 +0200
Message-ID: <p9kvav8c474o82t7r5phniefsq19cqatkn@4ax.com>

On Wed, 30 Apr 2003 11:50:03 +0200, ferret <ferret_at_dase.bruyeres.cea.fr> wrote:

>Hello,
>
>I would like to pass the name on a owner as parameter in a stored
>procedure written in PL/SQL. How can I do that.
>
>Thanks for your help
>
>Pascal Ferret.

The answer to this question (owner or table name or whatever not known at compile time) has been provided over and over and over again here: - use Native Dynamic Sql (8i and higher) - or dbms_sql (any version)

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 30 2003 - 08:37:07 CDT