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 -> Re: PL/SQL newbie question

Re: PL/SQL newbie question

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 14 Apr 2005 05:05:24 -0700
Message-ID: <1113480324.568465.103850@l41g2000cwc.googlegroups.com>


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

Original text of this message

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