Access violation

[deniskolesnikov]

Hello Marco,

From version to version I get the error from time to time:

Access violation at address 60537987 in module 'oracommon9.dll'. Read of address 00000000

I've noticed that it arises when I issue something like:

select * from dual where dummy=:u
or
select :col from a_table

It seems that the colon is the cause.

All the best!
Denis

 

[Marco Kalter]

I this in the SQL Window? Note that it does not support bind variables.

The access violation is probably an Oracle Net bug though.

------------------
Marco Kalter
Allround Automations

 

[deniskolesnikov]

Yes, in SQL window.
It doesn't seem to be an Oracle Net bug because other tools (SQL*Plus, Toad) work with such statements.
Still if there's an Oracle Net (or any other) bug PLSQL Developer must not crash, mustn't it?

Anyway it would be very convenient if Developer's SQL window could work with bind variables e.g.

select * from emp where empno > :empno

yes, we can use such form:

select * from emp where empno > &empno

but, as far as I know, the latter example (ampersand) uses a nonstandard syntax whereas the former (colon) is standard and many tools use it. It would be just great not to have to correct scripts anytime when moving from other tools

Denis

 

[Marco Kalter]

For bind variables you can currently only use the Test Window.

------------------
Marco Kalter
Allround Automations