| 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 |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
