Home » SQL & PL/SQL » SQL & PL/SQL » Remote INSERT with VARRAY
Remote INSERT with VARRAY [message #21124] Mon, 15 July 2002 03:28 Go to next message
Stefan Kortmann
Messages: 1
Registered: July 2002
Junior Member
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,
Re: Remote INSERT with VARRAY [message #21125 is a reply to message #21124] Mon, 15 July 2002 04:53 Go to previous message
Mahesh Rajendran
Messages: 10690
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
Previous Topic: Re: Error while connecting to oracle
Next Topic: update trigger....plz help me ....
Goto Forum:

Current Time: Wed Oct 23 18:51:57 CDT 2019