hiteksoftware.com Forum Index hiteksoftware.com
User discussion forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

output parameters in Stored Procedure

 
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Frequently Asked Questions
View previous topic :: View next topic  
Author Message
rlevine



Joined: 04 May 2010
Posts: 15

PostPosted: Thu Sep 02, 2010 3:33 pm    Post subject: output parameters in Stored Procedure Reply with quote

Does the Database stored procedure task support calling stored procedures (MS Sql) which have out parameters defined?
Back to top
View user's profile Send private message
melvin
Site Admin


Joined: 25 May 2006
Posts: 635
Location: Santa Barbara, california

PostPosted: Sun Sep 05, 2010 7:57 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
rlevine



Joined: 04 May 2010
Posts: 15

PostPosted: Tue Sep 07, 2010 6:00 am    Post subject: Reply with quote

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
View user's profile Send private message
Robert
Site Admin


Joined: 25 May 2006
Posts: 1140

PostPosted: Wed Sep 08, 2010 3:55 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    hiteksoftware.com Forum Index -> Frequently Asked Questions All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group