DBMS_SQL.DEFINE_COLUMN [message #9289] |
Fri, 31 October 2003 02:10 |
Max
Messages: 18 Registered: May 2002
|
Junior Member |
|
|
hello, I've the follow code:
begin
r := 0;
i_cur := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(i_cur, v_select, DBMS_SQL.NATIVE);
DBMS_SQL.BIND_VARIABLE(i_cur, ':n_anno', n_anno);
DBMS_SQL.DESCRIBE_COLUMNS(i_cur, col_cnt, rec_tab);
FOR i IN rec_tab.FIRST..rec_tab.LAST
LOOP
r := r + 1;
DBMS_OUTPUT.PUT_LINE(rec_tab(i).col_name||' - '||r);
END LOOP;
FOR i IN 1 .. r LOOP
--t(i) := 0;
DBMS_SQL.DEFINE_COLUMN(i_cur, i, t(i)); <----
DBMS_OUTPUT.PUT_LINE(t(i));
END LOOP;
...
When I run the proceduer, it go in exception(in arrow line <---):
ORA-01403: no data found
ORA-06512:... at line 339
Thanks
|
|
|