MySQL Forums :: Stored Procedures :: Stored Procedure with constants


Advanced Search

Stored Procedure with constants
Posted by: Dipak Kumar Choudhury ()
Date: February 24, 2017 11:20PM

Dear friends,
The oracle procedure works fine for constants. But how to write a MySql procedure with the following statements-

DELIMITER $$

CREATE DEFINER=`root`@`localhost`
PROCEDURE 'sp_constants'

begin
-- Constants Used

NO_RECORD constant INT := 0;
RECORD_PRESENT constant INT := 1;

ACTION_INSERT constant CHAR(1) := 'I';
ACTION_UPDATE constant CHAR(1) := 'U';


end;

Options: ReplyQuote


Subject Views Written By Posted
Stored Procedure with constants 348 Dipak Kumar Choudhury 02/24/2017 11:20PM
Re: Stored Procedure with constants 36 Peter Brawley 02/25/2017 07:48AM
Re: Stored Procedure with constants 55 Dipak Kumar Choudhury 02/25/2017 08:30PM


Sorry, only registered users may post in this forum.

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.