7 Replies Latest reply on Oct 8, 2014 10:21 AM by LouieWarren

    ORA-00900: invalid SQL statement (ColdFusion/Java)

    LouieWarren Level 1

      I found a bunch of topics on this subject, but none seem to exactly be doing what is going on for me.

      I have a ColdFusion/Java routine that displays funding requests that need to be approved. When you click on the action button, you can either approve or disapprove. When the user presses the button, I get the error message via e-mail with a copy of the trace. It shows me the statement that isn't valid. I copy it and run it in SQL*Plus on my Production database. It returns the row expected. How can that be? Confused.

      Here is the trace [link]https://dl.dropboxusercontent.com/u/3594970/1244Err.txt

      Oracle 11g on a Windows server