Yes, it's possible for sure It's hard to explain why do you receive error without package specs samples, but in general to pass a user-defined type as a parameter you should either with define type DDL or defining the type in package spec I suppose you want the latter variant :) So here're an example: create or replace package TestPackage_1 as type TTestType is table of varchar2(1) index by varchar2(1); end TestPackage_1; / create or replace package TestPackage_2 as procedure Dummy(aParam TestPackage_1. TTestType); end TestPackage_2 You can use TTestType type in any PL/SQL block, but not in SQL.
Yes, it's possible for sure. It's hard to explain why do you receive error without package specs samples, but in general to pass a user-defined type as a parameter you should either with define type DDL, or defining the type in package spec. I suppose you want the latter variant :) So here're an example: create or replace package TestPackage_1 as type TTestType is table of varchar2(1) index by varchar2(1); end TestPackage_1; / create or replace package TestPackage_2 as procedure Dummy(aParam TestPackage_1.
TTestType); end TestPackage_2; / You can use TTestType type in any PL/SQL block, but not in SQL.
Thanks! Exactly what I needed! – DaveKub Apr 25 at 13:43.
The array is defined as: ... in both package's spec. " This is the source of your problem. PL/SQL regards two separate declarations as two different objects, even though both types have an identical signature.
Consequently the engine hurls when you call this: package2. Rollup_to_15(chanList) Your code has defined the chanList variable as package1. List_tab but the procedure is expecting a variable of type package2.
List_tab. The simplest solution is to declare LIST_TAB just in PACKAGE2, and chnage PACKAGE1 so that chanList is declared appropriately.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.