MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Stored proc syntax
Posted by: Peter Brawley
Date: May 23, 2012 03:49PM

Code must disambiguate column names and variable names, eg ...

Create PROCEDURE DefaultCheck(IN pUserID nvarchar(50) )
SELECT Defaults.UserID FROM Defaults WHERE UserID=pUserID;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Stored proc syntax
2262
Martin Gregson
May 23, 2012 02:19PM
Re: Stored proc syntax
947
Peter Brawley
May 23, 2012 03:49PM
Re: Stored proc syntax
908
Martin Gregson
May 24, 2012 03:03PM


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.