I have problem with plugin ActiveQueryBuilder

[Sport$man]

Developer: 7.0.3.11.23
I downloaded and installed plugin ActiveQueryBuilder. When try to add table from the table list I'm getting error: "Access violation at address ... in module 'ActiveAueryBuilder.dll'. Read of address 000000000" Could you tell me please, what's wrong? Does AQB work with the latest version of PLSQLDeveloper?

 

[Marco Kalter]

It should work. Can you let me know your Oracle Server version? Can you also let me know if this is reproducible?

 

[Sport$man]

Yes, certainly I can, I ought to write it in the first topic:
Oracle 9.2.0.5
In my case it is 100%-reproducible, not from time to time, so i can't add any table to QBuilder. Oh! Just a moment! It seems i found some problems:
1. I can add table to AQBuilder my own only. if i'm trying to add tables from other schema (i have grants on them and can select from them in SQL-window) - i usualy get ora-00942 error (table doesn't exist).
2. It seems QueryBuilder Doesn't work correct with russian (and possible others national) table names: if i'm table owner and table name doesn't include russian simbols - table can be added.
Should i use SQL only or this problem can be solved?
Forgot to write database national charset - RUSSIAN_CIS.CL8MSWIN1251

 

[Marco Kalter]

Okay. I will upload a test version for your shortly.

 

[Marco Kalter]

Can you try this version ?

 

[Sport$man]

Sure, I can! Just a minute

 

[Sport$man]

All the same problems. Can't add not my own table.
Error adding table with russian talename.

 

[Marco Kalter]

Still an access violation?

 

[Sport$man]

Yes, still an access violation. If you need a violation address - 036C17DB.

and still ora-00942 if adding not my table

 

[Sport$man]

Excuse me, Marco. It seems I was wrong installing new plugin version. And it looks like the access violation problem was solved. But now I still have such problems:

1. When adding table from a different schema there is no any reference to schema name in sql-text.
2. In added to Builder tab table (if this one from another schema again) I can see one checkbox only - * (for selecting all columns). But I can't see any other column in the "table".
3. As described in Poei topic - black text tab (it si possible to read sql-text if highlighting)

 

[Marco Kalter]

Okay, I'm glad the access violation is fixed. We still need to look into the remaining issues, and will hopefully have a fix available shortly.

 

[Marco Kalter]

Can you try this version ? It should fix the remaining issues.

 

[Sport$man]

Great! It's okay now, indeed!
Thank you for good work.