Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL newbie question
One way to achieve this in Oracle 8i is to use Dynamic SQL, and the
following example is taken out of the Oracle supplied documentation;
create type NAME_ARRAY_TYPE is
varray(100) OF varchar2(50);
create or replace procedure GET_ENAME_COLUMN
(TABLE1 varchar2, TABLE2 varchar2) is
ENAME_COL name_array_type;
begin
end;
/
It supports a number of variations for building the SQL statement, and
how to return the result.
HTH.
Received on Thu Apr 14 2005 - 07:05:24 CDT