Access violation

[Denis]

Greetings!

Wenever I put a statement like

select * from dual where 1=:x

PL/SQLDeveloper hangs up saying Access violation at address 60537987 in module 'oracommon9.dll'. Read of address 00000000.

my configuration is
w2k sp3, oracle client 9.0.1,
PL/SQLDeveloper 5.1.3.704

Yes, I khow that PL/SQLDeveloper doesn't support such syntax but why should it crash?

From time to time I need to copy statements into PL/SQLDeveloper from other tools and sometimes I forget to change ":" to "&". It's really sad to have that crash again and again.

I've already asked the question before but
as far as can see there's no fix so far.

Is it a HUGE work just to put a try block into your code?

Respectfully,
Denis

 

[TenGor]

Hy,
i tried your code in Command-Window and in SQL-Window, but PL/SQL Dev never crashes...

In both cases i get the message "ORA-01008 not all variables bound".

I've got PL/SQLDeveloper 5.1.0.654

Greetings
TenGor

 

[Denis]

It seems to happen when oracle client 9.0.1 is used only. See 'oracommon9.dll' in the error message.

Denis

 

[rbrooker]

you could try using 9.2 client, i tried both scenarios, no crashes...