ODAC Update Query Error (Direct Mode)
Posted: Fri 19 Aug 2011 05:52
Hi,
I have problem using TOraQuery when executing query, my code is:
When I execute query I have obteined the next error:
project raised exception raised class EInternal Error with message ". Process Stoped.
And I press 'continue' button ... Next error is :
Project Project1.exe raised exception class EOraError with message 'ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement'.
What's the correct form for use Update in TOraQuery?
# That Field 'JOB' and 'ENAME' is varchar2
# ODAC version : 7.20.0.6 for RAD Studio XE
# ORACLE version : 9.2.0.8.0
I have problem using TOraQuery when executing query, my code is:
Code: Select all
OraSession1.Options.Net := True;
OraSession1.ConnectString := 'scott/[email protected]:1521:ora7';
OraSession1.Connect;
OraSession1.StartTransaction;
OraQuery1.SQL.Clear;
OraQuery1.SQL.Add
('UPDATE EMP SET JOB = :PARAM1 , ENAME = :PARAM2 WHERE EMPNO = ''7369'' ');
OraQuery1.ParamByName('PARAM1').AsString := 'TESTXE';
OraQuery1.ParamByName('PARAM2').AsString := 'TEST2';
try
OraQuery1.ExecSQL; ==>> Error!!!!!
except
on E: Exception do
begin
OraSession1.Rollback;
exit;
end;
end;
OraSession1.Commit;
project raised exception raised class EInternal Error with message ". Process Stoped.
And I press 'continue' button ... Next error is :
Project Project1.exe raised exception class EOraError with message 'ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement'.
What's the correct form for use Update in TOraQuery?
# That Field 'JOB' and 'ENAME' is varchar2
# ODAC version : 7.20.0.6 for RAD Studio XE
# ORACLE version : 9.2.0.8.0