atulkbajpai
Last Activity: Feb 10 '10, 10:13 AM
Joined: Jan 13 '10
Location:
-
The requirement is : There is a procedure in DB1 which has input as table of object type. These records are processed in DB1 and a final list is prepared which is forwarded to DB2 procedure and further processing is done in DB2 and returned to DB1 procedure call. -
atulkbajpai started a topic I am trying to define a variable using an object created in other schemain OracleI am trying to define a variable using an object created in other schema
E.G.
in DB1 I have created an object using "Create type" named as t_obj
in DB2 I have a package in which I have to
define a variable refering to DB1@t_obj
but each time error is thrown
pls-00331 illegal reference to t_obj@DB1_link (I am using Database Link)
Is it possible to do so?
Actual problem is that I have to pass certain sets of records from DB1 to DB2 in t_obj.
If not possible...
No activity results to display
Leave a comment: