Invalid Datatype when test function

[Mauro Sousa]

Hi,

I'm facing problems when testing some kind of functions.
Basically on test window, i'm unable to open the results from a cursor when this cursor is built from a table_table_varchar.

Example:
o_title OUT pk_types.cursor_type
and casting before return:
OPEN o_title FOR
SELECT column_value FROM TABLE(CAST(l_title_array_t AS table_table_varchar));

When this is just a table_varchar and not a table_table_varchar everything works.

Another note: I'm getting the proper results because i've a webservice where i can see the requested data, but not on PL/SQL Software

Thanks for any help
Mauro Sousa

 

[Claus Pedersen]

What is a table_table_varchar? I assume that it is a 2-dimensional array of a varchar2 datatype?
Can you provide an example where you state the scripts to create the types, table etc.?