Home » Server Options » Data Guard » Returning clause in Active Data Guard is not allowed (PL/SQL Release - Production)
Returning clause in Active Data Guard is not allowed [message #638348] Tue, 09 June 2015 19:55 Go to next message
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.
                        p_2 IN OUT debug_table%ROWTYPE) IS
      INSERT INTO user_debug_table@testlink
           VALUES p2   
           RETURNING ID INTO p1 ;

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: 8794
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: data guard is very slow.why?
Next Topic: Online patching in logical database
Goto Forum:

Current Time: Thu Feb 02 12:22:21 CST 2023