Materialized view

[luiz-andrade]

Materialized view with the package

How do I run this materialized view with the package?

• It works

$conn = oci_pconnect("user", "pass", "127.0.0.1/XE");
$sql = oci_parse($conn, "BEGIN DBMS_MVIEW.REFRESH('MV_DW_TESTE'); END;");
$result = oci_execute($sql);

With this command above it works

• with PDO does not work

$pdo = DB::connection('oracle')->getPdo();
$result = DB::connection('oracle')->getPdo()->exec("BEGIN DBMS_MVIEW.REFRESH('MV_DW_TESTE'); END;");

System details

• Linux Mint Version 21.2
• PHP Version 8.1
• Laravel Version 10
• Laravel-OCI8 Version v10.3.1