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  7222 
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: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: Naresh1 |
last post by:
What is WebLogic Admin Training?
WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
|
by: WisdomUfot |
last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
|
by: Oralloy |
last post by:
Hello Folks,
I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA.
My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
|
by: Carina712 |
last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
|
by: ezappsrUS |
last post by:
Hi,
I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
|
by: jack2019x |
last post by:
hello, Is there code or static lib for hook swapchain present?
I wanna hook dxgi swapchain present for dx11 and dx9.
|
by: DizelArs |
last post by:
Hi all)
Faced with a problem, element.click() event doesn't work in Safari browser.
Tried various tricks like emulating touch event through a function:
let clickEvent = new Event('click', {...
| |
