Oracle connectivity

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have connected to remote oracle database using ocilogon(). I first
inserted some values in the table, then i again run code and try to
insert new values but it has only old values previously inserted not
the new values. This is my code :
$c = ocilogon("system", "Welcome1", '//');
echo $c;
$s=($c,"truncate table test");
    $s=OCIParse($c,"insert into test values (:j)");


when i first run this code 2 values were inserted .
Then i rerun this code now it is not working. What is the
problem..Please Help

Re: Oracle connectivity

Aditi Jindal escribió:
Quoted text here. Click to load it

I get a parse error when I run this. What's the real code?

Quoted text here. Click to load it

If you set OCI_DEFAULT then you need to do a explicit commit. From the

"When using OCI_DEFAULT mode, you're creating a transaction.
Transactions are automatically rolled back when you close the
connection, or when the script ends, whichever is soonest. You need to
explicitly call oci_commit() to commit the transaction, or
oci_rollback() to abort it."

Quoted text here. Click to load it

-- - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web:
-- Mi web de humor al baño María:

Re: Oracle connectivity

On Mar 20, 6:34=A0pm, "=C1lvaro G. Vicario"
Quoted text here. Click to load it

ok thanks... I didnt know that. :)

Site Timeline