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;
- $args = [ [$p1, $v1], [$p2, $v2] ];
- $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");
- foreach( $args as $a ) {
- oci_bind_by_name($sth, $a[0], $a[1], -1);
- }
- oci_execute( $sth );
- print_r( oci_fetch_array($sth) );
- ===================
- result:
- ===================
- # /usr/lib64/php7.0/bin/php test.php
- Array
- (
- [0] =>
- [SI_SUBJECTS_PKG_S.GET_SUBJ_VALUE_TYPE_ID(:P1,SI_SUBJECTS_PKG_S.GET_SUBJ_TYPE_ID(:P2))] =>
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement