DBMS_SQL.DEFINE_COLUMN

Hi, All

  In PL/SQL, I could use DBMS_SQL.DEFINE_COLUMN to define a selected field, Is there have any way to define some fields into a record :

• Table XXX have 30 columns and I select 6 columns only
• and table name is dynamically, X199901, X200012, etc. SELECT F1, F2, F3, F4, F5, F6 FROM XXX
  ...
  DBMS_SQL.DEFINE_COLUMN(cn, ?, recXXX);

not always

DBMS_SQL.DEFINE_COLUMN(cn, 1, s1, 20);
DBMS_SQL.DEFINE_COLUMN(cn, 2, s2, 20);
DBMS_SQL.DEFINE_COLUMN(cn, 3, s3, 20);
DBMS_SQL.DEFINE_COLUMN(cn, 4, s4, 20);
DBMS_SQL.DEFINE_COLUMN(cn, 5, s5, 20);
DBMS_SQL.DEFINE_COLUMN(cn, 6, s6, 20);

Thanks

Chris Chi Received on Tue Sep 26 2000 - 11:29:43 CEST