Oracle 8i, CFMX 6.1 LOB issues

2004-01-08 Thread Heald, Tim
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

RE: Oracle 8i, CFMX 6.1 LOB issues

2004-01-08 Thread Dave Carabetta
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

RE: Oracle 8i, CFMX 6.1 LOB issues

2004-01-08 Thread Heald, Tim
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

RE: Oracle 8i, CFMX 6.1 LOB issues

2004-01-08 Thread Dave Carabetta
Not a stupid question at all, but yes we do. OK, the other thought that comes to mind is what does the query look like? I was only able to get them to work if I used cfqueryparam with the cf_sql_longvarchar datatype (not cf_sql_clob). Haven't tried recently and I very well may have done

RE: Oracle 8i, CFMX 6.1 LOB issues

2004-01-08 Thread Tim Heald
It's a PL/SQL package, so it's using the stored proc tags. -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 5:14 PM To: CF-Talk Subject: RE: Oracle 8i, CFMX 6.1 LOB issues Not a stupid question at all, but yes we do. OK, the other