Re: conditional statements in stored procedure
IF (IN_paction = I)
-->
IF (IN_paction = "I")
SELECT MAX(tblMovies.intMoviesSystemId) into @RecordID FROM tblMovies LIMIT 1;
-->
SELECT MAX(tblMovies.intMoviesSystemId) into @RecordID FROM tblMovies;
Learn about INSERT ... ON DUPLICATE KEY UPDATE...
Subject
Views
Written By
Posted
3803
July 06, 2013 08:59PM
1082
July 07, 2013 05:04AM
Re: conditional statements in stored procedure
920
July 07, 2013 04:05PM
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.