Batch SQL hangs on locked row

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Fri, 16 Mar 2001 09:39:39 -0800
Message-ID: <F001.002CEDD6.20010316062026@fatcity.com>

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_at_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_at_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). Received on Fri Mar 16 2001 - 11:39:39 CST