ORA-00900 invalid SQL statement

  • Document ID:KM03240759
  • Creation Date:05-Sep-2018
  • Modified Date:17-Dec-2018
    • Micro Focus Products:
      sitescope 11.32

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