php - How to resolve ORA-01036 -


i creating online system using php , oracle oci8.

anyone here have encountered error: 

warning: oci_bind_by_name() [function.oci-bind-by-name]: error while trying retrieve text error ora-01036 in dbcontrol.php on line 50 success

here dbcontrol.php:

function plsql_insert($plsql, $array){         $this -> connect(); //create database connection         $this -> statement = oci_parse($this -> conn, $plsql); //prepare statement call pl/sql stored procedure          foreach ($array $key => $value){             oci_bind_by_name($this -> statement, $key, $array[$key]);         }          $this -> execute = oci_execute($this -> statement); //execute statement         $this -> result = ($this -> execute) ? "success" : "failed";         return $this->result;     }

here code calls function:

include "../dbaseconn/dbcontrol.php";  extract($_get);  $personalbackground = explode(",",$personalbackground);  $arrpersonal = array();  foreach($personalbackground $val) {     $tmpdata = explode("*",$val);     $arrpersonal[$tmpdata[0]]=$tmpdata[1]; } $arrpersonal[':rec_no'] = '4'; $plsql = "call test.insert_back_personal(:name_last,:name_first,:name_middle,:present_address,:mobile_phone,:permanent_address,:home_number,:date_of_birth,:birth_place,:civil_status,:sss_no,:tin,:philhealth_no,:hdmf_no,:blood_type,:gender,:gov_license,:email_address,:rec_no)"; $dbcontrol = new dbcontrol; echo $dbcontrol->plsql_insert($plsql,$arrpersonal);

and pl/sql block:

create or replace package body recruit.test                            procedure insert_back_personal( v_name_last in varchar2,                   v_name_first in varchar2,                   v_name_middle in varchar2,                   v_present_address in varchar2,                   v_mobile_phone in varchar2,                   v_permanent_address in varchar2,                   v_home_number in varchar2,                   v_date_of_birth in char,                   v_birth_place in char,                   v_civil_status in char,                   v_sss_no in varchar2,                   v_tin in varchar2,                   v_philhealth in varchar2,                   v_hdmf_no in varchar2,                   v_blood_type in varchar2,                   v_gender in char,                   v_gov_license in varchar2,                   v_email_address in varchar2,                   v_rec_no in varchar2                   )                    --out_data out cv_type               begin                      insert  recruit.back_personal (rec_no, name_last,name_first, name_middle,                                                present_address, mobile_phone, permanent_address,                                                 home_number, date_of_birth, birth_place, civil_status,                                                sss_no, tin, philhealth_no, hdmf_no,                                                 blood_type, gender, gov_license, email_address, insertdate)           values (v_rec_no, v_name_last, v_name_first, v_name_middle,                   v_present_address, v_mobile_phone, v_permanent_address,                   v_home_number, v_date_of_birth, v_birth_place, v_civil_status,                    v_sss_no, v_tin, v_philhealth, v_hdmf_no,                    v_blood_type, v_gender, v_gov_license, v_email_address, sysdate                   );           commit;   end insert_back_personal;

as try this, can insert database having warning: ora-01036. kinda annoying.

how solve issue?

please visit answer same want...it direct written pl/sql block instead of call procedure....

recover table of varchar2 pl/sql function in php


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

java - More than one row with the given identifier was found: 1, for class: com.model.Diagnosis -

below model, service implementation , error trace of code. model class: @entity @table(name = "ph_diagnosis_history") @jsonidentityinfo(generator = objectidgenerators.propertygenerator.class, property = "id",scope=diagnosis.class) public class diagnosis extends abstractentity { @column(name = "diagnosis_notes", length=255) @length(max = 255, message = iprprop.max_len_255_msg) private string diagnosisnote; @enumerated(enumtype.string) private diagnosistypeenum type; @temporal(temporaltype.date) @column(name = "diagnosis_date") @jsonserialize(using = jsondateserializer.class) private date diagnosisdate; @manytoone @joincolumn(name = "patient_chart_id") private patientchart patientchart; public string getdiagnosisnote() { return diagnosisnote; } public void setdiagnosisnote(string diagnosisnote) { this.diagnosisnote = diagnosisnote; } public d...
Read more