[php]

[sql]

Write a separate PHP execute_sqls_in_oracle() function which takes an array of SQL statements as the input and execute them.

// Contains commonly used functions.

//********************

// Run the sql, and return the error flag and the cursor in an array

// The array index "flag" contains the flag.

// The array index "cursor" contains the cursor.

//********************

function execute_sql_in_oracle($sql) {

//putenv("ORACLE_HOME=/home/oracle/OraHome1");

//putenv("ORACLE_SID=orcl");

$connection = oci_connect ("");

if($connection == false){

// failed to connect

display_oracle_error_message(null);

die("Failed to connect");

}

$cursor = oci_parse($connection, $sql);

if ($cursor == false) {

display_oracle_error_message($connection);

oci_close ($connection);

// sql failed

die("SQL Parsing Failed");

}

$result = oci_execute($cursor);

if ($result == false) {

display_oracle_error_message($cursor);

oci_close ($connection);

// sql failed

die("SQL execution Failed");

}

// commit the result

//oci_commit ($connection);

// close the connection with oracle

oci_close ($connection);

$return_array["flag"] = $result;

$return_array["cursor"] = $cursor;

return $return_array;

}

//********************

// Verify the session id.

// Return normally if it is verified.

// Terminate the script otherwise.

//********************

function verify_session($sessionid) {

// lookup the sessionid in the session table to ascertain the clientid

$sql = "select clientid " .

"from myclientsession " .

"where sessionid='$sessionid'";

$result_array = execute_sql_in_oracle ($sql);

$result = $result_array["flag"];

$cursor = $result_array["cursor"];

$result = oci_execute($cursor);

if ($result == false){

display_oracle_error_message($cursor);

die("SQL Execution problem.");

}

if(!($values = oci_fetch_array ($cursor))){

// no active session - clientid is unknown

die("Invalid client!");

}

oci_free_statement($cursor);

}

//********************

// Takes an executed errored oracle cursor as input.

// Display an initerpreted error message.

//********************

function display_oracle_error_message($resource) {

if (is_null($resource))

$err = oci_error();

else

$err = oci_error($resource);

echo "
";

echo "Oracle Error Code: " . $err['code'] . "
";

echo "Oracle Error Message: " . $err['message'] . "
" . "
";

if ($err['code'] == 1)

echo("Duplicate Values.

");

else if ($err['code'] == 984 or $err['code'] == 1861

or $err['code'] == 1830 or $err['code'] == 1839 or $err['code'] == 1847

or $err['code'] == 1858 or $err['code'] == 1841)

echo("Wrong type of value entered.

");

else if ($err['code'] == 1400 or $err['code'] == 1407)

echo("Required field not correctly filled.

");

else if ($err['code'] == 2292)

echo("Child records exist. Need to delete or update them first.

");

}

?>