Hi,
I am getting following error during migration from 6.9.1 P24 to 7.0.2
Migration Log -
--------------------------- Dbms_Output Begin ---------------------------
==========================================================================
Error(s) occured while compiling invalid object GETDATEINPUT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/23 PLS-00103: Encountered the symbol ")" when expecting one of the following:
<an identifier> <a double-quoted delimited-identifier>
current delete exists prior
7/3 PLS-00103: Encountered the symbol "END" when expecting one of the following:
. ( , % from
--------------------------- Dbms_Output End ---------------------------
Any quick help would be much appreciated.
When I opened the function GETDATEINPUT I am seeing same error and code is,
Create Or Replace
Function Getdateinput()
Return Date Is
dateinput date;
begin
Select To_Date('01/01/2015', 'MM/DD/YYYY')
Into Dateinput
END;
And most surprising thing is, I thought may be something got wrong only while migrating our DEV environment from 6.9.1 to 7.0.2
So went to check function code from UAT, there also this function has same error and UAT working absolutely fine.
Now above that I went to check our PROD database which is a remote database not a appliance like DEV & UAT, in PROD this function itself is not there.