>
> Is it possible to bind a Zend_Db_Table_Abstract with a stored procedure?
>
Nope.
Zend_Db_Table assumes that it can use SELECT to gather data from a table.
Most database brands don't support queries with a procedure as a table
source e.g. "SELECT * FROM procedurename(arg)". PostgreSQL and
InterBase/Firebird being exceptions that do support this syntax.
I'm not aware of any brand of database that supports a procedure as a target
of INSERT, UPDATE, or DELETE. Zend_Db_Table also assumes these operations
act against a table.
The next question you may ask is how to call a stored procedure in Zend
Framework if not by using Zend_Db_Table. You have to write the full SQL
statement using whatever syntax is supported by your brand of database, and
execute the statement with Zend_Db_Adapter methods like query().
There are no specific methods or tests in Zend_Db for stored procedures.
Regards,
Bill Karwin
--
View this message in context: http://www.nabble.com/Zend_Db_Table_Abstract-and-stored-procedures-tp18917526p18917757.html
Sent from the Zend DB mailing list archive at Nabble.com.
没有评论:
发表评论