[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
...