Thread: DB-Link and Object Columns
12-02-05, 09:23 #1Registered User
- Join Date
- Feb 2005
- Germany / Saarland
Unanswered: DB-Link and Object Columns
I wonder if someone else had this problem before and if anyone may help me out of this mess...
I have two databases connected by bidirectional database links. In a COBOL-program running on database 1 I try and read data from a table in database 2, having a synonym for the table in database 1.
create synonym stg005 for STG005@DB2.world;
DB1> select * from stg005;
=> if I try this out in SQL*Plus I succeed in retrieving data from the table.
I may even update and delete data in it.
BUT: As soon as I try and implement that statement within my COBOL-code as a cursor, I get the following error message (PreCompiler):
PCB-S-00576, PLS-453: remote operations not permitted on object tables or user-defined type columns
I found another ORA-Message (#22804) that says there is no way to access tables with object columns via remote DB-Link ... IS THAT IT?!
I cannot imaginge that there should be no way to retrieve object data from a remote table. In this case, there is only one abstract data type in the table, and this one is known in db1 as well as in db2!!!
I would appreciate any response, as I stand with my back at the wall.
12-02-05, 10:37 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
As with too many posts, no version of Oracle is mentioned. :-(
In any cases, some versions had bugs regarding SYNONYMs.
Alternatively you could drop the SYNONYM, which does not work, & CREATE VIEW instead.
HTH & YMMV!You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.