Recent content by Lars J

Sorry, but I finally found the reason for my problem. It should not be possible to change the content of a parameter from a Java-procedure unless it is an array, so my Java-procedure should look like this: public static void returnClob(oracle.sql.CLOB Output[]) throws Exception { Writer out =...

I have got a java-routine on my server that generates text, and returns it in a CLOB to my DOA-application. When trying to access the return value, it runs successfully on Oracle 9.2.0.6.0, but fails on Oracle 10.2.0.3.0 with ORA 22922. I have been able to create a minimal testcase: The...

Hi! I want to be able to alter some NLS-session-parameters before running my reports. I have found some workaround on this forum, but it would be nice if it was possible to store the "alter session" commands together with the report. Regards Lars J

Hi! We have finally started to use DOA 4.0.6, but have run into a problem. We have a table with a BLOB-column. If we insert a row where the BLOB-value is NULL into this table using a TOracleDataSet, DOA inserts an empty-blob instead. The NullLOBIsEmpty-property of the Session-object is set to...

Thank you very much. The trick works! But in a future release, perhaps SaveAsFile and LoadFromFile on LOBs would be nice in addition to the Large Data Editor.

I have got some large CLOBs (containing XML) in my database (35 MB). Instead of opening them in the Large Data Editor, I just want to save them to disk. Is there a simple way of doing this?

For some reason two instances of the procedures suddenly appeard in the content-window, so I am now able to select the one referring to the implementation part. Sorry for the previous message.

Hi! I am using PL/SQL Developer 6.0.3.893. I have got a package-body that contains some internal procedures that may be called recursively. Because of that, I have declared the procedures at the top of the package-body, and the implementation further down. The problem is that when I want to...

The query really transfers a CLOB to the client, and "v$temporary_lobs" reports one cached temporary lob for every clob transferred. This also happends in PL/SQL Developer. If you create a table: create table test_table (clob_column clob), add some data to it, and then execute the query in...

Hi! When executing a query in a dataset that creates temporary LOBs for each column in the result set, the temporary LOBs are not freed until the session terminates. I am using DOA 3.4.6.4 and Oracle 9.2.0.4.0. An example: select substr(clob_column, 1, 5) from test_table where clob_column...

I do not think that will fix it. It may be a limitation in OCI. Oracle supports something they call "Direct Path Loading in Pieces" to support large objects, and it seems that TOracleDirectPathLoader does not support this. If I am really wrong about this, please excuse my lack of...

It seems that OracleDirectPathLoader has a limit of 64K on the data in a single column, and if the size-parameter in the TDirectPathColumn.SetData is larger than 64K, there will be an overflow on the size-parameter and only a smaller portion of the data is loaded. Is this correct? I am using...

PL/SQL-Developer Installation failes on my computer when I have two displays active. It is not possible to hit any buttons on the setup-license-screen. I have got a Matrox DualHead card. When I disable Multi-display, it works. Regards Lars J

I have found that this error does not exists when I am using OracleClient 8.1.6. I will try some newer clients (9.2) when I find time to do it. Lars J

When logging off an OracleSession having ThreadSafe=True, I receive an AV in ntdll. This ONLY happens when I run the application i the debugger. I am using DOA 3.4.6.1, Delphi 5, UpdatePack 1, on Windows 2000 SP3, and Oracle Client 8.1.7. The server is Oracle 8.1.7. I have located the AV to...