|
|
Posted by teser3@hotmail.com on 06/11/07 23:55
I have been using something similiar to below for inserting data into
Oracle 9i using PHP but forgot to use the OCILogoff() method to logoff
and was wondering what issues might occur with the Database
connection? So far about 50 records have been inserted into the
database and I will probably have another 200 records when it is
finished in 2 weeks. Now I dont have access to the site due to
permission issues so I wont be able to correct my mistake. Please
advise what kind of Database issues might happen?
CODE
<?php
$c=OCILogon("scott", "tiger", "orcl");
if ( ! $c ) {
echo "Unable to connect: " . var_dump( OCIError() );
die();
}
// Insert data into table...
$s = OCIParse($c, "insert into tab1 values (1, 'Frank')");
OCIExecute($s, OCI_DEFAULT);
// Commit to save changes...
OCICommit($c);
?>
Navigation:
[Reply to this message]
|