title: USING packages in php from oracle
body: <p>I cant seem to know why im not able to add using
  (ALTER_TABLE_SCOTT.ADD_DEL_EMP)
  package to the table EMP in oracle 11g. I'm still new to php and oracle.
  Html code: </p>
  
  <pre><code>`&lt;table &gt;
  &lt;form action="http://alfred-pc:7777/webone.php" method="get"&gt;
  &lt;td&gt;&lt;input type="text" name="ename" placeholder = "EX: Alfred , Elie"&gt;&lt;br
  &lt;/td&gt;&lt;/tr&gt;
  </code></pre>
  
  <p>the rest of the form all of the same style</p>
  
  <pre><code>&lt;tr&gt;&lt;td&gt;Alter on Employees: &lt;/td&gt;   &lt;td&gt; &lt;input type="text" name="alter"
  placeholder = "EX: Insert, Delete, Update"&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
  &lt;tr&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;input type="submit"&gt;&lt;/td&gt;&lt;/tr&gt;
  &lt;/form&gt; &lt;/table&gt; &lt;/div&gt; &lt;/body&gt; &lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;
  &lt;?php    
  </code></pre>
  
  <p>Connection to oracle</p>
  
  <pre><code>include_once "scottserver.php"; 
  include_once "config/config.server.php";
  $EMPNO = $_GET["WENO"];    $HIREDATE = $_GET["WEHD"];
  $SAL = $_GET["WS"];    $COM = $_GET["WC"]; 
  $ENAME = $_GET["WEN"];    $JOB = $_GET["WEJ"]; 
  $MGR = $_GET["WMGR"];    $DEPTNO = $_GET["WDNO"]; 
  $WWHAT = $_GET["WWAT"];
  </code></pre>
  
  <p>Statement:</p>
  
  <pre><code>$s = oci_parse($orclConn, " BEGIN ALTER_TABLE_SCOTT.ADD_DEL_EMP 
  ('".$EMPNO."','".$HIREDATE."','".$SAL."','".$COM."',
  '".$ENAME."','".$JOB."','".$MGR."','".$DEPTNO."','".$WWHAT."'); end;");
  oci_execute($s);
  </code></pre>
  
  <p>Parse:</p>
  
  <pre><code>$stmtLastParsed   = ociparse($orclConn, $s);
  
  if (!$stmtLastParsed)          {
   print ocierror($orclConn);    }
  </code></pre>
  
  <p>Execute:</p>
  
  <pre><code>$stmtLastExecuted = ociexecute($stmtLastParsed, OCI_COMMIT_ON_SUCCESS);       
  if (!$stmtLastExecuted) {
     print ocierror($stmtLastParsed);
                          }  
  ?&gt;
  &lt;/td&gt;&lt;/tr&gt;`
  </code></pre>