passing user-defined type table varchar2(256) across dblink
838213Feb 9 2011 — edited Feb 15 2011Hi, hope someone out there can help/advise me on this...
i am trying to call a procedure on a linked db but am getting the
Error: PLS-00306: wrong number or types of arguments in call to <proc name>
i think the problem might be that i am passing a userdefined type as a parameter in the call to the procedure on the linked db.
the procedure takes the parameter VARGS, which i have created as a userdefined type on both dbs
CREATE OR REPLACE TYPE "VARGS" AS TABLE OF VARCHAR2(256);
however, it will not allow me to compile without getting the above error.
i did look at the option of using an OID (object identifier) but it did not help.
CREATE OR REPLACE TYPE "VARGS" OID '9157126944714C3983AF2CEBDE26F663' AS TABLE OF VARCHAR2(256);
i also read in some other forums that Oracle doesn't allow the movement of certain types across the dblink, but there are ways to configure it too. so far i have not been able to configure mine to work!
any help or advise (links to suggestions) would be very much appreciated.
thanks in advance.
San