crazy error - PL/SQL Dev 10.0.5.1710

[boaglio]

Hi,

We have been facing a strange error which a column name changes and if you try to compile inside Program Window, it does not show the yellow bar with the error line... just a very small text Compiled with errors =(

Running inside command window:

SQL> alter package pac001 compile;
Warning: Package altered with compilation errors

SQL> show errors
Errors for PACKAGE ADM.pac001:
LINE/COL ERROR
-------- --------------------------------------------------------------------------------------
63/1     PLS-00920: parameter plsql_native_library_dir is not set

SQL>

Running inside SQL* Plus:

SQL>alter package pac001 compile;
Warning: Package altered with compilation errors

SQL>show errors
Erros para PACKAGE BODY pac001:

LINE/COL ERROR
-------- -----------------------------------------------------
3091/5   PL/SQL: SQL Statement ignored
3099/12  PL/SQL: ORA-00904: "A"."ID_COLUNA"
4183/5   PL/SQL: SQL Statement ignored
4287/7   PL/SQL: ORA-00984: column not allowed here
SQL>

I am not sure if this wrong behavior is related to PL/SQL type code (Native or Interpreted)... using both values come up with the same result.

Is there any work around for this ?

My team is switching back to another dev tool for this

 

[Marco Kalter]

I assume there is no line associated with the PLS-00920 error.

Can you go to Tools > Preferences > Oracle / Compiler and set the "PL/SQL Code type" option to "Interpreted"? Verify if this helps.

 

[boaglio]

I have tried both options... still same error =(

We were using Oracle 10.2 Driver and today I tried with 11.2, still same behavior.

The line 63 mentioned above is just a single variable declaration:

v_exists          varchar2(1) := 'Y';

Maybe this is an 64 bits issue... but is there any workaround for it ?

 

[Marco Kalter]

Do you still get PLS-00920? If so, then 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 or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[boaglio]

Ok Marco, take a look please:
http://pastebin.com/V1sdnBEt

 

[Marco Kalter]

Thanks. I still see this statement in the log file:

alter session set plsql_code_type = native

This indicates that the "PL/SQL Code type" preference is still set to "Native" instead of "Interpreted". Can you double-check?

 

[boaglio]

The first log it was "Native" with client "Oracle 11i".

I've created another one, with "Interpreted" and client "Oracle 10g":
http://pastebin.com/BEvmdiEU

All four combinations got the same result:

"Native" + "Oracle 11i".
"Native" + "Oracle 10g".
"Interpreted" + "Oracle 10g"
"Interpreted" + "Oracle 11i"

 

[boaglio]

hello,

What should I do, wait for version 11 to fix it ?

 

[Gustavo]

Hi, Fernando!

Have you tried commenting some code around line 63? I've faced this issue before, but the parser/compiler was getting lost and pointing to the wrong line.

Regards,
Gustavo

 

[boaglio]

Since in SQL*Plus is working fine, it proves that this issue is _not_ related to code error.

It should be something related to processor arch, since is an 64 bits error only.

 

[IvanZ]

PLD is 32bit and it uses 32bit Oracle client atm.