Skip to main content

Posts

Showing posts with the label MySQL

MySQL Stored Procedure Error

In our project we had many many stored procedures and many parameters passes to those sps. But in only one sp it gives error message something like this; "Incorrect number of arguments for PROCEDURE sproc_t_l_Contract_Select_BySearchCriteria; expected 3, got 2” Work long time on this sp but coudnt find it. So i tried to write it again from the begining. In this time it was work perfectly.This problem occurs because of the space between data type and its length. Ex. pName varchar(50) - working pName varchar (50) - Not working But it does not mention syntax error or something.So this error message make us vulnerable.
1 comment
Read more

MSSQL to MySQL

To day i was struggling to catch a error inside a stored procedure using MySQL. Faced lot of difficulties and still not found good result. There is no equal function in MySql to RAISERROR in MSSQL. As a solution for this what we can we do is, we can call a function as this way CALL RaiseError(); There for because of the none existence of this function this will be raise an error. So it is very logical..:-) So procedure will be work very fine.....Great... Example: DROP PROCEDURE IF EXISTS `dbname`.`procedureName` $$ CREATE DEFINER=`root`@`%` PROCEDURE `edbname`.`procedureName`( pId bigint, pName varchar(50) BEGIN IF EXISTS (SELECT 1 FROM tableName WHERE ((Id = pId) ) THEN UPDATE tableName SET Name = pName, WHERE (Id = pId); ELSE CALL RaiseError(); /*There is no RaiseError metho in MySql. Because of that reason here call nonexistent method which is 'Rais...
Post a Comment
Read more