This discussion is archived
4 Replies Latest reply: Aug 2, 2012 2:07 PM by 743374 RSS

Nextver field

babasanfour Newbie
Currently Being Moderated
Hello,
I would like to know please if the field nextver is a fixed-length field?. If it's the case, what will happen when this field exceeds the size which is allowed to it.
Thank you in advance Cordially
  • 1. Re: Nextver field
    Ben Speckhard Pro
    Currently Being Moderated
    Hi,

    The nextver column is defined as a varchar2(500). If a row was split between workspaces enough times it would be possible to exceed this 500 character limit. However, this issue has not come up before. If the maximum size was exceeded, the dml or workspace operation(merge, refresh, etc) would fail with an error such as 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small'.

    Are you running into a situation where the length of the nextver value is exceeding the 500 character limit ?

    Thanks,
    Ben
  • 2. Re: Nextver field
    Pedro Lourenço Newbie
    Currently Being Moderated
    Hello!

    After 6 years... the problem is back. :)
    I'm having this problem right now... 500 characters are not enough to write the versions i need.
    Is there any way to change this value?

    Tried to use alterVersionedTable with DDL option to change the precision of NEXTVER from 500 to 4000.
    The operation ran ok, but i still got the error.
    Anything more that i can do?

    Thanks in advance.
    Best regards,

    Pedro Lourenço
  • 3. Re: Nextver field
    Ben Speckhard Pro
    Currently Being Moderated
    Hi,

    A couple of the metadata tables that are used by Workspace Manager also use the 500 character limit, so most likely the error is coming from those tables if you had modified the _LT table.  However, updating the length is not anything that we currently support.  File an SR if you need this looked at more closely.

    Regards,
    Ben
  • 4. Re: Nextver field
    743374 Newbie
    Currently Being Moderated
    Ben,

    It looks like the nextver field contains a comma separated list of 5 digit version numbers.
    This means that it's ok to split a row between 83 workspaces, but 84 will raise ORA-06502.
    Is this correct?

    Thanks, -Steve