Results 1 to 2 of 2

Thread: Stored Procedures Getting Dropped

  1. 01-11-2006, 08:57 AM #1
    bubbab
    bubbab is offline Registered User
    Join Date
    Jan 2006
    Posts
    1

    Stored Procedures Getting Dropped

    We're running MySQL 5.0.18 which supports stored procedures. However, I can only create one at a time. If I create a stored proc and go to create another, the previous is dropped. Say, for example, I have a SP called spCUSTOMERS. If I go to create another SP, say spVENDORS, the spCUSTOMERS is gone. Has anyone experienced this and is their a fix?

    The latest patches were applied to our server (Win 2003) so I can't understand why this is happening. For whatever it's worth, the same thing is happens when creating views. I create view1 successfully. But if I create view2, view one is gone. I'm new to MySQL so this is not creating a good impression.

    Brian
    Reply With Quote Reply With Quote
  2. 01-12-2006, 02:44 PM #2
    chazzy
    chazzy is offline Registered User
    Join Date
    Jan 2006
    Posts
    1
    just wondering, what syntax are you using to create the procedures?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules