Stored Procedure with constants
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;
Subject
Views
Written By
Posted
Stored Procedure with constants
5149
February 24, 2017 11:20PM
1059
February 25, 2017 07:48AM
978
February 25, 2017 08:30PM
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.