CREATE PROCEDURE INSERTHELPDESK
(
: EMPLOYEEID NUMBER;
: DESCRIPTION NVARCHAR;
)
AS
BEGIN
INSERT INTO HELPDESK (EMPLOYEEID, DESCRIPTION)
VALUES (: EMPLOYEEID, : DESCRIPTION)
END;
I keep getting compile errors with the Oracle stored procedure. Can anyone tell me what's wrong or an example of how it should be. I am passing parameter values in from an asp.net web application. Any help much appreciated. Daniel
Bookmarks