Home » Developer & Programmer » Forms » dynamic query
dynamic query [message #82663] Thu, 19 June 2003 10:08
Alberto
Messages: 4
Registered: April 2002
Junior Member
For example:
Li_cursor := dbms_sql.open_cursor;
dbms_sql.parse( Li_Cursor, 'SELECT INFO1'||
' FROM TABLE1'||' '
||Lv_Criterio||' '||
' ORDER BY Secuencia
'||' , Empresa
',dbms_sql.native);
dbms_sql.define_column(Li_Cursor,1, Table.Info1);

LOOP
IF dbms_sql.fetch_rows(Li_cursor) >0 THEN
dbms_sql.column_value(Li_cursor,1,Pr_RegistrosResultados(Li_contador).Info1);
Li_Contador := Li_contador +1;
ELSE
EXIT;
END IF;
END LOOP;
IF dbms_sql.is_open(Li_cursor) THEN
dbms_sql.close_cursor(Li_cursor);
END IF;
Previous Topic: calculation mode
Next Topic: ITS A MATTER OF JOB
Goto Forum:
  


Current Time: Thu Mar 28 09:21:47 CDT 2024