LONG Field / 7.3.4 / PL-SQL

From: Bruno Plankensteiner <bplank_at_ctp.com>
Date: Tue, 28 Sep 1999 14:10:05 +0200
Message-ID: <37F0B01D.B5294EBB_at_ctp.com>

Hi
[Quoted] [Quoted] I have a stored procedure which does the following:

[Quoted] [Quoted] add a string to a long field in a table_case

[Quoted] If the long has more than something like 36K bytes I get the error 6502

---

APPEND_CASE_HISTORY(obj IN NUMBER, note IN VARCHAR, ret OUT VARCHAR) AS
 prev_history long;
BEGIN
 select case_history into prev_history from table_case where objid=obj;  prev_history:=prev_history || note;
 update table_case set case_history=prev_history where objid=obj;  commit;
END APPEND_CASE_HISTORY

---

There is a limit of 36K if you select a long type into a long. Do you know a workaround?

Thank you

Bruno Received on Tue Sep 28 1999 - 14:10:05 CEST