SOLVED-ORA-01013: user requested cancel

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
shall [ Do, 26 Juli 2007 16:50 ] [ ID #1779180 ]
Webserver » microsoft.public.inetserver.asp.general » SOLVED-ORA-01013: user requested cancel

Vorheriges Thema: XML Package and IP Address
Nächstes Thema: Help needed