Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL and PL/SQL: different results?
Hi,
I'm sure there's something I'm missing.
If I launch select count(*) from ALL_SOURCE; from sqlplus, I get 37703. If I do it from a pl/sql procedure, select count(*) into num from all_source; dbms_output.put_line(num); I get 3769. I thought it was a problem of users, but now I'm only using a singleuser (the owner & launcher of the pl/sql is the same than the user that sends the sql command).
Can anybody help me?
Thanks a lot. I'd appreciate, if possible, the answer by email.Received on Tue Jan 07 1997 - 00:00:00 CST
-----------------------------------------------------------------------
Daniel Pinyol Laserna E-Mail: dpinol_at_cesca.es
-----------------------------------------------------------------------