Database Administration (MOSC)

MOSC Banner

Nclob - nVarchar

edited Nov 20, 2008 7:55PM in Database Administration (MOSC) 2 comments
 Hi.

Having a problem with nVarchar2 and the max length of a row. We need to extend it to 3600, now it is set as 4000 but it can not be inserted more than 2000 chars. Char_length 2000.

So, then i tried nClob but max length was 2480.

declare
v_var nclob;
begin
v_var := 'XXXXXXX 2480 times ... ' 

insert into aka_c values (v_var);
commit;
end;
/

But i feel like it should be possible to have a larger string to insert... We need this nClob (NLS) because of the worldwide application.

What do i have to do?

/A

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center