Oracle PL/SQL - Bind Variables Basic Issue - ORA-00900

809 Views Asked by At

I am trying to use BIND variables in Oracle SQL Developer, but each time I execute I got

ORA-00900 'Invalid SQL statement" Error.

Here is my code:

VARIABLE v_bind1 NUMBER;

Here is error that I get: https://s27.postimg.org/edqqt2mhv/bind_variable_problem.jpg

Oracle Database 11g 11.2.0.4.0

PL/SQL Release 11.2.0.4.0

Oracle SQL Developer 1.5.5

1

There are 1 best solutions below

0
On

Ok I found out the problem. I was using command Execute Statement (F9). In order for SQL*Plus command to work I should use Run Script (F5)