TWO-TASK - Test Window Error.

[EC]

I have had a problem in the last couple versions of the application in which if I try to right-click a specific program (package procedure) to test, I receive an error two-task window cannot be established. It leaves the test window completely blank.

When I try to right click on the package procedure I want to test, that option is not available. This occurs only for this particular package. All others work as I would expect them to.

Any ideas?

 

[EC]

Just wanted to update with the specific error message...

ORA-03117 - two-task save area overflow.

I can reproduce this on demand from only one package.

 

[Marco Kalter]

This error suggests an Oracle Client/Server bug. Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[EC]

Just wanted to mention that I did open an SR / TAR with oracle as well. I believe this could be related to a bug they are experiencing starting with Oracle 9i. It relates to record type parameters being passed into a procedure.

PL/SQL Developer
Version 7.0.3.1123 (MBCS)
02.31345 - 50 user license
Windows NT version 4.0 (build 1381) Service Pack 5

Physical memory : 522,224 kB (85,468 available)
Paging file : 1,276,320 kB (916,820 available)
Virtual memory : 2,097,024 kB (1,989,984 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: D:\oracle\ora92\bin\oci.dll
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\echapman\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
Quick/ER - Gotterup.Net (C:\Program Files\PLSQL Developer\PlugIns\QuickERPlugin.dll)
(* is Active)

Aliases

Homes
OraHome92 (D:\oracle\ora92)

DLLs
D:\oracle\ora92\bin\oci.dll

TNS File

Using
Home: OraHome92
DLL: D:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.7.0
Character size: 1 byte(s)

 

[Marco Kalter]

If you can send me the header of the function or procedure, as well as the required type definitions, I could try to reproduce this on 9.2, and verify if other client versions do not have the same issue.

You could also do this experiment yourself of course. Install a 10g client, connect to the same 9.2 database, and try again.

 

[EC]

Thanks, but even on some platforms of Oracle on 10.2, it is still an issue.

I initially had thought it an application problem, but it isn't.

Thank you for your kind responses.

 

[Marco Kalter]

Will you send me the function or procedure header and the required type definitions?