Hi There

Can you recommend webpage/website where I can find good examples on DBMS_SQL package

Can I use for loop while creating columns ??

source_cursor := dbms_sql.open_cursor;
dbms_sql.parse(source_cursor, 'select fld1 from trapeze.cmbc_tmptrips', dbms_sql.native);
for i in 1..v_count loop
dbms_sql.define_column(source_cursor ,i,id_var);
end loop;




Thanks

samir

[Edited by samir on 12-28-2000 at 02:04 PM]