Execute stored procedure in oracle database in PHP

0

I have procedure " example1 " which receives 3 input parameters and none output, how do I execute it in PHP .

That would be the case.

EXEC "exemplo1"('para1','para1','para3');

$sql = 'EXECUTE "PORTAL_importaXml"'. "(?,?,?)";
$stmt = Conecta::prepareOrc($sql);
$stmt->bindParam(1, $p1);
$stmt->bindParam(2, $p2);
$stmt->bindParam(3, $p3);
return $stmt->execute();'

Thank you in advance.

    
asked by anonymous 03.09.2018 / 21:42

1 answer

-1

You do not need to quote the name of the procedure:

$sql = 'EXECUTE PORTAL_importaXml (?,?,?)';
    
03.09.2018 / 22:02