Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using bind variables in Oracle SQL developer

676422Apr 15 2009 — edited Apr 15 2009
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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 13 2009
Added on Apr 15 2009
2 comments
32,562 views