OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01013

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01013 [message #41046]

Wed, 20 November 2002 07:35

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 ?

Report message to a moderator

Re: ORA-01013 [message #41048 is a reply to message #41046]

Wed, 20 November 2002 07:43

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.

Report message to a moderator

Re: ORA-01013 [message #41050 is a reply to message #41048]

Wed, 20 November 2002 08:37

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.

Report message to a moderator

Re: ORA-01013 [message #48250 is a reply to message #41046]

Wed, 03 November 2004 23:47

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

Report message to a moderator

Previous Topic:	Can I execute this without "UNION ALL"?
Next Topic:	how to see all the tables in the given tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 26 05:58:08 CDT 2025