OraFAQ Forum: SQL & PL/SQL » ORA-01480: trailing null missing from STR bind value

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01480: trailing null missing from STR bind value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01480: trailing null missing from STR bind value [message #225580]

Tue, 20 March 2007 07:15

pradeep.ramana
Messages: 12
Registered: March 2007

Junior Member

Hi all,

I am using PRO c for database operations into oracle database.
While inserting record into table i'm getting the error
ORA-01480: trailing null missing from STR bind value

Can anyone help me?

Regards,
Pradeep.

Report message to a moderator

Re: ORA-01480: trailing null missing from STR bind value [message #225581 is a reply to message #225580]

Tue, 20 March 2007 07:18

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ora-01480: trailing null missing from STR bind value
Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer.
Action: Terminate the string with a null character

Regards
Michel

Report message to a moderator

Re: ORA-01480: trailing null missing from STR bind value [message #227175 is a reply to message #225580]

Tue, 27 March 2007 08:20

seraphstream
Messages: 8
Registered: March 2007

Junior Member

You can visit:

All Oracle Errors Messages

or post in:

Oracle Forum

bye

Laughing

Report message to a moderator

Previous Topic:	sql help
Next Topic:	Need logic of the procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 07:28:35 CDT 2024