-2

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

Nick Krasnov
  • 26,886
  • 6
  • 61
  • 78
user7369163
  • 11
  • 2
  • Possible duplicate of [How do I use variables in Oracle SQL Developer?](http://stackoverflow.com/questions/5653423/how-do-i-use-variables-in-oracle-sql-developer) – Aleksej Jan 03 '17 at 11:40
  • Nothing wrong with the statement. The version of SQL Developer is way too old. [Download latest one, which is 4.2](http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html) – Nick Krasnov Jan 03 '17 at 12:27
  • Thanks for your answer, but DECALRE SQL*Plus function should be supported by 1.5.5 : http://www.oracle.com/technetwork/developer-tools/sql-developer/sql-worksheet-commands-097146.html. Also I have the same problem with, for example EXECUTE function – user7369163 Jan 03 '17 at 12:34
  • Do you see any mentionings of `DECLARE` or `EXECUTE` in your original question? – Nick Krasnov Jan 03 '17 at 13:13

1 Answers1

1

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)

user7369163
  • 11
  • 2