Re: CFMX 7 - Oracle CLOB / cfstoredproc

2008-10-14 Thread pmolaro
I was having the same issue. I was getting a clob back and then couldn't figure out out to get the content to display. One of our Java guys helped me figure this out. So what I learned is that a CLOB is an object and there are a lot of attributes to it, including the actual character values

CFMX 7 - Oracle CLOB / cfstoredproc

2006-09-19 Thread Mike Garner
I have been messing with this issue all day - searched around without much success. Here's the issue, we are on Oracle 10g R2. We upgraded our JDBC driver to 3.5. I am now trying to get the following test code to work (test.xml is a simple xml file): **

Re: CFMX 7 - Oracle CLOB / cfstoredproc

2006-09-19 Thread Gert Franz
Did you check whether Oracle executes the storedproc? You could use the monitorin tool for that while cfm executes. what happens if you call the function directly inside a cfquery tag and dump the result? Just try to fill a variable without . notation eg myXMLOutput. After that, i have no