Recent content by Schlueter

Hi, have you also a solution for selecting a blob field into TPicture using TOracleDataSet? Best regards Rolf

Hi Marco, is it also possible to pass a table of records to the procedure? On database I've created an array table with two fields, at example 'item_number' and 'quantity'. But if I try to pass my record by ...elements[x] I get an error message because of 'incompatible types: variant and...

Hi, I'm using a combination of TOracleDataSet, TDataSetProvider and TClientDataSet for showing data. But in some cases (e.g. join between 2 tables), string-fields from the non-updateable table will be shown as chinese characters instead of normal alphanumerics (a..z or 0..9). Normally I've set...

I think this topic is related to Typemismatch: expected Integer found Float (Oracle 11) but also very strange. Using Delphi XE8, DOA 4.1.3.5, DB 12.1.0.2.0, Client 11.2.0.1.0 I've created a simple table like this: create table TESTTABLE ( test1 NUMBER(1), test2 NUMBER(1), test3...

Thank you Marco, it works ... Rolf

Sorry, but the example in User's Guide doesn't show how to pass a list to a StoredProcedure's param. In database I've defined a type: CREATE OR REPLACE TYPE T_String_Table AS TABLE OF VARCHAR2(100) NOT NULL; and a StoredProcedure: CREATE OR REPLACE PROCEDURE MyTest(p_Data IN t_String_Table) AS...

Hi, I'm using Delphi XE3 with DOA 4.1.3.3 and still Delphi 2010 with DOA 4.1.2.2 (both 'Professional' edition). I use the combination of TOracleDataSet -> TDataSetProvider -> TClientDataSet -> TDataSet for accessing and modifying a TDbGrid. With Delphi 2010 it works fine, but with Delphi XE3 I...

I want to execute a UPDATE or INSERT statemant with TOracleQuery or TOracleDataset. But the records do not appear in the DB unless the program is terminated. What's wrong? Thanks in advance Rolf Schlueter