Re: DBMS_UTILITY.EXEC_DDL_STATEMENT

Yamuna Vallipuram wrote:
>
> 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

Do other 'alter session' commands work - I know 'alter system' is not officially DDL, possibly 'alter session' is the same.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse