Re: Different results from stored Proc when run from different programs.

select OWNER, TABLE_NAME from SYS.ALL_TABLES where TABLE_NAME = 'X';

You may have the same table_name with different owners. Depending upon how someone connects to the database, they gain access to one or the other table.

See if there is an Oracle synonym set for your table:

SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE TABLE_NAME='X'; Jim Strehlow, Data911 Oracle DBA, Alameda, CA, USA Received on Tue May 24 2005 - 13:18:57 CDT