Advertisement
Guest User

Untitled

a guest
Oct 30th, 2015
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.59 KB | None | 0 0
  1. $p1 = ':p1'; $p2 = ':p2';
  2. $v1 = 'deny_self_tariff_change'; $v2 = 296090391;
  3.  
  4. $sth = oci_parse($dbh->conn, "select SI_SUBJECTS_PKG_S.GET_SUBJ_VALUE_TYPE_ID( :p1, SI_SUBJECTS_PKG_S.GET_SUBJ_TYPE_ID(:p2) ) from dual");
  5. oci_bind_by_name($sth, $p1, $v1, -1);
  6. oci_bind_by_name($sth, $p2, $v2, -1);
  7. oci_execute( $sth );
  8. print_r( oci_fetch_array($sth) );
  9.  
  10.  
  11.  
  12. =======================
  13. result:
  14. =======================
  15.  
  16.  # /usr/lib64/php7.0/bin/php test.php
  17. Array
  18. (
  19.     [0] => 2233387401
  20.     [SI_SUBJECTS_PKG_S.GET_SUBJ_VALUE_TYPE_ID(:P1,SI_SUBJECTS_PKG_S.GET_SUBJ_TYPE_ID(:P2))] => 2233387401
  21. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement