Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> LONG Field / 7.3.4 / PL-SQL

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@ctp.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US