SOLVED-ORA-01013: user requested cancel

SOLVED-ORA-01013: user requested cancel

am 26.07.2007 16:50:46 von 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