Re: Can not compile procedure

[Vishal Mathur]

hi
thanks for the reply,
The problem was something with upgrade, it did not work. then I uninstalled 
completely and reinstalled ver5.0. It started working
thanks very much
vishal


From: rdo mail list address <rdomail@stripped>
To: win32@stripped
Subject: Re: Can not compile procedure
Date: Sat, 31 Jul 2004 10:23:42 -0500


I subscribed to the list after the thread with the abovementioned subject
was started, and I don't see any way to reply to it using the web browser,
so I'm posting with "Re:" prepended to the subject.

Vishal Mathur writes that he can not use the delimiter statement, using 5.0
on win2k professional.  Since I also use that same OS, I thought I'd try
his procedure:

C:\>mysql -u rdo
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> delimiter //
mysql> CREATE PROCEDURE simpleproc(out param1 int)
     -> BEGIN
     ->   select count(*) into param1 from lca_lookups;
     -> END;
     -> //
Query OK, 0 rows affected (0.11 sec)

mysql> delimiter ;

Since it appears to compile ok here, delimiter statement and all, I don't
know what to say.  What server are you using - mysqld, or mysqld-nt?





--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    
http://lists.mysql.com/win32?unsub=1

_________________________________________________________________
Marriage?  http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 Join 
BharatMatrimony.com for free.