I have downloaded a trial version of Direct oracle access, to see if it is something I can use. But my query will not always execute with a insert update and delete statement, it just freeze. The same statement can be executed from sql plus, without error.
My code look something like this:
try
oraqryTios.Close;
oraqryTios.Clear;
oraqryTios.SQL.Add(sTiosQuery);
try
ErrMessage(oraqryTios.SQL.Text);
oraqryTios.Execute;
orasesTios.Commit;
except on e:Exception do
begin
showmessage('Shit');
end;
The ErrMessage is for copy past the sql statement to sql plus without syntax error.
When i trace through the program I freeze in the "oraqryTios.Execute" how can that be?
And why dont i raise a exception?
Can anybody help me.
Johnny
My code look something like this:
try
oraqryTios.Close;
oraqryTios.Clear;
oraqryTios.SQL.Add(sTiosQuery);
try
ErrMessage(oraqryTios.SQL.Text);
oraqryTios.Execute;
orasesTios.Commit;
except on e:Exception do
begin
showmessage('Shit');
end;
The ErrMessage is for copy past the sql statement to sql plus without syntax error.
When i trace through the program I freeze in the "oraqryTios.Execute" how can that be?
And why dont i raise a exception?
Can anybody help me.
Johnny
