Error when using substitution variable in SQL Window

[MartinF]

Hi,

I am getting an error when using substitution variable in SQL Window.

When running the following command in SQL Window

GRANT SELECT ON acpnuxeo_ogi.hierarchy to &tst.nuxeo_ogi;

I am getting the following error:
ORA-00933: SQL command not properly ended

When running exactly the same command in PLSQL Command window it work fine

SQL> GRANT SELECT ON acpnuxeo_ogi.hierarchy to &tst.nuxeo_ogi;
Grant succeeded

Any help appreciated

Regards,

Martin

 

[Marco Kalter]

The SQL Window use an enhanced substitution variable syntax. It does not implicitly remove the "." after the variable name. You would need to use this syntax instead:

GRANT SELECT ON acpnuxeo_ogi.hierarchy to &nuxeo_ogi;

See also chapter 12.3 "Variables" in the User's Guide.