| ORA-01480: trailing null missing from STR bind value [message #232791] |
Mon, 23 April 2007 05:06  |
ataufique
Messages: 79
Registered: November 2006
|
Member |
|
|
I have written the below code in PRO*C, when i try to execute
it is giving the error
" ORA-01480: trailing null missing from STR bind value "
EXEC SQL UPDATE TAP_REJECT_DETAILS
SET VLD_FILE_NAME = :v_filename,
VLD_DATE = :filedate
WHERE 'C'||'D'||SRCE_PLMN_CODE||DEST_PLMN_CODE||FILE_SEQ_NO
= :filename AND RECV_DATE IN (SELECT MAX(RECV_DATE) FROM TAP_REJECT_DETAILS WHERE 'C'||'D'||SRCE_PLMN_CODE||DEST_PLMN_CODE||FILE_SEQ_NO = :filename);
|
|
|
|
|
|
| Re: ORA-01480: trailing null missing from STR bind value [message #232940 is a reply to message #232801] |
Tue, 24 April 2007 03:14  |
ataufique
Messages: 79
Registered: November 2006
|
Member |
|
|
Hi Tahpush,
I have included the part of my code below..please if you can tell me what
exactly u r trying to tell..Thanks
EXEC SQL BEGIN DECLARE SECTION;
char v_filename[36];
char filename[17];
char filedate[26];
EXEC SQL END DECLARE SECTION;
int ret_val;
int filesize;
v_filename[0] = '\0';
filename[0] = '\0';
filedate[0] = '\0';
ret_val = 0;
filesize = 0;
strcpy(v_filename, p_filename);
v_filename[36] = '\0';
strncpy(filename, p_filename, 17);
filename[17] = '\0';
strcpy(filedate, p_filedate);
filesize = p_filesize;
EXEC SQL UPDATE TAP_REJECT_DETAILS
SET VLD_FILE_NAME = :v_filename
VLD_DATE = :filedate
WHERE
('C'||'D'||SRCE_PLMN_CODE||DEST_PLMN_CODE||FILE_SEQ_NO) =:filename
AND RECV_DATE IN (SELECT MAX(RECV_DATE)
FROM TAP_REJECT_DETAILS
WHERE
('C'||'D'||SRCE_PLMN_CODE||DEST_PLMN_CODE||FILE_SEQ_NO = :filename));
v_filename[0] = '\0';
filedate[0] = '\0';
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
