In my store rprocedure I am doing insert usinf as select
I want to know how many data inserted ??
How can I find out....run time
Can't you do a SELECT COUNT(*) using the same query as the AS SELECT, push it to a variable and return it, or DBMS_OUTPUT it?
OCP 8i, 9i DBA
Or.. you may use implicit cursor attribute %ROWCOUNT