Home » SQL & PL/SQL » SQL & PL/SQL » Timeout Error (oracle 10g)
Timeout Error [message #426328] Thu, 15 October 2009 00:15 Go to next message
pkumar_2008
Messages: 19
Registered: November 2008
Location: usa
Junior Member

Here is the PLSQL code and I am getting Timeout Error when executing the code.

Oracle Error:

ORA-01013: user requested cancel of current operation.


Code

BEGIN
SELECT * BULK COLLECT
INTO L_TRANSACTION
FROM BPHADMIN1.TRANSACTION
WHERE TRUNC(WHENMODIFIED) < = (SYSDATE - V_MASTER_RETAIN);

FORALL I IN L_TRANSACTION.FIRST .. L_TRANSACTION.LAST

INSERT INTO TRANSACTION VALUES L_TRANSACTION(I);

COMMIT;
INSERT
INTO WF_ARC_ERROR VALUES
(
SYSDATE ,
0 ,
'WF_ARCHIVE',
'TRANSACTION TABLE ROWS Are Successfully Archived'
);
EXCEPTION
WHEN OTHERS THEN
ERROR_CODE := SQLCODE;
ERROR_MSG := SUBSTR(SQLERRM,1,180);
INSERT
INTO WF_ARC_ERROR VALUES
(
SYSDATE ,
ERROR_CODE ,
'WF_ARCHIVE-MAIN',
ERROR_MSG
);
END;


Please,let me know what changes I need to make to get rid of the error.
Re: Timeout Error [message #426332 is a reply to message #426328] Thu, 15 October 2009 00:22 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Your post title and actual error message you show, don't match.

Please copy and paste actual SQL *Plus session with error message.

Have you searched anything for your error?

regards,
Delna
Re: Timeout Error [message #426334 is a reply to message #426332] Thu, 15 October 2009 00:29 Go to previous messageGo to next message
pkumar_2008
Messages: 19
Registered: November 2008
Location: usa
Junior Member

Thank you for the response..

I did some research on this issue but not useful
Re: Timeout Error [message #426337 is a reply to message #426334] Thu, 15 October 2009 00:34 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Quote:
Please copy and paste actual SQL *Plus session with error message.


regards,
Delna
Re: Timeout Error [message #426339 is a reply to message #426328] Thu, 15 October 2009 00:40 Go to previous messageGo to next message
pkumar_2008
Messages: 19
Registered: November 2008
Location: usa
Junior Member

Tibco tool is invoking the plsql procedure and we have an error table to store all the logs.

I have attached the snapshot of the error..
Re: Timeout Error [message #426340 is a reply to message #426328] Thu, 15 October 2009 00:43 Go to previous messageGo to next message
pkumar_2008
Messages: 19
Registered: November 2008
Location: usa
Junior Member

No Message Body
  • Attachment: error.GIF
    (Size: 10.94KB, Downloaded 121 times)
Re: Timeout Error [message #426344 is a reply to message #426339] Thu, 15 October 2009 00:46 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Quote:
ORA-01013: user requested cancel of current operation
Cause: The user interrupted an Oracle operation by entering CTRL-C, Control-C, or another canceling operation. This forces the current operation to end. This is an informational message only.
Action: Continue with the next operation.


regards,
Delna
Re: Timeout Error [message #426347 is a reply to message #426344] Thu, 15 October 2009 00:51 Go to previous messageGo to next message
pkumar_2008
Messages: 19
Registered: November 2008
Location: usa
Junior Member

Was anything wrong in the code?
Re: Timeout Error [message #426352 is a reply to message #426347] Thu, 15 October 2009 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Except that:
1/ it is not formated as explained in OraFAQ Forum Guide
2/ You use WHEN OTHERS without RAISE
3/ You commit at each row
4/ You commit only the first part of what is done for a row and commit the second part only when you handle the next row
5/ You don't commit the last part of the last row
All this seems to be an inconsistent transactional behaviour and a performances killer (although hopefully PL/SQL didn't really commit when you ask for it).

Regards
Michel
Re: Timeout Error [message #426353 is a reply to message #426347] Thu, 15 October 2009 00:59 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
By seeing error message you provided, it should not be.

Did you get this error message while running it first time?
If that code has executed successfully ever before, then we can expect that it does not contain any fault.

regards,
Delna
Re: Timeout Error [message #426354 is a reply to message #426353] Thu, 15 October 2009 01:06 Go to previous messageGo to next message
pkumar_2008
Messages: 19
Registered: November 2008
Location: usa
Junior Member

I am getting this error only when I use 3rd party tool for execution else No errors encouted when executed in sqlplus.
Re: Timeout Error [message #426355 is a reply to message #426354] Thu, 15 October 2009 01:08 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Tibco tool is invoking the plsql procedure and we have an error table to store all the logs.

You can set your timeout property for the tibcotool

Sriram.
Previous Topic: Receiving this error for a procedure call with plsql table as input pmtr
Next Topic: Proc to return a REF CURSOR using dynamic SQL
Goto Forum:
  


Current Time: Tue Sep 27 11:05:52 CDT 2016

Total time taken to generate the page: 0.14285 seconds