Hello,
I suppose there is a bug in DOA 4.0.6.2 with PL/SQL-tables of type
string and UTF8 charactersets.
Following scenario:
- you have a Database with UTF8 Characterset
- TOracleSession.BytesPerCharacter is set to bcAutoDetect
- TOracleSession.MaxVarChar returns 1333 (= 4000 / 3)
- Create...
I believe there is a bug in TOracleDataSet.FetchRowId.
The line
if v = null or ((f.DataType = ftString) and (v = ''))
is evaluated in wrong order in Delphi 6. Delphi applies the OR-operator to the right side and compares then with the variable v.
This raises an exception of type...
I want to do the folloing:
procedure TForm1.ApplyRecord(Sender: TOracleDataSet;
Action: Char; var Applied: Boolean; var NewRowId: String);
if Action = 'I' then begin
OracleQuery1.DeleteVariables;
OracleQuery1.Sql.Assign(slSQL);
Sender.DeclareQueryVariables(OracleQuery1)...
The OracleScript-Component doesn't recognize PL/SQL blocks of the format
DECLARE
BEGIN
END;
as one block. Instead the parser takes every line between DECLARE and just before the BEGIN-Statement as one separate TOracleCommands-Object and the code between BEGIN and END as one block. The problem...