execute a stored procedure

Question

execute a stored procedure

jeiel Oct '16

Created Oct '16	Last Reply Oct '16	Replies 2	Views 1118	Votes 0

jeiel 81.2k

Oct '16

HELLO, I HAVE A STORED PROCEDURE IN MY DATABASE CAN I run it from Phalcon


    $insert="BEGIN  PCS_INSERTAR_PRODUCTO("
    ."'$CODIGO' "
    .",'$DESCRIPCION'"
    .",'$TIPODO' "
    .",'' "
    .",'$OBSERVACION'"
    ." ,'$CODIG1'"
    .",'$CODIG2'"
    .",'$TIPOXX' "
    .",'$TIPO' "
    .",'$RCODIGO'"
    ." ,'$RECURSIVA'"
    .",'$FECHAI' "
    .",'$USUARIO'"
        .",'GUARDAR','$ESTADO');"
        ."END;";

jeiel
81.2k

Accepted
answer

edited Oct '16
Oct '16

$model = new OneOfYourModels();
$model->getReadConnection()->query(
"CALL nameOfYourProcedure()"
);

Lajos Bencz · Answer 1 · 2016-10-06T08:04:05-07:00

No idea, but this could help: https://github.com/dragosdm/phalcon-stored-procedures/blob/master/models/Robots.php

jeiel · Answer 2 · 2016-10-06T08:12:49-07:00

jeiel
81.2k

Oct '16

hello is a function in the database you want to run from Phalcon

le51 · Answer 3 · 2016-10-06T12:59:46-07:00

Hi,

I'm not really used with that. But I think that if you want to execute a database procedure (a procedure that is defined in the database itself), you will have to do that with raw SQL.