Difference between revisions of "User talk:Brian"
(Created page with '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 querie...') |
(→Prepared statements and stored procedures: new section) |
||
| Line 1: | Line 1: | ||
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? | 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. | ||
| + | |||
| + | --[[User:Nose|Nose]] 06:59, 24 September 2009 (UTC) | ||
Latest revision as of 07:59, 24 September 2009
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)
