17,090
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION insert_tblcustomers(customerid IN NUMBER,DOB IN DATE)
RETURN VARCHAR2
AS
begin
EXECUTE IMMEDIATE 'insert into tblcustomers values (to_char(:customerid)', :dob)'
using customerid, dob ;
EXECUTE IMMEDIATE 'commit';
return '1';
end;
EXECUTE IMMEDIATE 'insert into tblcustomers values ('''||customerid||''',to_date('''||to_char(DOB,'yyyymmdd')||''',''yyyymmdd''),''' )' ;