Problem in PL/SQL ???

From: Chow Hoi Ka, Eric <d951686_at_sftw.umac.mo>
Date: Wed, 23 Jun 1999 20:05:51 +0800
Message-ID: <3770CD9F.7F69EACA@sftw.umac.mo>

Hello,

Is it possible for the following statement ?

DECLARE
    TYPE myArray IS TABLE OF myTable%ROWTYPE INDEX BY BINARY_INTEGER;     values myArray;

    stmt               varchar2(100);
    cid                integer;
    rows_processed     integer;
BEGIN
        stmt := 'select * into values(1) from myTable where id = :var1';

        cid := dbms_sql.open_cursor;
        dbms_sql.parse(cid, stmt, dbms_sql.v7);
        dbms_sql.bind_variable(cid, ':var1', '123');
        rows_processed := dbms_sql.execute(cid);
        dbms_sql.close_cursor(cid);

END; I just want to select all the fields into the array. But, this code can't work.
Please give me some suggestions. Or teach me how to solve t.

Best regards,
Eric

--

     _                                                  _
    / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
   / /  |                                            |  \ \
 _( /_  | _   Chow Hoi Ka, Eric                    _ |  _) )_


(((\ \> |/ )                                      ( \| </ /)))


(\\\\ \_/ /   E-Mail : d951686_at_sftw.umac.mo        \ \_/ ////)
 \       /                                          \        /
  \    _/     http://www.sftw.umac.mo/~d951686/      \_     /
  /   / |____________________________________________| \    \
 /   /                                                   \    \

Received on Wed Jun 23 1999 - 07:05:51 CDT