Recent IT Questions

1 - 1 of 1
<<PREVIOUS 1 NEXT>>

What causes ora-00904 error on valid fields when querying across dblink in a cursor

I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the link and all...

View Answer   |  Jun 12 2008   11:18 PM GMT   |  asked by Tom msu
ORA-00904, DBLink, Cursor


1 - 1 of 1
<<PREVIOUS 1 NEXT>>