Subject | How to call Stored procedure? |
---|---|
Author | Andrew Guts |
Post date | 2002-12-14T15:57:45Z |
Hello all,
Please give me a working example that calls an 'exec type' stored
procedure like this:
create procedure AddRec(cdate timestamp, name varchar(80)) returns (id
integer) as
begin
id = GEN_ID(G_Tab1ID, 1);
insert into Tab1(ID, Name, CDate) values (:ID, :Name, :CDate);
end
Thanks ahead
Andrew
Please give me a working example that calls an 'exec type' stored
procedure like this:
create procedure AddRec(cdate timestamp, name varchar(80)) returns (id
integer) as
begin
id = GEN_ID(G_Tab1ID, 1);
insert into Tab1(ID, Name, CDate) values (:ID, :Name, :CDate);
end
Thanks ahead
Andrew