Return a result set as output param in a sybase stored proc
I have a stored procedure, in which I want to simply store result of a
select statement in an output parameter and return that , how can i do
that.
I would appreciate if you give me the right syntax of it, since i am new
to DB and Sybase specially, that's why i am just giving u a pseudo code
for that..
/pseudo code
create my_proc(in_param i,out_param o1,out_param o2){
.....
.....
if(xyz=true){
o1 = select * from emplyees
}
return o1,o2
}
No comments:
Post a Comment