Our company is currently trying to convert to Oracle 10G with RAC. We are experiencing hangup problems executing functions and stored procedures from the PL/SQL Developer Test window. The problem is random and only occurs with the test windows. We have tested the same functions within our applications without any issues. We also tried other tools (ex: Visual Studio) and could not re-create the problem. The same tests have also been performed within PL/SQL Developer against an Oracle 9i db without incident.
Is anyone else having this problem. Are there any recommendations for debug settings for 10G & RAC?
Example: For testing, I created a very simple function which merely returns "Hello World"
create or replace function testitoutfunction
return varchar2 is
outstuff varchar2(5);
begin
return 'Hello World';
end testitoutfunction;
If I execute this function from a sql window, it always runs successfully:
select testitoutfunction from dual
If I run it from within the PL/SQL test window, the screen hangs up most of the time. I'm clicking the "Start Debugger" (F9) icon. The options within the test window are no longer active and PL/SQL Developer shows the function as running. (red lightening bolt) I finally have to force termination and eventually get the following error "ORA-06508: PL/SQL: could not find program unit being called"
Is anyone else having this problem. Are there any recommendations for debug settings for 10G & RAC?
Example: For testing, I created a very simple function which merely returns "Hello World"
create or replace function testitoutfunction
return varchar2 is
outstuff varchar2(5);
begin
return 'Hello World';
end testitoutfunction;
If I execute this function from a sql window, it always runs successfully:
select testitoutfunction from dual
If I run it from within the PL/SQL test window, the screen hangs up most of the time. I'm clicking the "Start Debugger" (F9) icon. The options within the test window are no longer active and PL/SQL Developer shows the function as running. (red lightening bolt) I finally have to force termination and eventually get the following error "ORA-06508: PL/SQL: could not find program unit being called"
Debug Test Window - Script for p) 2007-05-17 15:06:32.659
