![]() ![]() However when I CALL the Procedure from my SQL DB I can see every SELECT statement of my Procedure. Logger.getLogger(()).log(Level.SEVERE, null, ex) ĮRROR message: : Column 'per_sc' not found.Īlthough, 'per_sc' is the name of the second column of my second select statement inside my Procedure. I have created a Stored Procedure in SQL with more than one SELECT statement and when I CALL the Procedure (using JDBC) in my Java app the program is able to fetch and print columns ONLY from the first SELECT statement. But I can not see any other column from any other SELECT statement, like this one (or any other one). I can see this column that comes from the first SELECT statement in my Procedure. ResultSet = callableStatement.executeQuery(query) This is the JAVA code I have public Something something(int jobID)" ĬallableStatement callableStatement = getConnection().prepareCall(query) I am using the "Callable Statement" to get the connection and "Result Set" so as to print the columns I want. Is there any way that I can print the columns of every SELECT statement I have created in my Procedure using JDBC? I have created a Stored Procedure in SQL with more than one SELECT statement and when I CALL the Procedure (using JDBC) in my Java app the program is able to fetch and print columns ONLY from the first SELECT statement.
0 Comments
Leave a Reply. |