| Returning clause in Active Data Guard is not allowed [message #638348] |
Tue, 09 June 2015 19:55  |
 |
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  |
John Watson
Messages: 8964
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
