Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Function returns a PL/SQL table
Here's the problem. table_1 is a table of integers, and function_table
is a function that returns the same type as table_1. And I want to
assign table_1 from the result of function_table, like:
table_1 := function_table(parameter);
but pl/sql 2.3.4 always complains, something like
Message 6550: ORA-06550: line 16, column 8:
PLS-00382: expression is of wrong type
ORA-06550: line 16, column 1:
PL/SQL: Statement ignored
but if I call it like function_table(parameter)(i), it would work. How come?
Thanks Received on Thu Dec 03 1998 - 19:42:20 CST