ORA-00900 Error

When trying to execute Query Reporter, I'm getting an ORA-00900 (Invalid SQL Statement) error on an Oracle report that runs successfully from within Report Builder.

Here is my command line string that I'm executing from within Cygwin: queryreporter.exe userid=imc_dev/mom#1@dirdev11 exec=qme_test.rep html=qme_test.html quit

Here is my query in my report:

select distinct lname,first,lic_pre,lic_suf
from qme_inv
order by 1,2
/
 
Can you place the userid between quotes and try again?

QueryReporter "userid=imc_dev/mom#1@dirdev11" exec=qme_test.rep html=qme_test.html quit

If this still fails, can you send me a .rep file that reproduces the error?
 
Back
Top