Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01013
ORA-01013 [message #41046] Wed, 20 November 2002 07:35 Go to next message
Andrea
Messages: 15
Registered: February 2002
Junior Member
With Oracle9i E.E. Rel. 9.0.1.0.0 during the execution of a stored procedure called by a java program, SOMETIMES i get an

ORA-01013: user requested cancel of current operation

that i can't understand.

Did it happen to anyone ?
Re: ORA-01013 [message #41048 is a reply to message #41046] Wed, 20 November 2002 07:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are u using any setQueryTime()??
or
there might be a deadlock.
check whether the case is repeated, by executing the
procedure, IN SQLPLUS.
Re: ORA-01013 [message #41050 is a reply to message #41048] Wed, 20 November 2002 08:37 Go to previous messageGo to next message
Andrea
Messages: 15
Registered: February 2002
Junior Member
No I'm not using setQueryTime().
I ran the procedure in sqlplus and the error didn't occur. Anyway i got the error two times in 20 days of execution (3 execution per day): the 2nd time I started worrying.
I'll check for deadlocks.
Thanks for your help.
Re: ORA-01013 [message #48250 is a reply to message #41046] Wed, 03 November 2004 23:47 Go to previous message
Pankaj Mandaliya
Messages: 1
Registered: November 2004
Junior Member
This error is due to the timeout time that we specify in java Statment when executing any query....

Increasing the timeout time will solve the problem.

Statement.setQueryTimeout() specify time out here
Previous Topic: Can I execute this without "UNION ALL"?
Next Topic: how to see all the tables in the given tablespace
Goto Forum:
  


Current Time: Sat Jul 26 10:55:02 CDT 2025