Top "Callable-statement" questions

Java CallableStatement registerOutParameter, what does it do?

I'm following a guide regarding callable statements. In this guide, it says that I need to register the out parameter …

java mysql callable-statement

Java - MySQL Calling Stored Procedure

I'm trying to call a Stored Procedure from Java. However, what I did was looking for a Function instead. What …

java mysql stored-procedures callable-statement

How do you get multiple resultset from a single CallableStatement?

When I call the stored proc from command line I get the following. CALL `events`.`get_event_by_id`(10) +---------+…

java mysql callable-statement

How in JDBC can you call a stored procedure when only setting some parameters

What is the best way to make a call to a stored procedure using JDBC if you only want to …

java stored-procedures jdbc sybase callable-statement

Oracle from Java. CallableStatement and Null for object parameter?

I've got, what started as a fairly complex stored procedure boils down to a very simple use case that doesn't …

java oracle callable-statement

stored procedures as queries: CallableStatement vs. PreparedStatement

PostgreSQL documentation recommends using a CallableStatement to call stored procedures. In the case of a stored procedure that returns a …

postgresql stored-procedures jdbc prepared-statement callable-statement

Closing a CallableStatement

public void XXX(){ Connection conn = ~~; CallableStatement cstmt = conn.prepareCall("{call XXX"); cstmt.executeUpdate(); cstmt.close(); } All methods that CallableStatement is …

java jdbc callable-statement

Java callableStatement giving error : Attempt to set a parameter name that does not occur in the SQL

I want to execute a Oracle Stored procedure using named parameter from Java CollableStatement. Syntactically all is good by when …

java sql oracle stored-procedures callable-statement

How to iterate over ResultSet by using MySql Stored Procedure with "select" keyword?

here is my Java method: public static List<Company> selectCompanies() { List<Company> companies=new ArrayList<…

java mysql stored-procedures resultset callable-statement