How to call oracle stored functions in php?

Question

My PHP code is here:

<?php        
    $conn = oci_connect('user', 'test', 'localhost/db');              
    if (!$conn) {
        $e = oci_error();           
        }
    else
    {
     $st_en=oci_parse($conn, " begin :r:=admin.encrypt_password('$row_pd[0]');end; ");
     ociexecute($st_en);
      while (($row_en=oci_fetch_row($st_en))!=false)//checking 
        {
             if ( $pword==$row_en[0])//password matching
            {
                      echo "success";
            }
            else
            {
              echo "sorryyyyyyyyyy";
            }                   
        }
        oci_free_statement($stid); 

        oci_close($conn);//connection close
    }        
    ?>

when I execute this code I getting this error:

error code ora01008 occurred, not all variables bound

Daniel W. · Accepted Answer · 2014-06-17 09:10:37Z

1

You should use oci_bind_by_name() to bind your variable r with some actual php variable.

edited Jun 17, 2014 at 9:10

Daniel W.

32.6k15 gold badges99 silver badges155 bronze badges

answered Jun 17, 2014 at 8:52

Pranav Maniar

1,56511 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pranav Maniar Over a year ago

A good tutorial that should explain how you can bind variable for return value PHP call Oracle function.. You should define variable say $returnValue and then call ` oci_bind_by_name($st_en,":r",$returnValue);` after oci_parse and before ociexecute

Collectives™ on Stack Overflow

How to call oracle stored functions in php?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related