Hi people
I found a prob i am using Win XP SP2, Delphi 7 update 2, Oracle 10, DBExpress component, Core lab DBXOda 4.2
when a try to use a SqlQuery named as qryGenerica linked with cdsGenerica, i set cdsGenerica.commandtext := ' Select aFunction(1) from dual ' and cdsGenerica.Open
--------
CREATE OR REPLACE FUNCTION aFunction(a NUMBER) RETURN NUMBER IS
BEGIN
raise_application_error(-20500, 'aFunction');
RETURN a;
end aFunction;
--------
it returns a exception.
After this i try to use the same cdsGenerica again... like cdsGenerica.commandtext := ' Select 1 from dual ' and cdsGenerica.Open
i got this error "Cannot perform this operation on an open dataset"
if i change the SqlConnection.ConnectionName Oracle "(Core Lab)" to "OracleConnection" it works.
Any help?
Thank you.