Скачать или смотреть 63 Stored Procedures in webmethods

In this video i have demostrated how to use stored procedures in webMethods and created a stored procedure in DB and called the same from designer.
CREATE TABLE EMPDETAILSDEC
( "EMPID" VARCHAR2(20 BYTE),
"FIRSTNAME" VARCHAR2(20 BYTE),
"LASTNAME" VARCHAR2(20 BYTE),
"GENDER" VARCHAR2(10 BYTE),
"EMAIL" VARCHAR2(100 BYTE),
"DATEOFBIRTH" DATE,
"JOBTITLE" VARCHAR2(100 BYTE)
);
CREATE TABLE EMPDETAILSDEC1
( "EMPID" VARCHAR2(20 BYTE),
"FIRSTNAME" VARCHAR2(20 BYTE),
"LASTNAME" VARCHAR2(20 BYTE),
"GENDER" VARCHAR2(10 BYTE),
"EMAIL" VARCHAR2(100 BYTE),
"DATEOFBIRTH" DATE,
"JOBTITLE" VARCHAR2(100 BYTE)
);
CREATE TABLE EMPDETAILSDEC2
( "EMPID" VARCHAR2(20 BYTE),
"FIRSTNAME" VARCHAR2(20 BYTE),
"LASTNAME" VARCHAR2(20 BYTE),
"GENDER" VARCHAR2(10 BYTE),
"EMAIL" VARCHAR2(100 BYTE),
"DATEOFBIRTH" DATE,
"JOBTITLE" VARCHAR2(100 BYTE)
);
create or replace PROCEDURE empDetailsDecSP1 (
EmpID IN VARCHAR2,
FirstName IN VARCHAR2,
LastName IN VARCHAR2,
Gender IN VARCHAR2,
email IN VARCHAR2,
DateOfBirth IN VARCHAR2,
JobTitle IN VARCHAR2,
EMPLID OUT varchar2)
AS
BEGIN
INSERT INTO empDetailsDec
(EmpID,
FirstName,
LastName,
Gender,
email,
DateOfBirth,
JobTitle)
VALUES (EmpID,
FirstName,
LastName,
Gender,
email,
To_date(DateOfBirth, 'YYYY-MM-DD'),
JobTitle);
INSERT INTO empDetailsDec1
(EmpID,
FirstName,
LastName,
Gender,
email,
DateOfBirth,
JobTitle)
VALUES (EmpID,
FirstName,
LastName,
Gender,
email,
To_date(DateOfBirth, 'YYYY-MM-DD'),
JobTitle) ;
INSERT INTO empDetailsDec2
(EmpID,
FirstName,
LastName,
Gender,
email,
DateOfBirth,
JobTitle)
VALUES (EmpID,
FirstName,
LastName,
Gender,
email,
To_date(DateOfBirth, 'YYYY-MM-DD'),
JobTitle)
returning EmpID INTO EMPLID;
END empDetailsDecSP1;