i've changed the procedure to first try & insert 2 values into one simple table -districts.
am using D7 & IB7.1
after execproc, the data doesnt show in the database
the stored procedure is :
set term ^;
create stored procedure insert_district
(distname, distcode)
as begin
(districtname, districtcode);
end
values
(
:distname,
:distcode
);
set term ;^