RE: Utl_file question

From: Patrick Housholder <housholder_at_ualfltctr.com>
Date: Thu, 15 Mar 2001 14:00:14 -0800
Message-ID: <F001.002CE243.20010315130107@fatcity.com>

did you forget the END;

Begin
..

..
end;

---

Patrick Housholder
Sr. Staff Anl Tech Spt Design
United Airlines Flight Training Center
Denver CO

*>-----Original Message-----
*>From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Diana
*>Duncan
*>Sent: Thursday, March 15, 2001 12:36 PM
*>To: Multiple recipients of list ORACLE-L
*>Subject: RE: Utl_file question
*>
*>
*>Well, maybe you just forgot to paste it in, but you need a
*>semicolon at the
*>end of line 10, and a forward slash in the first position of line 11. ;-)
*>
*>Or is that too simple? Otherwise, it looks good to me...
*>
*>Diana
*>
*>-----Original Message-----
*>Sent: Thursday, March 15, 2001 9:43 AM
*>To: Multiple recipients of list ORACLE-L
*>
*>
*>
*>
*>Hallo all experts,
*>
*>I have written this procedure but get this error message. What is wrong?
*>
*>
*> 1 DECLARE
*> 2 emp_data UTL_FILE.FILE_TYPE;
*> 3 BEGIN
*> 4 emp_data := UTL_FILE.FOPEN ('c:\', 'pelle.xls', 'W');
*> 5 FOR BAKERS IN (
*> 6 select AVDNR, DATO
*> 7 FROM BAKERS) LOOP
*> 8 UTL_FILE.PUT_LINE (emp_data, TO_CHAR(BAKERS.DATO ) ||',"'||
*>BAKERS.AVDNR || '"');
*> 9 END LOOP;
*> 10* UTL_FILE.FCLOSE (emp_data)
*>
*>DECLARE
*>*
*>ERROR at line 1:
*>ORA-06550: line 11, column 0:
*>PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
*>following:
*>:= . ( % ;
*>
*>
*>Hope anyone can help me.
*>
*>Roland Sköldblom
*>
*>
*>
*>--
*>Please see the official ORACLE-L FAQ: http://www.orafaq.com
*>--
*>Author:
*> INET: Roland.Skoldblom_at_ica.se
*>
*>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: Diana Duncan
*> INET: dduncan_at_arsenaldigital.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: Patrick Housholder
  INET: housholder_at_ualfltctr.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 Thu Mar 15 2001 - 16:00:14 CST