Hi When i try to update a remote

[cyno]

Hi

When i try to update a remote database table inside a cursor using the dynamic sql iam getting invalid column name error.Iam passing the query into a variable.when i use the same in the local database it is working fine.Any idea why it is not working?

ORA-00904: invalid column name

 

[carp]

OK, just to confirm:
1. You have SET SERVEROUTPUT ON
2. When you run the code, none of your dbms_output calls get displayed?

 

[carp]

And SantaMufasa and I still need confirmation that you used double quotes when creating the table names that start with numbers. Are you using double quotes when you reference these tables? The code that you've posted doesn't.

 

[carp]

Cyon -
Assuming that the error is being generated when your EXECUTE IMMEDIATE commands are trying to execute, I think I would try the following:

1. Comment out all of your execute immediate lines.
2. Run the script. The commands your execute immediate lines would be trying to run will be displayed.
3. One by one, try to run the displayed commands EXACTLY as they are displayed (cut and paste!).

This should allow you to figure out which command(s) are malformed.