Recent content by g_lagaffe

Hi, I would sometimes need the Large Data Editor as standalone window. If, for example, i use XMLTYPE.GETSTRINGVAL(MyXMLObjekt) in a command window and output it via dbms_output.put_line I get unformated XML-Text, that I would like to copy in my Large Data Editor Window, that I opened for that...

Does the same apply for the C++ Builder 2010 version?

we use version 7.1.0 and version 7.1.1, both have the above problem.

Hello, we have a table with nvarchar2 columns. When we try to add records in a SQL-window we get the following error message: ORA-1461: can bind a long value only for insert into a LONG column. Updating values in the nvarchar2 columns is possible. Is there a workaround for this?

Hello, I seem to be one of the last of the dying breed that still prefers the Command window to the SQL window and encountered the following problem: When I enter a command like select sysdate from dual; in the Editor pane and leave the cursor at the end of the line (i.e. I do NOT press...

Hello Marco, Thanks for your quick response! It definitely seems to be correlated with recursive calls. I stepped into the CPU-Window after the Oracle-exception occured and found out that numerous calls to cc3260mt.___ExceptionHandler are executed. After a bunch of calls (could not find out how...

Hi! The following code (simplified) tries to insert a row into a logging table. When the table already contains an entry, a dup_val_on_index error should be caught and the logging entry updated with the time of the latest request instead. The problem is that although the error is triggered, the...

In the meantime I found the following simple workaround that may be interesting for other RAC-users too: log in with your preferred user and issue the following statement: create or replace synonym V$SESSION for SYS.GV_$SESSION; As private synonyms do have precedence against public synonyms...

we have been switching to a Real Application Cluster (RAC) environment recently and now have the following problem with PL/SQL Developer: When opening the tools/Sessions window we only get the sessions running on the instance currently connected. Obviously the underlying query only uses the...

I often program anonymous PL/SQL Blocks in the Editor Tab of the Command Window. It's very handy for small tasks which only have to be done once and therefore do not need to get functions or procedures. It would be very helpful for this task if the line numbers were shown in the Editor Window...

I encountered the following strange behavior with the sessions window: -open a sessions window -log on as different user without permission to query the v$session view -refresh the sessions window -log in again as user with permission to query the v$session view -refresh the sessions window...

I read in the Beta-Forum that the Shortcuts Plugin by Tiger got disallowed. Me and my collegues use this plug-in extensively. Is there any chance that it is removed from the black list for future releases of PL/SQL-Developer?

from the time we applied the patch as described above we didn't have the problem again. I don't know if the patch is also available for Win2000 and I assumed that the problem should already be resolved in 9.2.0.4 (we had 9.2.0.1 then), but you can check it out.

Hi, I have some difficulties with column formats in the command window e.g. take the following table definition: Name Type Nullable Default Comments ------- ------ -------- ------- -------- NUM NUMBER Y LONGNUM NUMBER Y and execute the following statement to insert a row insert into...

ad 1.) we tried to reload the package but neither recompiling nor replacing the package was possible. Whenever we tried to recompile dbms_debug or one of the referenced packages the corresponding session hangs and can only be killed. ad 2.) we got the new release of PL/SQL-Developer and...