Re: Parameters for table, field and searchValue
Got it !
PROCEDURE `usp_CheckForValue`(IN p_tbl varchar(50), IN p_fld varchar(50), IN p_searchValue varchar(50))
BEGIN
SET @t = p_tbl;
SET @f = p_fld;
SET @search = p_searchValue;
SET @s = CONCAT("SELECT ", @f, " FROM ", @t, " WHERE ", @f, " = @search" );
PREPARE stmt FROM @s;
EXECUTE stmt;
END
Subject
Views
Written By
Posted
2349
October 13, 2015 04:53PM
828
October 13, 2015 11:57PM
938
October 14, 2015 02:45PM
Re: Parameters for table, field and searchValue
977
October 14, 2015 04:09PM
763
October 24, 2015 10:50PM
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.