TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
aylin_sk
NA
87
0
how to insert data into database
Dec 9 2004 8:35 AM
When I want to insert records into database, it doesnt insert..and i found this error..Please help me finding this error in my code... Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'ADD_PATIENT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Source: System.Data.OracleClient .aspx.cs script: private void Button1_Click(object sender, System.EventArgs e) { coreLpms.patients myPatient = new coreLpms.patients(); string patientPotential = "H"; if (cbPatientPotential.Checked) patientPotential = "E"; else patientPotential = "H"; if (myPatient.addPatient(textPatientName.Text, textPatientLastName.Text, comboPatientSex.SelectedItem.Value, textPatientTreatStartDate.Text, textPatientBirthdate.Text, textPatientParent.Text, textPatientPhone.Text, textPatientAddress1.Text, textPatientAddress2.Text, comboPatientCountyId.SelectedItem.Value, comboPatientCityId.SelectedItem.Value, textPatientZipCode.Text, comboPatientGroup.SelectedItem.Value, textPatientExplanation.Text, textPatientWeek.Text, patientPotential)) { myError.Visible = false; } else { myError.Visible = true; ((Label)myError.FindControl("labelError")).Text = myPatient.myError.getLastError(); } } } ----- This is my stored procedure: CREATE OR REPLACE PACKAGE BODY PATIENTS_PKG IS procedure GET_PATIENT (resultset out globals.resultset, p_patient_number in number) is begin open resultset for select * from LPMS.PATIENTS where PATIENT_NUMBER = p_patient_number; end; procedure ADD_PATIENT (p_patient_name in varchar2, p_patient_last_name in varchar2, p_patient_sex in varchar2, p_patient_treat_start_date in varchar2, p_patient_birthdate in varchar2, p_patient_parent in varchar2, p_patient_phone in varchar2, p_patient_address1 in varchar2, p_patient_address2 in varchar2, p_patient_county_id in number, p_patient_city_id in number, p_patient_zipcode in varchar2, p_patient_group in varchar2, p_patient_explanation in varchar2, p_patient_period in varchar2, p_patient_week in number, p_patient_potential in varchar2, p_patient_record_status in varchar2) is begin insert into LPMS.PATIENTS values(PATIENT_ID_SEQ.nextval, p_patient_name, p_patient_last_name, p_patient_sex, to_date(p_patient_treat_start_date, 'dd-mm-yyyy'), to_date(p_patient_birthdate, 'dd-mm-yyyy'), p_patient_parent, p_patient_phone, p_patient_address1, p_patient_address2, p_patient_county_id, p_patient_city_id, p_patient_zipcode, p_patient_period, p_patient_group, p_patient_explanation, p_patient_week, p_patient_potential, p_patient_record_status); end; END; /
Reply
Answers (
1
)
What is indexer?
create object of a class at runtime