How to need to access the DB1 procedure through db link from DB2

**sambamurthy** · Oct 18 '10, 08:55 PM

[Split from old thread]

In DB1, i have a procedure which takes objects types
as parametres (input & output) like below

Code:

CREATE TYPE BCI.BCIWSR_ORD_ATTACH_REC_TYPE IS OBJECT
   ( category_name                VARCHAR2(30),
     orig_sys_document_ref        VARCHAR2(50),
     orig_sys_line_ref            VARCHAR2(50),
     note_description             VARCHAR2(200),
     note_text                    VARCHAR2(5000),
     url                          VARCHAR2(300),
     attachment_id                NUMBER,
     header_id                    NUMBER,
     order_number                 NUMBER,
     line_id                      NUMBER,
     line_number                  NUMBER
   )

From DB2 i need to access the DB1.procedure through db link.
Any other way to access the same in stead of pl/sql tables.

your help is highly appreciated.

Thanks
Samba