>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]
