View previous topic :: View next topic |
Author |
Message |
rlevine
Joined: 04 May 2010 Posts: 15
|
Posted: Thu Sep 02, 2010 3:33 pm Post subject: output parameters in Stored Procedure |
|
|
Does the Database stored procedure task support calling stored procedures (MS Sql) which have out parameters defined? |
|
Back to top |
|
 |
melvin Site Admin
Joined: 25 May 2006 Posts: 635 Location: Santa Barbara, california
|
Posted: Sun Sep 05, 2010 7:57 am Post subject: |
|
|
I believe only IN parameters are supported.
How would the OUT parameters work? is'nt that the same as the resultset values? |
|
Back to top |
|
 |
rlevine
Joined: 04 May 2010 Posts: 15
|
Posted: Tue Sep 07, 2010 6:00 am Post subject: |
|
|
I have a stored procedure in Sql Server database which has parameters which are defined as out parameters (Oracle has the same concept). I need to be able to schedule the execution of this stored procedure.
The only way I was able to do this is by writing a sql script and executing that. I was wondering if the stored procedure task type has any type of support for this. |
|
Back to top |
|
 |
Robert Site Admin
Joined: 25 May 2006 Posts: 1140
|
Posted: Wed Sep 08, 2010 3:55 pm Post subject: |
|
|
we will have to check the java jdbc documentation to see if this is supported.
if it is some proprietary sql server and oracle functions, then it is unlikely that java jdbc would support this. |
|
Back to top |
|
 |
|