Problems with procedure and plsql compilation

[rpillot]

When I try to compile and old procedure (oracle 8.1.7) with plsql developer 7 with an oracle 10g database, I reach the error :
Error: PL/SQL: ORA-00904: "FLAG" : identificateur non valide

EXPLANATION :
Before :
select flag into v_flag from my_table@my_dblink;
=> OK !!!
Now with 10g :
Error: PL/SQL: ORA-00904: "FLAG" : identificateur non valide
For information, It works fine with SQL*Plus so I think it's really a syntax problem or a plsql developper problem !!!
Now, when I remplace it with :
execute immediate 'select flag from my_table@my_dblink' into v_flag ;
It works fine too (with Plsql Developer compilation) !!!

Can you explain me where is the problem or why this error ?
Thanks
Remi

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[rpillot]

For those people who have the same problem, here's the response of the oracle support :

"maybe you are hitting the bug 5245451 which is fixed in 11i and there exist some backports
for different 10g version and platform but there doesn't exist for Windows 2003."

So this is a "well-known" bug for the oracle database, nothing about Plsql Developer

Best regards
Remi PILLOT