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
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