Skip to Main Content

SQL Developer

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!

Bug EA 4 (3.0.03.97) Bind Variable Not Declared on Insert from select

pkatsoulisMar 2 2011 — edited Nov 5 2012
Executing the following query

insert into table1
select column1, column2
from table2
where column1 = :variable;

i get "Bind Variable variable Not Declared"


when i run the (remove the insert into line)

select column1, column2
from table2
where column1 = :variable;

everything works fine...

i guess a bug(?)

Edited by: pkatsoulis on 2 Μαρ 2011 6:07 πμ

Edited by: pkatsoulis on 6 Μαρ 2011 11:49 πμ
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2012
Added on Mar 2 2011
15 comments
1,607 views