Recent content by Carlo Sirna

Hi, are there any news about this issue? Will we get some improvements on this feature in version 16? Here is a video that illustrates the problem, if you still think this is a minor issue: p.s: there is a segment in the video that goes totally black for some seconds: it is not a corrupted...

This is at least the third time I report this issue... My Situation: 1. All the tables (like "Customers") for which I want most to use the sql window "linked query" feature have at least 400 active foreign keys 2. I am perfectly able to write the SQL for a linked query by hand, and...

Seriously, please fix this this extremely annoying bug. It's the first thing I check whenever I install a new version or patch of PL/SQL Developer and I am contiunosly getting disappointed since years ago. I have even saved this code snippet: procedure...

Hi, If I try to beautify nested queries like this toy example: select * from (select * from ( select * from (select * from ( select * from (select * from dual) a) b ) c) d) e I get this: select * from (select * from (select * from (select * from (select *...

Hi, Marco, could you please fix this bug? It has been around for quite some time and it is very annoying. thank you

Great! Thank you!

I frequently use pl/sql developer to connect to remote databases and often my customer's database/network administrator have put some rule in place for which inactive sessions get terminated. I know there is already the "check connections" option, but this doesn't seem to be executed...

the "sessions" view, in a clustered server, displays only the sessions running on the same node on which the session view is connected. Now, if you know how to do it, it is easy to customize the queries used by this session view in order to use the cluster-aware gv$instance, gv$lock, gv$sql...

It would be nice if when, I invoke code completion, I get all column names that CONTAIN the text I have already typed: for example: if I type "person.address" and I press F6, I would like to get proposed all these column names "email_address, home_address, invoicing_address". is it there...

Hi, I noticed just now that I posted a draft, sorry. 1. the idea about the "third configuration tab" was about being able to define custom new context menu items for the session window, defined by pl/sql blocks. In the pl/sql blocks I could use the same variables that are available for define a...

The PL/SQL Developer Sessions view does not support RAC environments: it queries the v$XXXX views which show only the sessions running on the RAC node you have been connected to. I To support RAC (and show all sessions running in the cluster) you simply have to switch from the v$session view...

Friedric: giga is right: index organized tables are exactly one of the data structures that cause row movement when data is updated. info you need to know to understand this: 1) the rowid string is not a "random" value: it is the exact phisical position of the record in the database: if the...

here is another part of the fix: inside: OracleData.Pas, in function TOracleDataset.GetRecBufSize: Integer; this: if DataType = ftWideString then ds := Size * 2; must be changed to this: if DataType = ftWideString then ds := Size * 4; since now field.size is in characters and...

Looking back at my sources I remembered that the fix I posted will break RAW fields, since they have "charsize" = 0, and having TOracleQuery.FieldSize returning "charsize" will make Doa allocate zero-sized buffers. I had to add this fix to TOracleQuery.InternalDescribe, to have RAW fields work...

Same problem, same solution: you have to split the XE2 sources in 2 packages. This is a long time problem. it should have been this way also in delphi 7.