Home » Server Options » Data Guard » Returning clause in Active Data Guard is not allowed (PL/SQL Release 11.2.0.3.0 - Production)
Returning clause in Active Data Guard is not allowed [message #638348] Tue, 09 June 2015 19:55 Go to next message
Ayyappa1986
Messages: 1
Registered: June 2015
Location: pittsburgh
Junior Member
hi folks i am getting an error while i am using returning clause in insert, could you please suggest me is there any solution to fix this issue.
Did oracle provide any other function to do the same job in active data guard.

here is my sample procedure.
CREATE OR REPLACE PROCEDURE test (p1 IN VARCHAR2 ,
                        p_2 IN OUT debug_table%ROWTYPE) IS
                       
BEGIN 
      INSERT INTO user_debug_table@testlink
           VALUES p2   
           RETURNING ID INTO p1 ;
           
END;


when i run & execute the above procedure i'm getting error.

ORA-22816: unsupported feature with RETURNING clause
ORA-06512: at "schemaname.TEST", line 18
ORA-06512: at line 8


[Updated on: Wed, 10 June 2015 08:23]

Report message to a moderator

Re: Returning clause in Active Data Guard is not allowed [message #638349 is a reply to message #638348] Tue, 09 June 2015 20:16 Go to previous message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
You did not bother to mention what the error was. I am guessing that it was an ORA-22816.
That would not be to do with Active Data Guard, it is because you cannot use the RETURNING clause for an insert into a remote table. If you think about the session architecture, it can't work.
Previous Topic: DR setup
Next Topic: Online patching in logical database
Goto Forum:
  


Current Time: Tue Nov 21 20:02:12 CST 2017

Total time taken to generate the page: 0.01840 seconds