I know that if a TSmartQuery contains sql like this
Code: Select all
DECLARE
dept_cur SYS_REFCURSOR;
BEGIN
OPEN dept_cur FOR SELECT * FROM Dept;
DBMS_SQL.RETURN_RESULT(dept_cur);
end;
However, if the anonymous pl/sql block does not return data, such as this:
Code: Select all
begin
null;
end;
My question is, does TSmartQuery have a property that I can look at before it is executed so that I can determine if I should use .Open or .ExecSQL? In my case. the SQL being executed is up to the end user.
Thanks
John