shaddf Posted September 9, 2015 Share Posted September 9, 2015 what data type can I use to define a text field input parameter in the stored procedure below;in the data base table it is defined as: comment text, and in the stored procedure how can I define it: CREATE PROCEDURE sp_ne comm(in in_Nature_id varchar(256)/text) MODIFIES SQL DATA BEGIN insert into me(comment)values(in_Nature_id ie vvvv uygliuyiuyo......>256 characters); END Quote Link to comment https://forums.phpfreaks.com/topic/298112-how-to-set-the-datatype-for-text-in-stored-procedure/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.