User talk:Brian

From Linuxnetworks
Revision as of 07:59, 24 September 2009 by Nose (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

I have been evaluating OpenDBX over the last few days. Overall, it looks like it has met it's objectives. One area that I have not seen any comments on are parameterized queries (including stored procedures). It is simple enough to construct a query with all of the proper values, but I have not seen any way to handle stored procedure return values or output parameters. I suppose that one could "select" these values and return a separate results set. Is there any planned support (or suggestions on how to support) output parameters?

Prepared statements and stored procedures

Parameterized statements (a.k.a prepared statements) are planned for the upcoming 1.5.x development branch.

I know that in MySQL, PostgreSQL, etc. you call a stored procedure like a normal statement and get back one ore more result sets depending on the statements executed inside the stored procedure. This is already used by some users of OpenDBX.

--Nose 06:59, 24 September 2009 (UTC)