Re: IF ELSE
Quote
DELIMITER //
drop procedure IF EXISTS CountIN ;
DELIMITER //
create procedure CountIn (ccnt INT)
The first line changes the delimiter from default ; to //
The second line, where you try to drop the procedure isn't executed because you use ; rather than //
So, after the first time, the procedure exists when you try to create it.
Good luck,
Barry.
Subject
Written By
Posted
Re: IF ELSE
March 22, 2023 05:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.