Re: LONG Field / 7.3.4 / PL-SQL

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 - 07:46:35 CDT