--
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.
-----Original Message-----
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 4:35 PM
To: CF-Talk
Subject: RE: Oracle 8i, CFMX 6.1 LOB issues
>I'm experiencing quite an oddity with our Oracle 8.1.7 servers when dealing
>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?
>
This is probably a stupid question, but I didn't see it noted above, so I'll
ask anyway: Do you have the "Enable long text retrieval (CLOB)." selection
checked off for this datasource in the MX Admin as well as a high enough
Long Text Buffer value? We use CLOBs on our site using MX 6.1 and Oracle
8.1.7, so I know they work in general.
Regards,
Dave.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
