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 ?
15 7435
Hi,
Could you give a better description of what you are doing? When you say other machine, do you mean another database or another client?
Pilgrim.
are you using DBMS_LOB to handle NCLOB ?
Hi,
Could you give a better description of what you are doing? When you say other machine, do you mean another database or another client?
Pilgrim.
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 I have a NCLOB Comparison in the procedure, but if I comment that comparison the procedure is running without any error ( in other machine also)
are you using DBMS_LOB to handle NCLOB ?
i am using NCLOB in for loop cursor to fetch records from table having NCLOB field.
BODY_TYPE_PARENT NCLOB;
for i in (select BODY_TYPE from VEHICLE_ACCESSORY)
loop
BODY_TYPE_PARENT := REC.BODY_TYPE; // reporting error
end loop;
Hi,
What tool are you using to execute the procedure? It is a client side setting in your tool that needs to be set.
Pilgrim.
Hi,
What tool are you using to execute the procedure? It is a client side setting in your tool that needs to be set.
Pilgrim.
I am using SQLPLUS for executing. How to set buffer size ?
Ok,
On both machines give the SQL command show long. It will return a number. If the numbers are different, then set the size on both machines to the same (the greatest amount of both) you can set the size by giving the command set long <size>
Let me know if this works or not.
Pilgrim.
Ok,
On both machines give the SQL command show long. It will return a number. If the numbers are different, then set the size on both machines to the same (the greatest amount of both) you can set the size by giving the command set long <size>
Let me know if this works or not.
Pilgrim.
it is showing 80 in both machine .
Hi,
I am searching for the right parameter to adjust, but i am comming up with blank. What we can do, is that you do a show all in sql*plus on both machines, get the output into a file and do a compare and see what parameters are different and make them equal. Try that, try again with the procedure and post your results/findings.
Pilgrim.
Hi,
I am searching for the right parameter to adjust, but i am comming up with blank. What we can do, is that you do a show all in sql*plus on both machines, get the output into a file and do a compare and see what parameters are different and make them equal. Try that, try again with the procedure and post your results/findings.
Pilgrim.
i compared both outputs , but there is no difference in parameter. Could you specify the parameter which you tried ?
I haven't tried anything yet.
Some research led to a difference in the nls_lang settings with the database and the client. The machine it works on can have the same nls_lang settings as the database and the machine it doesn't work on has a different one. Could you check if the nls_lang settings are the same on both machines and that they match the settings on the database?
Info on how you can do this, can be found at: NLS_LANG
Pilgrim.
How you are writing a data to NCLOB variable?
Please post the source code here for reference
I haven't tried anything yet.
Some research led to a difference in the nls_lang settings with the database and the client. The machine it works on can have the same nls_lang settings as the database and the machine it doesn't work on has a different one. Could you check if the nls_lang settings are the same on both machines and that they match the settings on the database?
Info on how you can do this, can be found at: NLS_LANG
Pilgrim.
Hi ,
I execute the above NLS_LANG query in both machines and only one parameter is different.
NLS_NCHAR_CHARACTERSET = AL16UTF16 ( my machine)
NLS_NCHAR_CHARACTERSET = UTF8 ( other machine)
is this make any difference ?
Hi,
Make sure the char_sets are the same as the one on the machine on which the procedure is working, and then try to run the procedure again on the machine where it is not woking.
Pilgrim.
Hi,
Make sure the char_sets are the same as the one on the machine on which the procedure is working, and then try to run the procedure again on the machine where it is not woking.
Pilgrim.
-----------
Hi ,
After changing the CHAR_SET in both machines , it's working fine.
Thank you for your valuable inputs..
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Ruth |
last post by:
Hi All
I am not a DBA, but a unix administrator.
After our DBA's upgraded from oracle 8.0.5 to oracle 8.1.7.4 on our
test server, we have noticed a big slow down in our application...
|
by: stephane.traumat |
last post by:
Hello,
I already succeed to call a stored procedure in Oracle but only simple
ones with one output value and several inputs. I don't any idea left
so any help would be great :) Thanks
But on...
|
by: der |
last post by:
Hello all,
I want to use fgets() to read lines.
Now, if the user has entered more characters than it was supposed to,
the next call to fgets() would read
these characters, which I don't want to...
|
by: Dawn Minnis |
last post by:
Hi (running Win xp and developing using Miracle C. Running applications in
windows command prompt)
I'm new to the group so be gentle with me. I am currently writing a C
program to perform...
|
by: kernelxu |
last post by:
hi,everybody.
I calling function setbuf() to change the characteristic of standsrd
input buffer.
some fragment of the progrem is:
(DEV-C++2.9.9.2)
#include <stdio.h>
#include <stdlib.h>
int...
|
by: Michel Rouzic |
last post by:
I know it must sound like a newbie question, but I never really had to
bother with that before, and I didn't even find an answer in the c.l.c
FAQ
I'd like to know what's the really proper way...
|
by: Biztalk Migration |
last post by:
I am new to using BLOB with oracle stored proc. I dont knw how to set the
size of the buffer which seems to overflow no matter what i used to pass it.
I am getting an error
...
|
by: Tarique |
last post by:
I have tried to restrict the no. of columns in a line oriented user
input.Can anyone please point out
potential flaws in this method?
btw..
1.I have not used dynamic memory allocation because...
|
by: sathyguy |
last post by:
when i type the below in my RHEL AS 4's Firefox 1.5
http://appsworld.ncc.com:7777/forms/...&form=test.fmx
iam getting the below error...
The requested URL /forms/frmservlet was not found on...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |