Recent content by lev_ko

I would appreciate it if you were to include support of the following Oracle features in the next version of DOA: 1. OCI's session pooling; 2. OCI's connection pooling; 3. Advanced queue usage via OCI; 4. An option to plugin DOA to a proprietary log system. Basically, callbacks before and after...

Will DOA support the following Oracle 9 features: * Connection pooling * OCI.DLL implementation of session pooling Thanks.

I made a mistake in my previous post. Below is the correct question: I have a stored function that returns an OUT parameter that is a PL/SQL table. Can I call the function without having to define the maximum size of the return value using DimPLSQLTable? If I call DimPLSQLValue and set the...

I have a stored function that returns an OUT parameter that is a nested table. Can I call the function without having to define the maximum size of the return value using DimPLSQLTable? If I call DimPLSQLValue and set the maximum size for the variable, the result may be truncated if its size...

Thanks. Actually I managed to find another solution that works, which is using an empty variant array and calling DimPLSQLValue with the maximum size greater than zero. However, I have another question. I have a stored function that returns an OUT parameter that is a nested table. Can I call...

Hello, I have a PL/SQL function that accepts a nested table of integers and returns another nested table of integers. I need to know how I can use DOA 3.4.3 to pass null (or empty) nested tables to and from that function. Thanks, Lev

Does the current DOA version support complex PL/SQL table types? Thanks, Lev

Thank you, but I still don't understand. When I use FieldAsString, which is the character set of the text - the locale or the NLS parameter? Thanks again.

How does DOA know the character set? From Windows or from Oracle login parameter?

Does DOA 3.0.4 support Unicode? Is it possible to receive data as WideStrings? Thanks.

Thank you very much for your help. I am looking for other solutions, though. Using IN is less efficient than variables, because it requires much parsing and does not allow certain optimizations of Oracle. When the number of items in IN exceeds the maximum, a UNION can be used to add more...

Using TOracleQuery, I'd like to select all records, for which a column's value is in a specified range. Using the SQL IN sub-clause is inefficient and limited to a maximum allowed number of items (typically 1000). The most efficient way should be to use array variables: SELECT * FROM CUSTOMER...

The following simple code causes a stable memory leak, when run in a loop. TOracleSession* session = new TOracleSession(NULL); session->LogonDatabase = "MY_DB"; session->LogonPassword = "MY_LOGON"; session->LogonUsername = "MY_PASSWORD"; session->Pooling = spInternal...

Helene, I only left what's necessary for the workflow. The function really doesn't do anything: Here is what I had in original: procedure TOracleTableInfo.GetConstraints(DataSet: TOracleDataSet); var ThisConstraint: string; C: TOracleConstraintInfo; begin // Already read? if...

I commented out most of the code in TOracleTableInfo.GetConstraints, and my application seems to work fine. It is possible that some problems may be caused by this that I wasn't able to produce or anticipate. I should note that my ClientDataSets ignore IndexDefs.