Re: Need help with stored procedures in MySQL

Hi Sreedhar, all! madderla sreedhar wrote: --- Joerg Bruehe [EMAIL PROTECTED] wrote: Hi! [[...]] The manual states clearly: Stored procedures and functions are a new feature in MySQL version 5.0. (At the proper place: 19 Stored Procedures and Functions) Sreedhar, if you have a follow-up

Need help with stored procedures in mysql

__ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need help with stored procedures in MySQL

Hi, Iam looking to migrate an Oracle database to MySQL and trying to write a simple stored procedure in MySQL 4.1 .I reffered few examples posted and used the statements from them but I get errors while creating procedures create procedure helloworld (out p_text VARCHAR(30)) BEGIN set p_text =

Re: Need help with stored procedures in MySQL

Hi! madderla sreedhar wrote: Hi, Iam looking to migrate an Oracle database to MySQL and trying to write a simple stored procedure in MySQL 4.1 The manual states clearly: Stored procedures and functions are a new feature in MySQL version 5.0. (At the proper place: 19 Stored Procedures and

Need help with Stored Procedures iin MySQL 5.0.3-beta

Hi, I am looking to migrate an Informix database to MySQL and trying to write a simple stored procedure in MySQL 5.0.3. I referred to few examples posted and used the statements from them but i get errors while creating this procedure. CREATE PROCEDURE sp_test ( IN user_idinteger,

Re: Need help with Stored Procedures iin MySQL 5.0.3-beta

Dinesh, Do you have something like DELIMITER | before the CREATE PROCEDURE call, and | DELIMITER ; after it? Peter Brawley http://www.artfulsoftware.com - Anchan, Dinesh wrote: Hi, I am looking to migrate an Informix database to MySQL and trying to write a simple stored

RE: Need help with Stored Procedures iin MySQL 5.0.3-beta

but i will get there. Thanks for your help. Dinesh From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 12:03 PM To: Anchan, Dinesh Cc: mysql@lists.mysql.com Subject: Re: Need help with Stored Procedures iin MySQL 5.0.3-beta Dinesh, Do

Re: Need help with Stored Procedures iin MySQL 5.0.3-beta

]] Sent: Friday, April 01, 2005 12:03 PM To: Anchan, Dinesh Cc: mysql@lists.mysql.com Subject: Re: Need help with Stored Procedures iin MySQL 5.0.3-beta Dinesh, Do you have something like DELIMITER | before the CREATE PROCEDURE call, and | DELIMITER ; after it? Peter Brawley http