1 Reply Latest reply: Oct 30, 2012 6:28 PM by cj RSS

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

    971083
      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