«
»

PLS-00103: Encountered the symbol "" WHEN expecting one OF the following

I recently came across this error whilst developing stored procedures in oracle. The stored procedure will be built in Oracle but marked as invalid. Trying a re-compile will give you the above error.

The problem appears to be with Windows CRLF characters on line breaks. Oracle does not treat this as white space, instead it sees it as an empty string. In order to get round this problem, convert the CRLF characters to LF characters and Oracle should be happy.


This entry was posted on Tuesday, February 17th, 2009 at 4:06 pm and is filed under Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “PLS-00103: Encountered the symbol "" WHEN expecting one OF the following”

  1. Apsik POLAND Windows Vista Mozilla Firefox 3.0.11 Says:
    July 9th, 2009 at 11:18 am

    Hi, thanks for this one. I googled it out after I wasted about 5 hours of time.
    This is real issue with Oracle and they should fix it with some sot of patch.
    Best regards

  2. Siva UNITED STATES Windows XP Mozilla Firefox 3.5.2 Says:
    October 6th, 2009 at 4:45 pm

    Hi,

    thanks for this one. this really helped and saved our time in debugging this.

    Thanks

  3. Tomas Z. CZECH REPUBLIC Windows XP Mozilla Firefox 3.5.3 Says:
    October 13th, 2009 at 2:23 pm

    Hallo, so did I as Apsik, thanks a lot too!

  4. Priya V UNITED STATES Windows XP Internet Explorer 7.0 Says:
    November 23rd, 2009 at 9:32 pm

    OMG!! Thank you!! It worked when i removed all the line breaks…I was breaking my head over this for an hr!! Really appreciate it! :)

Leave a Reply

foreandaft