LONG Field / 7.3.4 / PL-SQL

Hi
I have a stored procedure which does the following:

add a string to a long field in a table_case

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 - 07:10:05 CDT