Oracle SQL Developer: can bind variables begin with upper case letter? -


i'm using oracle sql developer test query used in adf application's read view object. adf documentation recommends using uppercase letter begin name of bind variable. so... i've creatively named mine :bindvariable

funky part sql developer appears dislike bind variables begin upper case letter.

this query works

select * tablename id :bindvariable 

this 1 not

select * tablename id :bindvariable 

am correct in understanding bind variable names cannot begin upper case letter? or there else amiss here?

edit

is oracle sql developer thing? :bindvariable works fine in jdeveloper's database navigator.

thanks reading! input appreciated.

oracle sql developer: can bind variables begin upper case letter?

yes.

there no issue sql developer. have tested on version 3.2.20.10

please see screenshots:

query:

enter image description here

result:

enter image description here

no issues in sql*plus either:

sql> variable bindvariable varchar2(20) sql> exec :bindvariable := 'smith'  pl/sql procedure completed.  sql> select empno emp ename :bindvariable;       empno ----------       7369  sql> 

Comments