I have a stored procedure that deletes a record based on the input parameter passed. I do not know what is going wrong but the below code is not working.
I have the table initially:
After I call myProd('abc') I expect to see 3 recrds except for 'abc' above.
What could be the correct oracle procedure for it....
Thanks in advance.
Procedure myProd(branch_name IN varchar2) AS
DELETE FROM MyTab WHERE BRANCH_NAME = ' || branch_name || '; --deleting no records.
-- DELETE FROM MyTab WHERE BRANCH_NAME = branch_name; //deleting all records!!