Timeout Error [message #426328] |
Thu, 15 October 2009 00:15  |
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 #426355 is a reply to message #426354] |
Thu, 15 October 2009 01:08  |
 |
ramoradba
Messages: 2457 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.
|
|
|