-----------
Hi ,
After changing the CHAR_SET in both machines , it's working fine.
Thank you for your valuable inputs.....
prasath342002
Last Activity: Nov 15 '08, 09:11 AM
Joined: Nov 4 '08
Location:
-
Hi ,
I execute the above NLS_LANG query in both machines and only one parameter is different.
NLS_NCHAR_CHARA CTERSET = AL16UTF16 ( my machine)
NLS_NCHAR_CHARA CTERSET = UTF8 ( other machine)
is this make any difference ?...Leave a comment:
-
i compared both outputs , but there is no difference in parameter. Could you specify the parameter which you tried ?...Leave a comment:
-
it is showing 80 in both machine ....Leave a comment:
-
I am using SQLPLUS for executing. How to set buffer size ?...Leave a comment:
-
i am using NCLOB in for loop cursor to fetch records from table having NCLOB field.
BODY_TYPE_PAREN T NCLOB;
for i in (select BODY_TYPE from VEHICLE_ACCESSO RY)
loop
BODY_TYPE_PAREN T := REC.BODY_TYPE; // reporting error
end loop;...Leave a comment:
-
Hi ,
Thanks.
i am trying to run the procedure in different machines (same kind of database maintained in both machines)
Version :
Oracle9i Enterprise Edition Release 9.2.0.4.0
But , if i run in my machine . i able to execute successfully.
in case of other machine , i am getting the below error
ORA-22921: length of input buffer is smaller than amount requested
...Leave a comment:
-
Oracle - Input Buffer
Hi ,
I am having the NCLOB field in stored procedure , when i tried in one machine it is executing but in some other machine it is not executing.
getting the below error
ORA-22921: length of input buffer is smaller than amount requested
could any one help us to resolve the problem ?
No activity results to display
Leave a comment: