Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL and PL/SQL: different results?

SQL and PL/SQL: different results?

From: Daniel Pinyol <dpinol_at_cesca.es>
Date: 1997/01/07
Message-ID: <32D23621.41C6@cesca.es>#1/1

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 single
user (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.

 

-----------------------------------------------------------------------
Daniel Pinyol Laserna E-Mail: dpinol_at_cesca.es
-----------------------------------------------------------------------
Received on Tue Jan 07 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US