number of elements in PL/SQL table
295545Dec 14 2004 — edited Dec 14 2004Hi all
I have general question . I want to display web page based on cursor's result.
CURSOR cur_job IS
SELECT employee_name,company_name
FROM employee
;
TYPE rec_one IS TABLE OF cur_job%ROWTYPE INDEX BY BINARY_INTEGER;
r rec_one;
BEGIN
l_total_rec := rec_one.COUNT;
.......
END;
trying to compile is giving me error
PLS-00302: component 'COUNT' must be declared
How can i use .COUNT method and when does PL/SQL table is getting populated with data.I want to get number of record returned by query?
Second table 'r' i am using for different purpose
Thank u all who can help