Remote INSERT with VARRAY [message #21124] |
Mon, 15 July 2002 03:28 |
Stefan Kortmann
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
Hi,
does anybody know an efficient work-around on the following?
It is permitted to insert tables into a remote database when they contain user-defined types or VARRAYs, simply by INSERT INTO table@remote_db .. .
You get an error ORA-22804, storing not permitted.
Is there any straight-forward solution to accomplish this action with plain SQL? If not, what is a smarter way to do it in PL/SQL?
Thanks a lot in advance,
Stefan
|
|
|
Re: Remote INSERT with VARRAY [message #21125 is a reply to message #21124] |
Mon, 15 July 2002 04:53 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
log into the remote database and create a
procedure or function that accepts the pieces of the object table (breaking
the object type down into it's components) and performs the DML operation
for you. Then log into your local database and perform the desired DML
operation using a remote procedure call to this new procedure or function
|
|
|