Hi Everyone, I'm in the middle of debugging a VB app that calls a stored proc. The stored Proc checks tables and under certain conditions copies records to another table. Depending on where I run the stored Proc from I get a different number of records copied.

VB - 0 records Copied.
Toad - 6 records copied.
SQL navigator - 0 records copied.
SQL Worksheet 6 records copied.

I've checked the data and the code and the correct answer is 6. Anyone have any ideas why this would happen?

Steve.

Steven Howes wrote:
None. Nor is any help possible given what little you've told us.
My guess ... the userid for Toad and SQL Worksheet is different
than what is being used with SQL Navigator and VB.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

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