Using the same type in 2 instance
From: Steph <kleinstephane_at_netscape.net>
Date: 12 Jul 2004 09:57:29 -0700
Message-ID: <e033c553.0407120857.36b6a447_at_posting.google.com>
Hi,
On my first oracle instance, I have a global type 'productarray' (CREATE OR REPLACE TYPE productarray AS TABLE OF VARCHAR(30)), I have a package procedure having myArray OUT productarray as parameter. No problem to manage this OUT parameter from a function or procedure in the same instance, even if schemas are different. But if I try to use this package procedure from procedure in another instance, I have the error :
PLS-00306 : wrong number or types of arguments in call of 'myfunction'.
Date: 12 Jul 2004 09:57:29 -0700
Message-ID: <e033c553.0407120857.36b6a447_at_posting.google.com>
Hi,
On my first oracle instance, I have a global type 'productarray' (CREATE OR REPLACE TYPE productarray AS TABLE OF VARCHAR(30)), I have a package procedure having myArray OUT productarray as parameter. No problem to manage this OUT parameter from a function or procedure in the same instance, even if schemas are different. But if I try to use this package procedure from procedure in another instance, I have the error :
PLS-00306 : wrong number or types of arguments in call of 'myfunction'.
the strict same global type has been created in both instances and the package 1 is visible in instance 2 via a synonym, user 2 has execute right on package 1.
Anyone has an idea about what is wrong ?
Thanks a lot.
Stephane Received on Mon Jul 12 2004 - 18:57:29 CEST