Hi all...I have two different schemas called test1 and test 2.In test1 there is a package called pkg 1 and it has a ADD_NEW1 procedure.within that package(pkg1) I defined two arrays AR_NUMBER and AR_DESC.

ADD_NEW1 looks like following,


PROCEDURE "ADD_NEW1"(
"number1" IN AR_NUMBER,
"description1" IN AR_DESC
);


I want to call test1.pkg1.ADD_NEW1 procedure from the test2.pkg2.ADD_NEW2.

I used following statement from test2.pkg2 ,

test1.pkg1.ADD_NEW(varnum1,vardesc1);

in the package body I defined varnum1 and vardesc1 as follows,

varnum1 AR_NUMBER;
vardesc1 AR_DESC;

In pkg2.ADD_NEW2 also defined AR_NUMBER and AR_DESC as arrys within the package.


please help me...Im totally fed up with this matter.

It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.