with any LOB data via CF 6.1 Enterprise.
Via my CFML front-end, I'm able (as the oracle schema owner) to pull back
(any) LOB data correctly with no issues. However, if I should log in as a
user whom has execute privileges on the packages created by the schema
owner, it will either return an empty string or the generic ORA-00942
message via CF. If I run the procedure as either user via SQL*Plus/TOAD, I
get no error.
I've attempted to use both the 3.1 and 3.2 versions of the
macromedia_drivers JAR, neither have helped. If I grant SELECT to the Oracle
roles on the tables containing the LOBs, the data will return correctly,
just as if I was logged in as the schema owner.
I'm under the impression this is an Oracle problem, however our DBA staff
keeps pointing at CF/Data Direct drivers. I can't imagine it's a CF issue,
as the data returns fine under the aforementioned conditions. Has anyone had
this problem and fixed it, or could maybe point me in a better direction?
Many, many thanks in advance!
--
Timothy Heald
Web Portfolio Manager
Overseas Security Advisory Council
U.S. Department of State
571.345.2319
The opinions expressed here do not necessarily reflect those of the U.S.
Department of State or any affiliated organization(s). Nor have these
opinions been approved or sanctioned by these organizations. This e-mail is
unclassified based on the definitions in E.O. 12958.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
