mradenberg
New member
[SOLVED] Parameter field size in Pro/E appears to be 80 char. The returning string from the Oracle 10G database was exceeding the 80 char limit. Thereby causing the throwable error. In this application, I broke the string into two parts and assigned the 2nd half of the string toa new parameter. Thus resolving my issue.
I'm working with Pro/E 3.0 and J-Link. I'm retrieving data from across a network from an Oracle 10G database. I'm encountering an issue when the last field of a record is null it is throwing a jxthrowable error when trying to assign the retrieved value to a variable. It throws the error before I have a chance to check for a null value.
With the embedded SQL select statement I can use the NVL(comment3,'**') function whereby I can reassgin the value of comment3 if the value is null. I can test the length and see that it is 2, but as soon as I try to use the string, it errors out. comment3 = rs.getstring(7). comment3 has been set to be a String.
Is there another way or error trap that I can use to capture this particular error??
Thanks!
Edited by: mradenberg
I'm working with Pro/E 3.0 and J-Link. I'm retrieving data from across a network from an Oracle 10G database. I'm encountering an issue when the last field of a record is null it is throwing a jxthrowable error when trying to assign the retrieved value to a variable. It throws the error before I have a chance to check for a null value.
With the embedded SQL select statement I can use the NVL(comment3,'**') function whereby I can reassgin the value of comment3 if the value is null. I can test the length and see that it is 2, but as soon as I try to use the string, it errors out. comment3 = rs.getstring(7). comment3 has been set to be a String.
Is there another way or error trap that I can use to capture this particular error??
Thanks!
Edited by: mradenberg