2 Replies Latest reply on Apr 15, 2009 5:41 PM by Walter Fernández

    using bind variables in Oracle SQL developer

      Hi all,

      i am using Oracle SQL developer. i want to use the bind variable in my sql.

      variable myid number :=1;
      select * from mds_3618_request where id = :myid;

      but i am getting the below error.

      Error starting at line 2 in command:
      select * from mds_3618_request where id = :myid
      Error report:
      SQL Error: Missing IN or OUT parameter at index:: 1

      Does Oracle SQL developer support bind variables in the SQL statements?

      thanks in Advance

      Vali Shaik