For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
In SQL Server Create procedure EmpType @EmpType varchar(10) AS select * from Employee where EmpType = @EmpType GO exec EmpType('exempt') That returns a result set. How do I do that in Oracle? I have tried many different ways and all returned errors.