Getting "ORA-00936: missing expression" error using Query Describe (4250585)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting "ORA-00936: missing expression" error using Query Describe
Description

When running a Query Describe (Ctrl+F9), an "ORA-00936: missing expression" error is returned.
Cause

The query being described contains a substitution variable. Substitution variables cannot be described because they are not tied to a datatype, which is needed in order to describe.
Resolution

Use a bind variable, instead of using a substitution variable. Bind variables are tied to a datatype and can be described.

Example:
Use...
select :test from dual;

instead of...
select &test from dual;

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title