$conn = @oci_connect("username", "password", "192.168.177.34/labora") or die;
//$sql = 'BEGIN sayHello(:name, :message); END;';
$sql ='BEGIN mnc_subscribe.SMS_S_V_SEARCH_CUSTOMER_2(:IVDGT,:NELWAN,:a,:b,:c,:pPageNo,:d,:pTotalPage,:csrCustomer); END;';
$stmt = oci_parse($conn,$sql);
$csrCustomer = oci_new_cursor($conn);
// Assign a value to the input
$IVDGT = 'IVDGT';
$NELWAN = 'NELWAN';
$pPageNo = 5;
$a = '';
$b = '';
$c = '';
$d = 10;
$pTotalPage=0;
// Bind the input parameter
oci_bind_by_name($stmt,':IVDGT',$IVDGT,32);
oci_bind_by_name($stmt,':NELWAN',$NELWAN,32);
oci_bind_by_name($stmt,':pPageNo',$pPageNo,32);
oci_bind_by_name($stmt,':a',$a,32);
oci_bind_by_name($stmt,':b',$b,32);
oci_bind_by_name($stmt,':c',$c,32);
oci_bind_by_name($stmt,':d',$d,32);
// Bind the output parameter
oci_bind_by_name($stmt,':pTotalPage',$pTotalPage,32);
// Bind the cursor resource to the Oracle argument
oci_bind_by_name($stmt,":csrCustomer",$csrCustomer,-1,OCI_B_CURSOR);
oci_execute($stmt);
// Execute the cursor
oci_execute($csrCustomer);
// Use OCIFetchinto in the same way as you would with SELECT
while ($entry = oci_fetch_assoc($csrCustomer)) {
print_r($entry);
}
var_dump($pPageNo);var_dump($pTotalPage);
Ext.select('.datepicker').each(function(el){ new Ext.form.DateField({ allowBlank : true, renderTo: el, format:'m-d-Y', editable:false, width:140, fieldCls : 'tanggal x-form-field x-form-text x-trigger-noedit', }); }); Ext.select('.note').each(function(el){ new Ext.form.field.TextArea({ allowBlank : false, renderTo: el, grow : true, hideLabel : true, fieldCls : 'pesan x-form-field x-form-text x-trigger-noedit', }); });
Komentar
Posting Komentar