Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

passing user-defined type table varchar2(256) across dblink

838213Feb 9 2011 — edited Feb 15 2011
Hi, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2011
Added on Feb 9 2011
6 comments
153 views