This discussion is archived
1 Reply Latest reply: Oct 30, 2012 4:28 PM by cj RSS

oracle wallet not working for php when php tries to insert/write data.

971083 Newbie
Currently Being Moderated
Hello ,

oracle wallet not working for php when php tries to insert/write data.

Oracle wallet is configured and following works - sqlplus and perl for reading and writing from/into database. php works for reading from database. PHP IS NOT WORKING WHEN IT TRIES TO WRITE?INSERT INTO DATABASE. Get following error - insert err = 1031:ORA-01031: insufficient privileges

PHP code -
$conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT);

In short with Oracle Wallet there is no problem for sqlplus and Perl. But for PHP we are facing issue when we try to write/insert data into database. Read for PHP works fine.

I have tried following so far but no luck -
$conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT);
$conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT+OCI_SYSOPER);
$conn = OCIPLogon("/", "", "SLACDEV", "", OCI_CRED_EXT+OCI_SYSDBA);

php does not work while tring to insert data into database. We get following error - insert err = 1031:ORA-01031: insufficient privileges

Any idea how to resolve this problem ?

Thanks in advance.
-Shashi DIvekar

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points