Home » Developer & Programmer » Precompilers, OCI & OCCI » OCIStmtExecute and ORA-06502 error
OCIStmtExecute and ORA-06502 error [message #118557] Thu, 05 May 2005 18:06 Go to next message
zebadey
Messages: 1
Registered: May 2005
Junior Member
the Call OCIStmtExecute give me a "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" error, but when I run the same commands thru' plsql plus, I get no problem.

can anyone provide some hints what to look for. As far as I can see there is no problem with length.
The database is 10g, UTF16

Thanks in advance
zeba

Report message to a moderator

Re: OCIStmtExecute and ORA-06502 error [message #118575 is a reply to message #118557] Fri, 06 May 2005 01:45 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member
Hi

Please post your code, in particular the sections of code the perform the binding and defining, but also the SQL allocation to the statement handle.

Before posting code, check you are using strlen() function to send the length of the allocated strings to the OCI function calls.

Kind regards,
Michael Hartley, http://www.openfieldsolutions.co.uk

Report message to a moderator

Previous Topic: OCI-22629: Message 22629 not found; product=RDBMS; facility=OCI
Next Topic: Pro C Pre Compiler
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 17 22:48:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.