Ticket #500 (new Bug)

Opened 4 months ago

Stored procedure & function support

Reported by: HarryR Assigned to: zombor
Priority: minor Milestone: 2.2
Component: Libraries:Database Version: SVN HEAD
Keywords: database, stored procedure Cc:
SVN Revision (if applicable):

Description

As part of the Database driver and query builder it'd be nice to have stored procedure & stored function support as standard.

For example:

 $db->select($db->fnc_test("blah"))->from("something")->where...

Or for stored procedures:

  $db->call_customreport("Param1", 2, THREE);

The stored procedure syntax looks pretty sane and wouldn't be hard to implement, however for stored functions it's more complex (how would you reference columns from the result set as opposed to given values).