如何在Laravel上调用oracle过程? [英] How to call an oracle procedure on Laravel?

问题描述

我有一个带有Laravel和Yajra软件包的oracle数据库，如何从Laravel 5.4调用oracle过程

I have an oracle database with Laravel and Yajra package, how can i call an oracle procedure from Laravel 5.4

这是我的oracle过程:

This is my oracle procedure:

create or replace procedure PRW_GENERA_FACTURA(
            pnro in number, 
            pmsj out VARCHAR2
            ) is
        BEGIN
            pmsj := 'El nro. es '||pnro;

        end PRW_GENERA_FACTURA;

然后我在控制器上尝试了此操作

And i tried this on my Controller:

 $val1 = 20; 
 $result = DB::connection('ora_db')->select('exec 
 PRW_GENERA_FACTURA(?)',array($val1));
 return $result;

它给了我这个错误:

错误代码:900 错误消息:ORA-00900:无效的SQL语句 位置:0 声明:exec PRW_GENERA_FACTURA(:p0) 装订:[20] (SQL:执行程序PRW_GENERA_FACTURA(20))

Error Code : 900 Error Message : ORA-00900: invalid SQL statement Position : 0 Statement : exec PRW_GENERA_FACTURA(:p0) Bindings : [20] (SQL: exec PRW_GENERA_FACTURA(20))

推荐答案

我认为您必须以RAW格式执行此操作:

I assume you have to do this in RAW format:

$val1 = 20; 

$result = DB::connection('ora_db')->select(
    DB::raw("exec PRW_GENERA_FACTURA(:val1)"), array ('val1' => $val1)
);

return $result;

使用php进入控制器:

this using php into the controller:

$conn = oci_connect('apxjfdev01', 'x....' ,'x...'); 
if (!$conn) { 
 $e = oci_error(); trigger_error(htmlentities($e['message'], ENT_QUOTES), 
 E_USER_ERROR); 
} 
$sql = ' BEGIN PRW_GENERA_FACTURA( :PNRO, :PMSJ ); END; '; $sql = 
oci_parse($conn,$sql); oci_bind_by_name($sql, ":PNRO", $val1, 32); 
oci_bind_by_name($sql, ":PMSJ", $val2, 32); 
$val1 = $id_f; 
oci_execute($sql);

这篇关于如何在Laravel上调用oracle过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！