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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253545
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
