Recent content by blogin

Supppose, I am logged on to a SYS account and want to rename table SCOTT.TESTTAB to SCOTT.TESTTAB1. If so, I'm getting the following error: ORA-01765: specifying tables owner name is not allowed. PL/SQL Developer obviously tries to execute command: 'rename SCOTT.TESTTAB to SCOTT.TESTTAB1'...

In my situation clicking in the result grid does not help - scrollbars are still hidden. Bertrand

Hello, when I execute query, which result grid contains more row/columns than can fit into the window, then vertical/horizontal scrollbar appears and that's correct. But, when SQL window is in maximized state and the main window resizes (even just a bit) both scrollbars disappear. That will...

Thanks for the tip concerning tunrning off multiple connections. If I may, I would say that the functionality of multiple connections should consider the user's habits of previos versions, just to avoid confusion which I (probably not only I) experienced. For example, I'm often using the...

Hello, I noticed new behavior of the PLSQLDev v.9 which is quite dangerous to me. Given that I have PLSQLDev with some SQL windows opened, logged-on to production database. Then I relog to the test database. After that all windows are still logged-on to Production database which is not obvious...

Unfortunately, recently I realized that we have to migrate our all projects to a library that provides a better support. We were waiting a long time to fix some bugs with no response, but our customers are becoming less tolerant of this waiting. It seems that the company does not have the...

Is it already known when this bug will be fixed ?

Thank you for your prompt response. Is there any chance, that it will be fixed ? Unfortunately I cannot use TOracleQuery, because I need to load multiple commands from a file (among which is the one, mentioned above) and then execute them one by one. I think, that it won't be possible with...

There are some problems when passing the following text to the TOracleScript.Lines property: CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED A.B AS public class Test { public static String test(String in) { String result; return result; } }; / In that case, property Commands...

Yes, I know, but I thought that there is a newer version of DOA with this bug fixed or changed dafault state of ConvertCRLF to false - after several months of coding, sometimes I forget that this parameter must be switched to false.

I encountered the same problem in DOA version 4.1 (Delphi 2010), so I've got a question: is this a bug of a DOA or Deplhi's VCL ? If the former: is there a newer version of DOA than 4.1 with this bug fixed ?

We have the same problems sometimes. It would be very helpful to have the possibility to close such a hanging test window, regardless the cause (database error or procedure creator's mistakes).

Thanks, that's exactly what I need. Kind regards

Hello. Our company was forced to execute additional SQL statements after each Oracle session has been created. It is needed to get more privileges than our accouts have by default and achived by executing "SET ROLE ... identified by ..." statement. Without this feature we will not be able to...

Very similar errors (AV inside OCI) I had, when executed TOracleSession.LogOn() (and LogOff too) at the same time inside many separate threads. My solution was to create mutex which prohibits more than one logon/logoff at the same time. Bertrand