Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Utl_file question
did you forget the END;
Begin
..
..
end;
*>-----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
![]() |
![]() |