[freetds] call a stored procedure and tds_submit_query

Thompson, Bill D (London) bill_d_thompson at ml.com
Fri Jul 23 06:07:20 EDT 2004

Hi Fabrizio,

Yes you can do this - you would just construct a statement "exec sp_myproc
@parameter = 'value'" and submit it as you would a "select * from mytable"
or "update mytable set column = 'value'" statement.
If the stored procedure returns a result set, then it can be processed just
as if it were the result set from a "select * from mytable" statement.

The only proviso is with stored procedure OUTPUT parameters.
If you are talking to sql server 2000 sp3, then these will not be returned
to the client.



-----Original Message-----
From: Fabrizio Taretto [mailto:fabrizio.taretto at sinedita.it] 
Sent: 23 July 2004 10:58
To: freetds at lists.ibiblio.org
Subject: [freetds] call a stored procedure and tds_submit_query

Hi All,

someone can tell me if it's possible call a stored procedure with 
tds_submit_query and process result with tds_process_result_tokens.
These functions are perfect for SELECT and UPDATE but what can I use 
for a stored procedure?
Can anybody help me?

I'm work on MacOS X 10.3.4.

FreeTDS mailing list
FreeTDS at lists.ibiblio.org


If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.


More information about the FreeTDS mailing list