Re: Stored procedure doesn't work correctly
Pay attention to error messages. Of this cmd ...
set @st2 = CONCAT_WS('', 'GRANT SELECT ON', ' ','\'',`%`,'\'','.*', ' ', 'TO', ' ', @eid) ;
MySQL says: "Unknown column '%' in 'field list'".
What problem is putting this code in an sproc meant to solve?
Subject
Views
Written By
Posted
4182
March 03, 2017 09:22PM
Re: Stored procedure doesn't work correctly
667
March 03, 2017 11:06PM
544
March 03, 2017 11:17PM
507
March 04, 2017 12:59AM
626
March 06, 2017 10:33AM
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.