By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

aspnet.exe and ORA-02046

P: n/a
Hi:

I am developing a web application in C# where the web forms access classes
in c# that invoke stored procedures in oracle 8i. These procedures get data
from an Oracle 9i Database via dblinks. The first time they are used, they
return data successfully. The second time they are run I get and Oracle error
(ORA-02046, Transaction already begun).

After that...I can not make any more searches using those stored procedures,
but when I restart the IIS....I can use them again. I use them once....and
they go back again to the transaction error mentioned above.

I verified the classes and methods I created. All of them disposed their
connections, dataset, etc....so there is nothing remaining in memory.

Is the aspnet.exe worker process holding the transaction? If so...why?

Here is a sample of one of the procedures:

PROCEDURE sp_SUB_ConsultaporRecibo(numrecibo IN NUMBER,
io_cursor IN OUT t_cursor) AS

BEGIN

close io_cursor;

OPEN io_cursor FOR
SELECT * FROM SYN_CONSULTARECIBO
WHERE
num_recibo = numrecibo;

COMMIT;
END sp_SUB_ConsultaporRecibo;
I included the commit because it was one of the recommendations made by an
Oracle use that had a similar problem.

I will greatly appreciate your help
Thanks in advance;

Efrain

Apr 18 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.