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!

Why an "ORA-01006: bind variable does not exist" error when no dynamic SQL?

Kim2012Dec 21 2012 — edited Dec 21 2012
Hi all,

While running PL/SQL in SQL Developer 3.2.09, I got the following error after adding a section of code. Note that nothing I'm doing has anything to do with dynamic SQL (which is what 01006 is supposedly about).

Error report:
ORA-01006: bind variable does not exist
01006. 00000 - "bind variable does not exist"
*Cause:
*Action:

After commenting out the new chunk of code that caused the error, the error persisted.

After deleting the new code, the error went away.

What the heck!?!? If you have any ideas, please lay 'em on me.

Thanks so much,
Kim

P.S. It's a few hundred lines of code, so I didn't append it to this post and I don't see how to attach a file.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2013
Added on Dec 21 2012
7 comments
2,948 views