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

SOLVED-ORA-01013: user requested cancel

P: n/a
I was getting this error message using an ASP
to run a stored procedure in ORACLE.
ORA-01013: user requested cancel of current operation

My stored procedure was taking a long time to process.
Which is what I expected.

In the ASP page:

set cmd = server.CreateObject ("ADODB.Command")
with cmd
set .ActiveConnection = cnn3
..CommandTimeout=300 '' <= I added This
..CommandText = mySQL
..CommandType = 4 'adCmdStoredProc

I set it to 300 now the web works.
I hope this helps someone else.
Steve

Jul 26 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.