From rlsmith@kmg.com Fri, 16 Mar 2001 09:39:39 -0800 From: "Smith, Ron L." Date: Fri, 16 Mar 2001 09:39:39 -0800 Subject: Batch SQL hangs on locked row Message-ID: MIME-Version: 1.0 Content-Type: text/plain I just noticed the "/" at the end of this sql that is run from a scheduled batch job. It seems to me that this may cause the sql to execute twice. Once when the sql is called and a second time when the "/" is encountered. Does this sound possible? (I have deleted most of the code and replaced it with .....stuff). DECLARE --------------------------------- --Declare Cursor --------------------------------- CURSOR chkreq_cur IS SELECT .........stuff FROM STARS.kmg_checkreq_api WHERE capi_org_id ='8'; --------------------------------- --Declare Variables --------------------------------- buffer varchar2(4000); fileID utl_file.file_type; fileID_Errlog utl_file.file_type; Counter NUMBER:=0; CurrDate varchar2(25):=TO_CHAR(SYSDATE,'DD-MON-YY HH:MI PM'); BEGIN --open the file for output fileID:=utl_file.fopen('d:\data\ap_interface\ep','lcchkreq','W'); .....stuff EXCEPTION WHEN UTL_FILE.INVALID_PATH THEN UTL_FILE.PUT_LINE (fileID_Errlog,'invalid_path on '||CurrDate); UTL_FILE.FCLOSE(fileID_Errlog); .....stuff END; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: rlsmith@kmg.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).