The semicolon denotes the end of the anonymous block and the slash executes
it, so it's not executing twice.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).