0

Trying to write to oracle calling a procedure using PHP but I get an unknown error.

$sth = $dbh->prepare("

   begin :RESULT := STUD.IWS001FUN(:x_year, :x_stno, :x_bc, :x_bld, :x_status); end; 
  ");


    // Bind the output parameter    


 $sth->bindParam(':x_year',$academic_year, PDO::PARAM_INT ); 

 $sth->bindParam(':x_stno', $stno, PDO::PARAM_INT); 

 $sth->bindParam(':x_bc', $academic_block_code, PDO::PARAM_STR );

 $sth->bindParam(':x_bld', $BuildingCode, PDO::PARAM_INT ); 

 $sth->bindParam(':x_status', $Status, PDO::PARAM_STR);

 $sth->execute();
Alive to die - Anant
  • 70,531
  • 10
  • 51
  • 98

0 Answers0