[DB-SIG] Using callproc with OUTPUT parameters

Chris Cogdon chris at cogdon.org
Tue Feb 10 00:35:12 EST 2004


On Feb 9, 2004, at 21:27, James Briggs wrote:

> My questions in a nutshell are:
> Am I using callproc correctly here?
> Is there API that connects to SQL Server where callproc works with 
> output parameters?

Try, simply, calling the procedure as part of a select statement. 
Select is the standard way of passing information back to the DB 
client.

Eg: Select 1+2;
Or, Select yourfunction ( 3, 4, 5 );


-- 
    ("`-/")_.-'"``-._        Chris Cogdon <chris at cogdon.org>
     . . `; -._    )-;-,_`)
    (v_,)'  _  )`-.\  ``-'
   _.- _..-_/ / ((.'
((,.-'   ((,/   fL




More information about the DB-SIG mailing list