Oracle Server - Re: Different results from stored Proc when run from differentprograms.

Author

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

Mark C. Stock

2005-05-24, 1:23 pm

"Steven Howes" <howserx@hotmail.com> wrote in message
news:d6vmfn$r0a$1@ti
tan.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

Frank van Bortel

2005-05-24, 1:23 pm

Mark C. Stock wrote:

> Transactions are not being managed as assumed
>

Like (auto-) commit?

--
Regards,
Frank van Bortel

Sponsored Links