Thanks Tom,
I'm going to look further into the Oracle Logs. CF debugging + Robust
Exceptions is on. I pasted the queries shown below into a file
(replacing parameters with values) and they successfully ran, using the
same datasource. I'll post any Oracle error info I come across.
Exceptions
09:58:34.034 - Database Exception - in
D:\Inetpub\libraries\framework\reactor\data\oracle\ObjectDao.cfc : line
115
Error Executing Database Query.
09:58:34.034 - Database Exception - in
D:\Inetpub\libraries\framework\reactor\data\oracle\ObjectDao.cfc : line
115
Error Executing Database Query.
SQL Queries
qObject (Datasource=ora_webp_web_apps, Time=188ms, Records=1) in
D:\Inetpub\libraries\framework\reactor\data\oracle\ObjectDao.cfc @
09:58:32.032
SELECT object_name
FROM all_objects
where object_type in ( ?,? )
and
( object_name = ?
or object_name = ?
or upper(object_name) = ? )
order by case
when object_name = ? then 1
when upper(object_name) = ? then 2
else 3
end
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = TABLE
Parameter #2(CF_SQL_VARCHAR) = VIEW
Parameter #3(cf_sql_varchar) = ems_users
Parameter #4(cf_sql_varchar) = EMS_USERS
Parameter #5(cf_sql_varchar) = EMS_USERS
Parameter #6(cf_sql_varchar) = ems_users
Parameter #7(cf_sql_varchar) = EMS_USERS
qObject (Datasource=ora_webp_web_apps, Time=15ms, Records=1) in
D:\Inetpub\libraries\framework\reactor\data\oracle\ObjectDao.cfc @
09:58:32.032
SELECT object_name table_name,
object_type as TABLE_TYPE,
owner as table_owner
FROM all_objects
where object_type in ('TABLE','VIEW')
and object_name = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = EMS_USERS
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
