Subject | Problem with stored procedures |
---|---|
Author | pbtouzet@club-internet.fr |
Post date | 2000-08-14T18:54:30Z |
Hello, I'm using InterClient 1.6 and InterBase 5.6 on the same
machine (Windows 98 SE) and I have a little problem calling one of my
stored procedure:
This procedure's name is IDENTIFICATION, it has 2 input parameters (2
strings char(8)) and one output parameter, an integer. So with this
code:
int resultat = 2;
callableStatement_ = connection_.prepareCall("{call IDENTIFICATION
(?,?)}");
callableStatement_.setString(1, userId);
callableStatement_.setString(2, userPassword);
callableStatement_.execute();
resultSet_ = callableStatement_.getResultSet();
while (resultSet_.next()) {
resultat = resultSet_.getInt(1);
}
I never come in the while loop, and so I can't get my integer result.
However, I can get the name and the type of the column in the
resultSet. Strange ?
Thanks in advance for help.
machine (Windows 98 SE) and I have a little problem calling one of my
stored procedure:
This procedure's name is IDENTIFICATION, it has 2 input parameters (2
strings char(8)) and one output parameter, an integer. So with this
code:
int resultat = 2;
callableStatement_ = connection_.prepareCall("{call IDENTIFICATION
(?,?)}");
callableStatement_.setString(1, userId);
callableStatement_.setString(2, userPassword);
callableStatement_.execute();
resultSet_ = callableStatement_.getResultSet();
while (resultSet_.next()) {
resultat = resultSet_.getInt(1);
}
I never come in the while loop, and so I can't get my integer result.
However, I can get the name and the type of the column in the
resultSet. Strange ?
Thanks in advance for help.