I am using PHP 7.21 and Oracle 12c. I am having an issue with a global temporary table. Sometimes the data returns an empty table, and I am only having this issue with temporary tables. I have tried in both Laravel and CodeIgniter but the issue remains. Is there something in my below code that is an apparent problem?
PHP Code:
<?php
$c = oci_new_connect("system", "1234", "127.0.0.1:1521/ORCL:POOLED");
oci_execute(oci_parse($c,"CALL pr_test()"));
$s = oci_parse($c, 'select * from GTT_TABLEs');
oci_execute($s);
oci_fetch_all($s, $res);
var_dump($res);
SQL Code:
--- Global Temporary Table ----
CREATE GLOBAL TEMPORARY TABLE "SYSTEM"."GTT_TABLES"
( "ID" NUMBER(10,0) NOT NULL ENABLE,
"FIRSTNAME" VARCHAR2(191 BYTE),
"LASTNAME" VARCHAR2(191 BYTE),
"EMAIL" VARCHAR2(191 BYTE),
"POINTS" VARCHAR2(191 BYTE),
"NOTES" VARCHAR2(191 BYTE),
"CREATED_AT" TIMESTAMP (6),
"UPDATED_AT" TIMESTAMP (6),
"AGE" NUMBER(10,0),
"JOB" VARCHAR2(191 BYTE),
"GENDER" VARCHAR2(191 BYTE),
"COUNTRY" VARCHAR2(191 BYTE),
"SALE_DATE" VARCHAR2(191 BYTE)
) ON COMMIT PRESERVE ROWS ;
--- PROCEDURE -----
create or replace PROCEDURE PR_TEST AS
BEGIN
DELETE GTT_TABLED;
INSERT INTO GTT_TABLES (SELECT * FROM DATATABLES);
COMMIT;
END;