How to use PL/SQL Collection Type in TABLE function(how to convert PL/SQL type to SQL Object Type) [message #626650] |
Thu, 30 October 2014 05:57 |
|
balaji.chelladurai
Messages: 6 Registered: April 2014
|
Junior Member |
|
|
I have a need to use a PL/SQL collection type(declared inside a package) in TABLE function. The packaged function receives the collection as an input parameter from a front-end application developed in C#.net. When I use the PL/SQL collection, I get "Cannot access rows from a non-nested table item" error.
I understand that the TABLE function can be used with Collection type created outside of PL/SQL as a SQL Object type, but the front-end app cannot pass the input as SQL Object type.
I could not use CAST function to convert the PL/SQL type to SQL object type to get it work with TABLE function.
Are there any alternative soltions available ?
Any help is highly appreciated.
|
|
|
|
|