from pl/sql table getting error - "ORA-01403: no data found"
580488May 12 2009 — edited May 12 2009Hi All,
i habe written package, and the spce define as -
...
...
..
type F761RecType is RECORD (
...
...
);
type F761TabType is TABLE of F761RecType INDEX BY BINARY_INTEGER;
l_F761_table F761TabType;
PROCEDURE modification1
(
p_F761_table IN F761TabType,
);
---
From button click of form i passed -
DECLARE
l_f761_table I743_PUC_MAPS_TREE_PKG.F761TabType;
l_counter number;
BEGIN
LOOP
l_counter :=l_counter+1;
l_f761_table(l_counter).P_TABLE := :MAPS.P_table;
EXIT WHEN :SYSTEM.LAST_RECORD = 'TRUE' ;
next_record;
end loop;
i743_puc_maps_tree_pkg.modification1(
p_F761_table => l_f761_table,
);
END;
---------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Now when I take table count (l_f761_table.count) in button click in form level I am getting value; but when I try to get the count in sid the package, it giving error "ORA-01403: no data found".
Pls tell me where I am wrong ..!!
BR,
Subir