How to pass a list of values or array to SQL Server stored procedure?

Note: Information & code samples from this article are tested on SQL Server 2005 RTM (Yukon) and found to be working. Will update the article in case of any compatibility issues. unfortunately, there is no built-in support for arrays inContinue reading… How to pass a list of values or array to SQL Server stored procedure?

Java Common Utils: Creating a stored procedure or function in an Oracle Database

A stored procedure or function can be created with no parameters, IN parameters, OUT parameters, or IN/OUT parameters. There can be many parameters per stored procedure or function. An IN parameter is a parameter whose value is passed into aContinue reading… Java Common Utils: Creating a stored procedure or function in an Oracle Database

Java Common Utils: Calling a Stored Procedure in a Database (Oracle)

This example demonstrates how to call stored procedures with IN, OUT, and IN/OUT parameters. CallableStatement cs; try { // Call a procedure with no parameters cs = connection.prepareCall(“{call myproc}”); cs.execute(); // Call a procedure with one IN parameter cs =Continue reading… Java Common Utils: Calling a Stored Procedure in a Database (Oracle)