DBMS_UTILITY.EXEC_DDL

From: Yamuna Vallipuram <yamuna.vallipuram_at_usit.uio.no>
Date: 2000/05/02
Message-ID: <390ED0C8.D66565C4@usit.uio.no>#1/1

Hi...

Jeg am having problems executing DBMS_UTILITY.EXEC_DDL_STATEMENT ('Alter session set global_names=false') on the fly.

I have a pocedure which accesses a table which is situated on a remote database. The database link which connects to the remote database does not have the same name as the database. So I need to set the global_names=false in order to access the table.
When I give a static sql statement 'Alter session set global_names=false ' and execute the procedure It works fine.

But when I try to execute Alter session set global_names=false in PL/SQL (on runtime) I get the following error message ORA 02085.

The dynamic DBMS_UTILITY.EXEC_DDL_STATEMENT ('Alter session set global_names=false') does not seem to work.

Any idea what I am doing wrong.

Regards Yamuna Received on Tue May 02 2000 - 00:00:00 CDT