 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
> I can't seem to figure out WHAT the heck I am doing wrong!!!! Argh! Can > someone explain the PHP code required to OPEN and CLOSE persistent > connections to Oracle? > > I am assuming that in each page I want to connect, I use ora_plogon.....I > think I get that.....then, since it is persistent, I should NOT close it > at the end of the page.......makes sense. However, I can do NO > transaction management from persistent connections (attempts to rollback > or commit cause PHP warnings and no results) and I often get the following > on attempts to connect: > > PHP 3 Warning: Unable to open new cursor (ORA-01012: not logged on) in > /open_database.php on line 20 On every page you should be doing something like the following: putenv("ORACLE_HOME=/some/path"); putenv("ORACLE_SID=whatever"); $connection = ora_plogon($user,$password); ora_CommitOn($connection); And then when you want to execute a query, do: (I am using the two-step process here) $r = ora_open($connection); if(ora_parse($r,$sql_query) < 0) { if (ora_errorcode($r)) echo ora_errorcode($r).":".ora_error($r)."<br>$sql_query<P>\n"; } else { ora_exec($r); if (ora_errorcode($r)) echo ora_errorcode($r).":".ora_error($r)."<br>$sql_query<P>\n"; } then do whatever you need to do with the result and when you are done call: ora_close($r); Not super-intuitive, I know, but then again, Oracle never was. | |||||
| Related Code Examples | |||||
