FUNCTION user_authenticate(
    p_login    IN wfm_user.login%type,
    p_password IN wfm_user.password%type)
  RETURN wfm_user.user_id%type
IS
  v_user_id wfm_user.user_id%type;
  v_password wfm_user.password%type;
  c_sysdate CONSTANT DATE := sysdate;
BEGIN
  v_password := hash_password(upper(p_login), p_password);
  SELECT user_id
  INTO v_user_id
  FROM wfm_user inner join wfm_employee on wfm_user.employee_id = wfm_employee.employee_id
  WHERE login    = upper(p_login)
  AND password   = v_password
  AND is_blocked = 0 and wfm_employee.dismiss_date is null;
  UPDATE wfm_user SET last_entry = c_sysdate WHERE user_id = v_user_id;
  RETURN v_user_id;
EXCEPTION
WHEN no_data_found THEN
  raise_application_error(-20107, 'The user name or password are incorrect');
  RETURN NULL;
END;

        $them ="(DESCRIPTION =
            (ADDRESS_LIST =
                (ADDRESS =
                  (PROTOCOL = TCP)
                  (HOST = некий ip.address)
                  (PORT = 1521)
                )
            )
            (CONNECT_DATA =
              (SID = them)
            )
          )";
        $conn = oci_connect("wfm_draft", login,$them);

        if(!$conn){
          echo("<li>not connect");
          $err = var_dump(OCIError());
        }
        else{
        echo "<li>Успешное соединение";
        $log ='andrey';
        $pas = '123';
        $qry=OCIParse($conn,"select WFM_RELEASE.pk_user.user_authenticate(:login, :pass) Func_res from dual");
        OCIBindByName($qry, ":login", $log); 
[53]        OCIBindByName($qry, ":pass", $pas); 
[54]        OCIExecute($qry,OCI_DEFAULT);

$log ='andrey';
$pas = '****';
$result= "              "; //возвращается число (ID пользователя), но если тут поставить пустую строку или пару пробелов или 0... нифига не выйдет. Бубен шамана.
$qry=OCIParse($conn,"begin :r :=WFM_DRAFT.pk_user.user_authenticate(:login, :pass); end;");
if (!$qry) {
    $m = oci_error($conn);
    trigger_error('Could not parse statement: '. $m['message'], E_USER_ERROR);
}

oci_bind_by_name($qry, ':r', $result);
OCIBindByName($qry, ':login', $log); 
OCIBindByName($qry, ':pass', $pas); 

$r = OCIExecute($qry);
print_r($result);