Continue to Site

Welcome to MCAD Central

Join our MCAD Central community forums, the largest resource for MCAD (Mechanical Computer-Aided Design) professionals, including files, forums, jobs, articles, calendar, and more.

Retrieve data from Oracle 10G database

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
 

Sponsor

Back
Top