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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
