TOracleDataset and User defined functions

[rmussman]

Has anyone experienced the error ORA-00904-invlaid column name on the call to dataset->Open? This error message does not happen all the time. The same code can execute 1 to n number of times before getting the error.

My sql statement does have a user defined ORACLE function call embedded in the select statement. Example:

select carinit| |' '| |carnum as Car,
to_char(last_sight_dt,'mm/dd/yyyy hh12:mi AM') as sight_dt,
Substr(DEPTMNGR.EQDCOMOBJ.SPLCCITY(last_sight_loc),1,20) as Sight_City
from table a

Before each call to the dataset->open(), I close the dataset, clear the sql, and then add new sql.

Should I be using dataset->CloseAll() to make sure all associated cursors are closed?

 

[Marco Kalter]

You don't need to close anything, this will have no effect on the situation. The only explanation for this is that the SQL is not valid. My guess is that this function is simply not available, as this will lead to ORA-00904.

------------------
Marco Kalter
Allround Automations