i am using oracle database 11g enterprise edition relese 11.2.0.1.0
i am using visual studio 2008
my table stucture in oracle database is as follows.
NAME VARCHAR2(20)
ADD1 VARCHAR2(20)
ADD2 VARCHAR2(20)
i have a stored prodedure.
create or replace procedure testcusp
(
p_name varchar,
p_Add1 varchar,
p_Add2 varchar
)
as
begin
insert into testcus values(p_name,p_Add1,p_Add2);
commit;
end;
/
When i run the webpage i am able to insert records and the are stored in DATATABLE.
Then using a button on the form i try to save all the rows in data table