Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02069: global_names parameter must be set to TRUE for this operation

589859Jun 11 2008 — edited Jun 11 2008

Dear all

I am trying to update a table via a database link in a stored pl/sql procedure.

At the beginning of my pl/sql procedure, I have added the following statement:

execute immediate 'alter session set global_names=TRUE';

but unfortunately, I am still getting the error:

ORA-02069: global_names parameter must be set to TRUE for this operation

Please can someone explain why I am still getting this error - and the steps I can make to fix it?

Many thanks

Paul

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2008
Added on Jun 11 2008
4 comments
3,999 views