Toad World® Forums

sqlplus execute freezes sqlnav ...


#1

Hi!

Try this:

exec dbms_output.put_line(‘Hello’);

Sqlnav freezes.

Regards Piter


#2

I have no problem with this Piter??

*** SCRIPT START : Session:AKOT@HA920.OZ.QUEST.COM(1) 2006/08/02 10:01:52 ***
Processing …
Executing…
dbms_output.put_line(‘hello’);
exec dbms_output.put_line(‘hello’);

PL/SQL completed.

*** SCRIPT END : Session:AKOT@HA920.OZ.QUEST.COM(1) 2006/08/02 10:01:52 ***


#3

Hi!
This is screenshot from my freeeeeze sqlnav :
http://proxy.sawan.com.pl/~lorek/screen.jpg

This situation happends on my laptop and local database, so i will test it on remote databases and other machines today, let you know what I find.

My config : Win XP Prof SP2
ORACLE 10.2.0.2 Enterprise

Regards Piter


#4

Thanks Piter… I await your further testing.
Mine was a remote database.
I tried SQL Nav 5.1 with a local database… but it worked Okay.
When I get a chance, I’ll try 5.5 with a local database too.

Jaime


#5

Results of my tests. tested sqlnav on winXP and MS Windows Server 2003 Standard Edition. So Ececuted fllowing sql: Sql to exec: exec dbms_output.put_line(’’); sqlnav OS tested: Win XP Prof. SP2 MS Windows Server 2003 Standard Edition Oracle databases and OS. 10.2.0.2 WIN32(XP and srv2003, local and remote),10.1.0.2 HP-UX itannium, 10.2.0.2 HP-UX itannium, 9.2.0.6 win32 With all that cnfigurations sqlnav freezes. If i have time i will test with different configurations Regards Piter.

Updated information i have!
So this tests were done with 10.2.0.2 client, with client prior to this it looks like it works. I tested with 10.1.0.1 and 9.2.0.6 and it works ok.

Some news again.
I installed 9.2 client on my pc, then connect via this home, sqlnav freezes :(. Maybe 10g client copied some library to system path, and sqlnav is using them, i don’t know …

Message was edited by: piortek


#6

What i found i sqlnav trace file, when it feezes:

02-sie-2006 11:26:31: [Error Executing(0)]: Access violation at address 026D36B6 in module ‘OraClient10.Dll’. Read of address 000000

This is that library:
http://proxy.sawan.com.pl/~lorek/oraclient10.zip


#7

Thanks for this extra info Piter…
I’ll get one of the developers to investigate the AV address.

Jaime


#8

Just 4 note:
My binaries has applied all minor patches afther 10.2.0.2 patchset.
dir from .patch_storage
4628170_Mar_14_2006_12_43_16
4715104_Jun_27_2006_04_18_21
4772145_Jun_28_2006_10_49_56
5106008_Mar_31_2006_08_31_48
5140461_Apr_14_2006_11_02_56
5211342_May_19_2006_12_24_31
5251025_Jul_04_2006_12_24_31

Regards Piter.


#9

Thanks for the update Piter (and all your investigations)…
Bernard will look at this issue soon.

Jaime


#10

Hi Piter,

I have attempted to reproduce your issue using the same client version as you (10.2.0.2) connecting to a DB of the same version, but to no success. I have a couple of questions to verify with you:

  1. If you execute the same command in SQL Plus, will you get the same problem ?

  2. When “Server Output” enabled in NAV when you executed the dbms_output command ? Could you try executing the command with and without “Server Output” enabled and see if there is any changes in behaviour ?

Thanks.

regards,

Bernard


#11

Hi Bernard!
So, sqlplus woks ok, sqlnav with srv_output on - freezes, with srv_output off - raising error:
(Error): Error executing statement: Access violation at address 026D49B6 in module ‘OraClient10.Dll’. Read of address 00000000
Toad works properly.

What can i check more? If you want, I can share my binaries for you.

Regards PIter
sqlplus.jpeg


#12

Hi Bernard!
So, sqlplus woks ok, sqlnav with srv_output on - freezes, with srv_output off - raising error:
(Error): Error executing statement: Access violation at address 026D49B6 in module ‘OraClient10.Dll’. Read of address 00000000
Toad works properly.

What can i check more? If you want, I can share my binaries for you.

Regards PIter
err.jpeg


#13

Hi!
Maybe this will help.
Oracle Bug 4951251:

PROBLEM STATEMENT:


Customer is Loading a Custom DLL with LoadLibrary which is using OCI

When Using Oracle Instant Client 10.2 and doing FreeLibrary on Custom DLL,

OCI.DLL is unloaded as well but not oraociei10.dll. And when Loading the

Custom DLL which loads OCI.DLL, oraociei10.dll is not loaded at all and the

OCI functions are failing. Profiling with dependeny Walker show that OCI.DLL

does not try to load oraociei10.dll, however it tried to load

oraociicus10.dll, which is not available for this client at that time. This

will not fail with Oracle Instant Client 10.1.0.4

.

This is not the case with Oraclient9.dll /oraclient10.dll / oraociicus10.dll

(Oracle Instant Client Light /Lite), however all these DLL’s remain in

Process memory which should be a bug as well

REDISCOVERY INFORMATION:

If an application loads the OCI.DLL dynamically and frees it, this problem will

be encountered. Application may crash and instant client DLL will remain loaded

in memory even when oci.dll is freed.

WORKAROUND:

Free the instant client DLL in addition to oci.dll

RELEASE NOTES:

]]If an application loads the OCI.DLL dynamically and frees it, this problem wi

]]ll

]]be encountered. Application may crash and instant client DLL will remain load

]]ed

]]in memory even when oci.dll is freed.


#14

Hi! I have something new!!! When spool output is disabled error occurs, when enabled not!!!
Assuming, when spooler is disabled, output enabled , execute sqlplus exex command freezes sqlnav. Looks like Sqlnav can only execute sqlplus command with active spooler.
Check this!


#15

Hi Piter,

You are spot on ! I have managed to reproduce your issue when spool output is disabled. Does this problem still occur (when spool output is disabled) when you’re using a non-10G client ?

In any case, I will raise a CR for this issue. Thank you again for your input.

regards,

Bernard


#16

Hi Bernard!
Unfortunetly I don’t have pc with single Ora9i installed, all available machines has at least two clients, 10 and 9. When I try this issue connecting by Ora9 Home - error occurs too.

Regards Piter