在oracle10中写好了存储过程,代码如下:
CREATE OR REPLACE Procedure Proc_Insert
(
sName in varchar2,
sAge in int,
sExeTime in varchar2
)
is
begin
Insert into T_TEST(C_ID, C_NAME, C_AGE, C_INTIME, C_EXETIME)
values(T_TEST_CID.nextval,sName,sAge, sysdate, to_date(sExeTime, 'yyyy-mm-dd'));
end Proc_Insert;CREATE OR REPLACE