RE: Batch SQL hangs on locked row

From: Paul Baumgartel <PaulB_at_instipro.com>
Date: Fri, 16 Mar 2001 09:37:50 -0800
Message-ID: <F001.002CF286.20010316093528@fatcity.com>

The semicolon denotes the end of the anonymous block and the slash executes it, so it's not executing twice.

Paul Baumgartel
InstiPro, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103 (office)
917 549-4717 (mobile)

-----Original Message-----

Sent: Friday, March 16, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
INET: PaulB_at_instipro.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