i recieve an error after executing the following code:
Code: Select all
$db = '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =XXX)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME=AUGEO) ) )';
$con = oci_connect("XXX","XXX",$db);
$query = "SELECT STRUCTURE_NAME FROM IP.STRUCTURE";
$s = oci_parse($con, $query);
while ($ergrow = oci_fetch_row($s)) {
$result[] = $ergrow;
};
oci_execute($s, OCI_DEFAULT);
print_r(OCIError($s));
$committed = oci_commit($con);
oci_free_statement($s);
oci_close($con);
return $result;
I´ve tried the same code with oci_fetch_array but it didn´t work too. I´m lost at this point. The database connection returns true and the table/column exists 100%.
Can´t remeber where, but i think i saw the line
Code: Select all
while ($ergrow = oci_fetch_row($s))Code: Select all
while ($ergrow =@ oci_fetch_row($s))googled that for like an hour but couldn´t find what it does. Code executes that way, but the fetched rows are empty.....
Greetings,
Highclass