Hello everyone,
I keep getting a End of Communication Channel Error when I have two queries to different tables in the same file but using the same Oracle connection. Am I doing something wrong ? Can you put two queries in the same file in PHP ? If so how ?
Bottom line: How can I get rid of this error.
The code is below:
[CODE]
OCIInternalDebug(0);
putenv("ORACLE_HOME=d:\orant_sqlplus");
putenv("TWO_TASK=d:\orant_sqlplus\network\admin\tnsnames.ora");
$conn = OCIPLogon("TECH","test2","test");
$stmt = OCIParse($conn,"SELECT UserMessaging.Subject, UserMessaging.userId, UserMessaging.
from User
FROM UserMessaging
WHERE UserMessaging.userId = $userID");
OCIExecute($stmt, OCI_DEFAULT);
OCICommit($conn);
$sender = OCIParse($conn,"SELECT Users.username FROM Users WHERE Users.userId = $fmUser");
OCIExecute($sender, OCI_DEFAULT);
OCICommit($conn);
OCIFetch($sender);
[/code]
