-
Stored Procedure
Can anyone please help me - I am new to Oracle and trying to learn how to create a simple stored procedure.
I wanted to convert the following MS SQL stored procedure to an Oracle stored procedure - see my attempt below:
MS SQL stored procedure:
CREATE PROCEDURE InsertHelpDesk
(
@EmployeeID int,
@Description nvarchar,
)
AS
INSERT INTO HelpDesk (EmployeeID, Description)
VALUES (@EmployeeID, @Description)
---------------------------------------------------------
Oracle Stored procedure attempt:
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|