May 6, 2019
Coldfusion 2018 error
May 6, 2019
Coldfusion 2018 error
Newbie 2 posts
Followers: 0 people


We are using coldfusion 2018 on a windows 2016 server. We are getting an error as shown below, please advice how to fix this ?

I have already checked and recompiled the database packages and all looks good with this.



Error Executing Database Query.

ORA-00936: missing expression ORA-06512: at “DBO.REPORT_PKG”, line 490 ORA-06512: at “DBO.REPORT_PKG”, line 48 ORA-06512: at “DBO.MULTI_REPORT_PKG”, line 31 ORA-06512: at line 1
The error occurred in C:/inetpub/wwwroot/eOPS/MultiSectionReportsResults.cfm: line 69
67 : 
68 : <cfquery name="PrepareMultiReportData" datasource="#datasource#" username="#Session.UserName#" password="#Session.password#">
69 :     BEGIN dbo.multi_report_pkg.run_multi_report(#Session.multi_rep_id#, '#Session.UserName#', #multi_report_def_id#, TO_DATE('#DateFormat(datefrom, "dd-mm-yyyy")# #TimeFormat(datefrom, "HH:mm:ss")#', 'DD-MM-YYYY HH24:MI:SS'), TO_DATE('#DateFormat(dateto, "dd-mm-yyyy")# #TimeFormat(dateto, "HH:mm:ss")#', 'DD-MM-YYYY HH24:MI:SS'), #period#); END;
70 : </cfquery>
71 : 

SQLSTATE   42000
SQL    BEGIN dbo.multi_report_pkg.run_multi_report(12382, ‘fquresh2′, 10, TO_DATE(’06-05-2019 00:00:00’, ‘DD-MM-YYYY HH24:MI:SS’), TO_DATE(’06-05-2019 23:59:00′, ‘DD-MM-YYYY HH24:MI:SS’), 2); END;

Browser Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko
Remote Address ::1
Referrer http://localhost/TOPS/MultiSectionReports.cfm
Date/Time 06-May-19 10:35 AM
Stack Trace
at cfMultiSectionReportsResults2ecfm2027920610.runPage(C:/inetpub/wwwroot/TOPS/MultiSectionReportsResults.cfm:69) at cfMultiSectionReportsResults2ecfm2027920610.runPage(C:/inetpub/wwwroot/eOPS/MultiSectionReportsResults.cfm:69)

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
ORA-06512: at "DBO.REPORT_PKG", line 490
ORA-06512: at "DBO.REPORT_PKG", line 48
ORA-06512: at "DBO.MULTI_REPORT_PKG", line 31
2019-05-07 00:28:39
2019-05-07 00:28:39

This question was somehow repeated 3 times. I replied here only to see others replying to one of them. I will remove my reply here and post it there.

Can other responders seeing this also please keep replies directed at just that one:

And I hope the poster, iq1, will delete all but that one to avoid further confusion.

2019-05-06 20:16:05
2019-05-06 20:16:05

Let’s start with having you clarify what has changed–between when it last worked, and now, when it does not.

If you may say you applied a cf2018 update, do check out

Also, as for the jdbc driver for oracle, is it the one that Adobe provides with CF, or one you implemented.

Finally, what cf2018 update are you on? 

Add Comment