Passing Parameters to SQL Stored Procedures

[JavaInFairField]

I am calling a SQL Stored Procedure, which has 10 parameters.
The SP has defaults set on the last 9 of these params.
The 1st one is an output param.

I want to get the result for the output param. I am able to do this without a problem.

I only need to pass in 2 values. The 4th and the 7th parameter. The rest I want to use the defaults defined in the stored procedure.

I can do this in SQL analyzer and in vb 6.0.
How can I do this in Java, using JDBC driver - default for SQL 2005.

Any help is appreciated.

[khoapkl]

I am calling a SQL Stored Procedure, which has 10 parameters.
The SP has defaults set on the last 9 of these params.
The 1st one is an output param.

I want to get the result for the output param. I am able to do this without a problem.

I only need to pass in 2 values. The 4th and the 7th parameter. The rest I want to use the defaults defined in the stored procedure.

I can do this in SQL analyzer and in vb 6.0.
How can I do this in Java, using JDBC driver - default for SQL 2005.

Any help is appreciated.

You can find on the internet. Many article...

[Subrahmanyam]

Firstly pass a space if the parameter is a string and a 0 if the parameter is a integer/float for all the other parameters except the 4th and 7th ones.
Secondly you will have to register the out parameter first, only then you will be able to retrieve a value out of it when the procedure completes its process.

[JavaInFairField]

You can find on the internet. Many article...

Thank you for the response.
Unfortuntately, the only info I could find on the internet indicated that default values for the parameters could not be acheived easily.
One site indicated that it could be done by creating another stored procedure that I could use to return the default params of the stored procedure I wanted to call, and use the default values returned in that stored proc. This sounded senseless to me. Other sites stated that it wasn't possible to do directly.

However, a coworker was able to demonstrate that I could, indeed, use default params using the CallableStatement method.

Where you would normally use "?" in the param decl, you use the same syntax that T-SQL would use - which is the keyword "default". Also, you must use the index to denote the parameters instead of using the actual name of the param.

Thanks again!

[JavaInFairField]

Firstly pass a space if the parameter is a string and a 0 if the parameter is a integer/float for all the other parameters except the 4th and 7th ones.
Secondly you will have to register the out parameter first, only then you will be able to retrieve a value out of it when the procedure completes its process.

Thanks for your response. I appreciated the help.

I found an alternative method to do what I needed to do prior to this posting.
I am going to try your method - it can never hurt to have multiple ways to accomplish a task.

Using the callablestatement method, jdbc driver:

Where you would normally use "?" in the param decl, you use the same syntax that T-SQL would use - which is the keyword "default". Also, you must use the index to denote the parameters instead of using the actual name of the param.

Thanks again for your help.