| Pro*Cobol get ORA-01458: invalid length inside variable character string [message #488484] |
Fri, 07 January 2011 15:12 |
 |
idiazr
Messages: 4
Registered: October 2010
Location: Colombia
|
Junior Member |
|
|
In a programm Pro*Cobol I have this varaiable
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
03 code pic 9(06).
03 amont pic 9(12).
03 resp Pic X(10) VARYING.
EXEC SQL END DECLARE SECTION END-EXEC.
Then
EXEC SQL EXECUTE
BEGIN
PKG_PUNTOS.calculate (:code, :amount, :resp);
END;
END-EXEC
The procedure PKG_PUNTOS.calculate have a variable vresp OUT VARCHAR2, that is the variable returned to pro*cobol,
My Pro*cobol end with
ORA-01458: invalid length inside variable character string
I look the resp-len and the value is 8224.
If I define 03 resp Pic X(10) varying with other lenght, like 50 or 80 or 100, my program end immediately.
How I can control this in my pro*cobol programm?
[Updated on: Fri, 07 January 2011 15:35] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
