output parameters and output recordsets 
Author Message
 output parameters and output recordsets

Max - Like this?


as
select au_lname from authors

select * from authors



HTH

Jerry

Quote:

>Is it possible to have a procedure that has output parameters AND returns
>rows?  I'm getting an error using ADO and trying to do this, but not sure
if
>it's my fault or just not possible.

>Thanks.



Tue, 12 Feb 2002 03:00:00 GMT
 output parameters and output recordsets

Yeah, that's what I had, but was having some freaky-freaky problem with
JScript (?) and this.

Basically, I was calling the function in question from an exception handler.
In the try of that block, I was executing another stored proc which had
returned a unique constraint violation.  If I try to reuse the same
connection object, I get one of a few errors such as:

* Used "EXEC" so output parameters were not returned (paraphrase)
* You can't use a server cursor for sp's that return multiple recordsets,
try a client cursor (which I was)

If I create a new connection object it worked fine.  See, freaky-freaky.


Quote:
> Max - Like this?

> create proc testproc


> as
> select au_lname from authors

> select * from authors



> HTH

> Jerry

> >Is it possible to have a procedure that has output parameters AND returns
> >rows?  I'm getting an error using ADO and trying to do this, but not sure
> if
> >it's my fault or just not possible.

> >Thanks.



Tue, 12 Feb 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Output parameter vs Input/Output parameter

2. Using a recordset as output parameter

3. Output Parameters Along with a Recordset?

4. Return Recordset and Output parameters (cannot do both)

5. Return recordset AND output parameters?

6. Returning both recordset and output parameters into VB from stored procedure

7. Recordset returned as an output parameter

8. SP output parameters & ADODB.Recordset using adAsyncExecute

9. How does OUTPUT keyword affect parameter's use as INPUT parameter

10. Large Text parameter clobbering OUTPUT parameters

11. use output parameter as input parameter in SQL7

12. Command.Parameters.Refresh not picking up Output parameters


 
Powered by phpBB® Forum Software