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
which is really what you want in the end. That little output you saw is the
object's string identifier. So in Coldfusion, to get the character set we
had to create a Java string object and pass the clob into the constructor.
It seems the constructor recoginizes that the value is a clob and when it
creates the string it assigns the char set as the value. The end code was
(using your example):
<cfset x = CreateObject("java","java.lang.String").init(myXMLOutput)>
<cfoutput>#x#</cfoutput>
---------------------------------------------------------------------------------
Gert Franz wrote:
>
> 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 ideas... :-)
> good luck
>
> Greetings / Grüsse
> Gert Franz
> Customer Care
> Railo Technologies GmbH
> [EMAIL PROTECTED]
> www.railo.ch
>
> Join our Mailing List / Treten Sie unserer Mailingliste bei:
> deutsch: http://de.groups.yahoo.com/group/railo/
> english: http://groups.yahoo.com/group/railo_talk/
>
>
>
> Mike Garner schrieb:
>> 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):
>>
>> **********************************
>> <cffile action="Read"
>> file="C:\testing\Test.xml"
>> variable="variables.myXMLInput">
>>
>> <cfstoredproc procedure="TESTCLOB" datasource="MYDNS">
>> <cfprocparam cfsqltype="CF_SQL_CLOB" type="In"
>> value="#variables.myXMLInput#">
>> <cfprocparam cfsqltype="CF_SQL_CLOB" type="Out"
>> variable="variables.myXMLOutput">
>> </cfstoredproc>
>>
>> <cfoutput>#variables.myXMLOutput#</cfoutput>
>> **********************************
>>
>> The stored procedure is just copying the value passed in into the output
>> variable. I've tested the procedure through PL/SQL developer and it
>> works fine.
>>
>> The output of the above test code is this:
>> [EMAIL PROTECTED]
>> I realize what this is - the default ToString of a Java object - the
>> address changes every time I refresh. The question is, how do I get to
>> the value of the CLOB from this variable? I've tried to do a CFDUMP of
>> the variable, but it actually causes CF to crash. Through debugging I
>> can see the input was handled correctly - just can't get to the output.
>> Any help would be appreciated.
>>
>> Regards,
>> MG
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313900
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
