Calling a stored procedure in PL/SQL-Oracle

The stored procedure has been written in oracle10,CodeAs follows:

 
Create or replace procedure proc_insert (sname in varchar2, sage in int, sexetime in varchar2) isbegin insert into t_test (c_id, c_name, c_age, c_intime, c_exetime) values (values, sname, sage, sysdate, to_date (sexetime, 'yyyy-mm-dd'); End proc_insert;
 

 

To call this stored procedure in PL/SQL, the following code is used:

Begin
Proc_insert ('hello6', 25, '2017-12-24 ');
Commit;
End;

 

In addition, a stored procedure is added, but sexetime is of the date type. Therefore, you must convert the string to the date type before calling. Otherwise, the call will fail.

Stored Procedure:

Create or replace procedure proc_insert2 (sname in varchar2, sage in int, sexetime in date) isbegin insert into t_test (c_id, c_name, c_age, c_intime, c_exetime) values (values, sname, sage, sysdate, sexetime); End proc_insert2;
 

Call code:

 

Begin
Proc_insert2 ('hellowh', 26, to_date ('2017-10-20 ', 'yyyy-mm-dd '));
Commit;
End;