Raised This Month: $ Target: $400
 0% 

[SQL] Calling stored procedures which return a result set


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
Eiver
New Member
Join Date: May 2007
Old 05-05-2007 , 16:47   [SQL] Calling stored procedures which return a result set
Reply With Quote #1

Executing queries like the one below will always fail:

call MyStoredProc('Some input','Some more input')

The query above works only if the stored procedure does not return anything. If it returns something, it will always fail.

I tried using both DBI and SQLX - both have the same problem.
SQLX returns an error: PROCEDURE MyStoredProc can't return a result set in the given context

I know that other APIs (like for example PHP and its mysql_query()) also had this problem. However in PHP it was possible to set client options, so that it would accept result sets from a stored procedure.

Is there a way to get around this problem in AMX MOD X?

Last edited by Eiver; 05-05-2007 at 16:53.
Eiver is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:33.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode