No, you are not.
Your storedproc shall look something like...
... you are almost there, nothing 20 or 30 hours of reading wouldn't fix.Code:Create Procedure Inserthelpdesk IS sql_stmt varchar2(200); Employeeid Number; Description varchar2(50); Begin Employeeid := 1 Description := 'TEST 1' sql_stmt := 'INSERT INTO Helpdesk(employeeid, Description) VALUES(:a, :b)'; EXECUTE IMMEDIATE sql_stmt USING Employeeid , Description; commit; End Inserthelpdesk; /




Reply With Quote