Here’s a weird one… I’m working on a complex SQL select that includes numerous case statements. It is inside a stored procedure I’m creating. When I compile it in 12.7.0.48 I get an error saying it’s hitting end of file, but I know the
statement is valid. The message is :
[Error] PLS-00103 (174: 37): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
. ( ) , * @ % & = - + < / > at in is mod remainder not rem =>
<an exponent (**)> <> or != or ~= >= <= <> and
If I compile it in 12.6 or sql*plus it compiles just fine.
I tried to recreate the scenario in a generic situation so I could send you a test case that would recreate the failure but I can’t seem to recreate it outside of this procedure I’m creating.
Any suggestions on how to get it to you? Without sending you the tables and the script I don’t see how you can recreate and diagnose the problem.
Chris Johnson
IT Systems Analyst
Distribution Logistics
615-855-4371