There is a configuration parameter in ar.conf that limits the handling of text values based on size when usin an oracle db:
Db-Max-Text-Size To quote the "Configuring" guide: "The maximum size allowed for long character text data in Oracle, SQL Server, and Sybase databases. For Oracle databases, this value is also used for memory allocation during the processing of long text data; therefore, you must use it conservatively. The default for an Oracle database is 1 MB. For SQL Server and Sybase, the default is 2,147,483,647 bytes. The maximum value allowed for either database is 2,147,483,647 bytes." If the problems you are experiencing are a result of pl/sql limitations, consider using workflow to copy the diary field to a zero length display only character field, then push the do/char field to the remote char/diary field. If the limitation is in Remedy, configure the above mentioned parameter. Axton Grams On 2/19/07, jaya munjal <[EMAIL PROTECTED]> wrote:
** Dear List I have 2 Forms, Request Form and a Request History form. There is a Filter that pushes the data from Request Form to Request History on modify when TR.Status = Closed of the Request form. There is a dairy field that needs to pushed as well. This work flow only pushes the current transaction data of the diary field and not complete history to the Diary Field on Request History. To address this issue I have a work flow that calls a small PL/ SQL procedure to read the data of the field and update the Request History's Diary Field. The problem occurs if the data is greater than 4000K. I would appreciate if any one could let me know, what is the best method to implement this. We are on ARS 6.3 with Oracle 9 i on Solaris 9. Thanks Jaya ________________________________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos. __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"