Hi!
I have a stored procedure which performs two select statements. When I try
to execute it from my servlet through CallableStatement, I can get the
results from the first SELECT query (SELECT result1 FROM table1 ..)as:
...
if (resultSet.next())
out.println( resultSet.getString("result1") );
but if I try to get results from the second SELECT query (SELECT result2
FROM table2 )... as:
out.println( resultSet.getString("result2") );
I get an error: " Invalid column name 'result2' ",
though I can perfectly execute this stored procedure from outside of the
servlet, like through 'isql' application, for example.
What am I doing wrong?
Thanks,
Marina
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
