MySQL Forums
Forum List  »  Stored Procedures

Re: Help - variable removing leading "0" in stored procedure
Posted by: John Constantine
Date: January 12, 2006 04:33AM

Hi,

Thanks for your comments Emma.

I've tried fidling with that but to no luck. I've tried setting the variable as follows too :

use mydbwhatever;
DELIMITER //
CREATE PROCEDURE P1(p VARCHAR)
BEGIN
DECLARE x VARCHAR(50)
SET @x = p;
select @x ;
END;
//

It doesn;t complain about this setup above but it still strips the 0.

I've also tried setting it to TEXT/blob/CHAR too , but to no effect:-(

Any thoughts appreciated.

Thanks

JC

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Help - variable removing leading "0" in stored procedure
1400
January 12, 2006 04: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.