Php errors occurred when calling oracle Storage. php oracle Storage
RepliCel stored procedure:
Create or replace package AA_TEST is -- Author: ADMINISTRATOR -- Created: 12:30:24 -- Purpose: -- Public type declarations type myCursor is ref cursor; procedure getSysdate (in_byzd1 in string, in_byzd2 in string, in_byzd3 in string, out_flag out string, out_msg out string, o_cursor out myCursor); end AA_TEST;/create or replace package body AA_TEST is procedure getSysdate (in_byzd1 in, I N_byzd2 in string, in_byzd3 in string, out_flag out string, out_msg out string, o_cursor out myCursor) is begin out_flag: = '1'; out_msg: = 'execution successful! '; Open o_cursor for select sysdate, in_byzd1, in_byzd2, in_byzd3 from dual; end AA_TEST ;/
Php code
$sql_sp = "begin HTS.AA_TEST.getSysdate(:in_byzd1,:in_byzd2,:in_byzd3,:out_flag,:out_msg,:o_cursor); end;"; $stmt = oci_parse($conn, $sql_sp);oci_bind_by_name($stmt,':in_byzd1',$in_byzd1);oci_bind_by_name($stmt,':in_byzd2',$in_byzd2);oci_bind_by_name($stmt,':in_byzd3',$in_byzd3);oci_bind_by_name($stmt,':out_flag',$out_flag);oci_bind_by_name($stmt,':out_msg',$out_msg);oci_bind_by_name($stmt,':o_cursor',$o_cursor);oci_execute($stmt);$result=oci_fetch_assoc($stmt);print_r($result);
Error
Warning: oci_execute (): ORA-06550: 1st rows, 7th columns: PLS-00306: number of parameters or type error when calling 'getsysdate' ORA-06550: 1st rows, 7th columns: PL/SQL: statement ignored in C: \ xampp \ htdocs \ ceshi \ index. php on line 15
I just got in touch with the php link to oracle! Please kindly advise
Reply to discussion (solution)
Hello, have you solved this problem?
I encountered the same problem. How did you solve it? Thank you very much!