SOLVED-ORA-01013: user requested cancel

S

shall

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,581
Members
45,056
Latest member
GlycogenSupporthealth

Latest Threads

Top