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!

Dynamic SQL- ORA-01006: bind variable does not exist

777182Aug 16 2010 — edited Sep 7 2010
Hi,

I wrote a Dynamic SQL code that distributing records to different tables based on variable for the table name.
The data is being retrieved from a staging table that also include the targer table name.

I have no problem executing the code on my computer. However when my colleague tries to run it on his station he receives the follwoing Oracle error message:

ORA-01006: bind variable does not exist

The code does not require the user to insert any parameters and all the require data available in the staging table.

Please let me know the reason for that error. Is it related to different session parameters? Because I have no problem executing it on my satation.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Aug 16 2010
23 comments
16,290 views