Recent content by Bo Pedersen

We had the ORA-03137 error with database 11.2.0.3.0 using OCI client 11.1.0.6.0 (Instant Client). But no error with same client against another 11.2.0.1.0 database. Upgrading the client to 11.2.0.4.0 removed the problem. See document 752297.1 and note 8625762.8. Oracle error reported to be...

The bind variable shall be of the type Temporary CLOB instead of just CLOB. Then you can set the value using the Large data editor.

Use Temporary CLOB for the input variable in order to be able to set the initial value. And no, I don't think it is possible to set breakpoints in the test window. Perhaps a restriction with anonymous blocks?

In a test window, you shall use a bind variable with the type Temporary CLOB for CLOB input values.

My Oracle Client is: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 I ran the script against a local 11g database. I also tried it against an Oracle9i Enterprise Edition Release 9.2.0.1.0 database which resulted in PL/SQL Developer crashing. But in previous versions of the Oracle...

I have the same behaviour on an 11g database. Furthermore, if I execute the following select: select xmltype('<Hello></Hello>'), xmltype('<Hello></Hello>').getstringval() from all_tables; then the seventh row displays data for the string value but the clob for the XMLtype is empty...

Try looking in Tools -> Preferences -> User Interface -> Date/time. There you can specify a user defined date format or whether to use the Windows format or Oracle format. That could be the difference. Regards Bo Pedersen

I have been using wList since PL/SQL Developer 6, so I didn't notice (or remember) that reordering is implemented as standard now. So I second colouring and the shorter names in the window list. Bo Pedersen

My primary use of wList is the reordering functionality. And secondarily the coloring. Bo Pedersen

It's not necessary to run as administrator when using Oracle Database Client 10.2.0.3 for Vista. See http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html Bo

> - I want to use a dark background, I've been able to set a black background, but I can't change the color for identifiers from dark blue to something else. How can I do that? That should be in Tools -> Preferences -> Editor -> Syntax Highlighting > - can pl/sql developer create a synchronize...

It works as expected in PL/SQL Developer 7.1.1.1339. Bo

For the first issue, just select the columns you want to export. If you don't select the row number then it will not be in the exported file. Bo

Just copy the PlugIns directory to the new installation. Bo Pedersen

Try 'Run as Administrator'. A normal user on Vista does not have access to the Program Files directory, HKLM in the registry etc. Both SQL*Net and PL/SQL Developer assumes access to that. And with UAC, programs started by a local administrator does not execute with administrator privileges. I...