Get record count from Oracle Stored Procedure with out using Count built in function

[mktilu]

i have a stored procedure in oracle 9i as given below.It return the cursor to vb6 recordset .But i dont get the Recordcount in vb6 when i excute.

Oracle 9i code
procedure usp_Proc1(p_cursor OUT REFCURSOR_PKG.Get_REF_CURSOR)
is begin
open p_cursor FOR
select *
from tablename;

end usp_Proc1;


can any one tell how to get record count .I dont want to use Count built in function

[Killer42]

I'm not familiar with this particular situation (never used Oracle) but I do know that sometimes in VB, to get a recordcount you need to use MoveLast. (Then MoveFirst again, of course, to start processing the records).

Perhaps this is one of those times.

[Wamiq Siddiqui]

procedure usp_Proc1(p_cursor OUT REFCURSOR_PKG.Get_REF_CURSOR)
v_COUNT NUMBER;
is begin
open p_cursor FOR
select Count(*) into v_COUNT
from tablename;

end usp_Proc1;