ORA-00900 invalid SQL statement

  • KM03240759
  • 05-Sep-2018
  • 17-Dec-2018

Summary

ORA-00900 invalid SQL statement

Question

How to define a variable used in SQL and runs fine in SiteScope database query monitor?
example: How to make the variable u_name working in Sis in the following case? define u_name = 'APPS'select username from v$sessionwhere username like '&u_name';undefine u_name

Answer

A ER has been created to report the ORA-00900 invalid SQL statement, Query contain a variable
https://mysupport.microfocus.com/group/softwaresupport/search-result/-/facetsearch/document/LID/QCCR1I132012