Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Function returns a PL/SQL table

Function returns a PL/SQL table

From: dp <dp_at_asimba.com>
Date: Thu, 03 Dec 1998 17:42:20 -0800
Message-ID: <36673DFC.3E7F541F@asimba.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US