[fw-general] Zend_DB Oracle adapter

[Svetlin Petrov]

Hi,

I need to execute query like this one:

INSERT INTO deal

                                (name, deal_type)
                        VALUES
                                (:name, :deal_type)
                        RETURNING
                                id
                        INTO
                                :id

If I do not use Zend Framework,  I do the following:

$stmt = oci_parse($_conn, $sql);

oci_bind_by_name($stmt, ":name", $name, 32);
oci_bind_by_name($stmt, ":deal_type", $deal_type, 32);
oci_bind_by_name($stmt, ":id",   $id, -1, SQLT_INT);

oci_execute($stmt);

My question is: is there an way to do this inside Zend Framework?

Thanks!
Svetlin Tsvetanov

--
http://www.spetrov.com