Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $p1 = ':p1'; $p2 = ':p2';
- $v1 = 'deny_self_tariff_change'; $v2 = 296090391;
- $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");
- oci_bind_by_name($sth, $p1, $v1, -1);
- oci_bind_by_name($sth, $p2, $v2, -1);
- oci_execute( $sth );
- print_r( oci_fetch_array($sth) );
- =======================
- result:
- =======================
- # /usr/lib64/php7.0/bin/php test.php
- Array
- (
- [0] => 2233387401
- [SI_SUBJECTS_PKG_S.GET_SUBJ_VALUE_TYPE_ID(:P1,SI_SUBJECTS_PKG_S.GET_SUBJ_TYPE_ID(:P2))] => 2233387401
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement