locked
Inserting data into DataBase Table(Oracle) using WCF RRS feed

  • Question

  • User-1059022209 posted

    I am trying to create a service to insert data from a GridView Control into the database table.Please help me out with the service code.Have already created a stored procedure for the same:

    CREATE

    OR REPLACE PROCEDURE insertEmpDetails

    (

       p_EmployeeId

    IN MYEMPLOYEES.EMP_ID%TYPE,

       p_FirstName

    IN MYEMPLOYEES.FIRST_NAME%TYPE,

       p_LastName

    IN MYEMPLOYEES.LAST_NAME%TYPE

    )

    AS

    BEGIN

    INSERT INTO MYEMPLOYEES

      (EMP_ID, FIRST_NAME, LAST_NAME)

    VALUES (

      p_EmployeeId,

      p_FirstName,

      p_LastName

      );

    COMMIT;


    END;

    PLEASE HELP.

    Tuesday, October 22, 2013 5:18 AM

Answers