Re: LONG Field / 7.3.4 / PL-SQL

From: Yann Chevriaux <chevriaux_at_theleme.com>
Date: Tue, 28 Sep 1999 14:46:35 +0200
Message-ID: <37F0B8AA.662247D_at_theleme.com>


Bruno,

I'm sorry but ...

  YES ! PL/SQL long type is 32 K limited. I already asked something like that:.

Search for "" in this forum (16/09/1999 17:42).

 I get some advices to fetch long columns.

You can also try: http://govt.us.oracle.com/~tkyte/

Good luck.

Bruno Plankensteiner a écrit :

> 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 - 14:46:35 CEST

Original text of this message