using bind variables in Oracle SQL developer

676422 Apr 15, 2009 5:08 PM

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

1. Re: using bind variables in Oracle SQL developer

Andy Tael-Oracle Apr 15, 2009 5:15 PM (in response to 676422)

You are probable going to get a quicker answer on this forum : SQL Developer

-- Andy
Like Show 0 Likes(0)

Actions
2. Re: using bind variables in Oracle SQL developer

Walter Fernández Apr 15, 2009 5:41 PM (in response to 676422)
Hi,

Try this
variable myid number exec :myid := 1 select * from mds_3618_request where id = :myid;
Regards
Like Show 1 Likes(1)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.