Re: Different results from stored Proc when run from differentprograms.

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 24 May 2005 13:04:06 -0400
Message-ID: <dqWdnSA_24UXww7fRVn-tQ@comcast.com>

"Steven Howes" <howserx_at_hotmail.com> wrote in message news:d6vmfn$r0a$1_at_titan.uwinnipeg.ca...
> 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.
>
>

A couple thinks come to mind:

Different connections (different Oracle credentials) Transactions are not being managed as assumed

++ mcs Received on Tue May 24 2005 - 12:04:06 CDT