Skip to main content
January 27, 2009
Answered

Help with Oracle CLOB

  • January 27, 2009
  • 1 reply
  • 1015 views
I have CF8 and Oracle 10g. I am trying to write a cfc for use by a Flex3 application over the AMF channel. What should the ReturnType be for the retieve function? If I use Query, and return the CLOB as a QueryObject, I can easily put the CLOB into a datagrid. But I really want to put the CLOB into a RichTextEdit control, allow the user to edit, and call an update function to put it back in the CLOB. I'm just testing right now. the real application will use a cfc to pull back a lot of data to populate a form that will have seven or eight CLOBs for different remark areas.
I have posted this question here because there isn't a separate forum for questions from the intersection of CF and Flex.
Possibly Acrobat forms would be a better solution than Flex for the UI, but I have no experience using Acrobat to do the data retrieve and update.
Thank you for any advice.
Scott
This topic has been closed for replies.
Correct answer Newsgroup_User

I'm not sure what you are asking for here. As far as ColdFusion and
Flex is concerned a CLOB is simply a large quantity of text. As long as
the server, client and the bandwidth in between can handle the text
size; there is nothing different with a CLOB string then the string
"Hello World" and they would be handled the same.

1 reply

Newsgroup_UserCorrect answer
Inspiring
January 27, 2009

I'm not sure what you are asking for here. As far as ColdFusion and
Flex is concerned a CLOB is simply a large quantity of text. As long as
the server, client and the bandwidth in between can handle the text
size; there is nothing different with a CLOB string then the string
"Hello World" and they would be handled the same.

January 27, 2009
Ian,
So what you are saying is I should use String as the cfFunction ReturnType?
I was just unsure if there was any other way I should be returning it. Because I saw that, for the Update, I should use cf_sql_CLOB as the datatype.