Try the Remedy workflow workaround I outlined. This will not require any pl/sql and will not have this problem.
Axton Grams On 2/19/07, jaya munjal <[EMAIL PROTECTED]> wrote:
** Axton Thanks for your response. My issue are 1) Only current transaction data is getting pushed from the Diary Field 2) To address this issue, I have written a procedure to extract data from diary field from Request form and update the Diary field on Request History form. If the data is large I get an error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" Any suggestion for a work around are highly appreciated. Regards Jaya Axton <[EMAIL PROTECTED]> wrote: 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 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" ________________________________ Have a burning question? Go to Yahoo! Answers and get answers from real people who know. __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
