Re: Problem with creating a stored procedure
Posted by:
Rick James
Date: April 22, 2012 11:16PM
> Then how would I ever learn?
1. Simplify the test cases -- you don't need 11 arguments for learning; 1 or 2 should suffice.
2. Test the statements manually -- your original INSERT statement would have failed because of using the wrong type of quotes.
3. Look at examples. Most (not all) are explicit about having DELIMITER before and after.
4. Look more carefully. (I admit these are subtle.)
* "Delimiter $$ CREATE..." -- The "delimiter $$" "statement" takes up a whole line; you cannot have CREATE... (or anything else) on the line with it.
* "Delimiter;" needs a space between "delimiter" and ";".
Subject
Views
Written By
Posted
2313
April 13, 2012 03:08PM
1124
April 15, 2012 11:43PM
1132
April 19, 2012 04:20PM
1298
April 19, 2012 04:46PM
1072
April 19, 2012 05:56PM
1111
April 19, 2012 08:47PM
1238
April 19, 2012 11:35PM
1293
April 19, 2012 11:50PM
1091
April 21, 2012 06:03AM
990
April 21, 2012 10:37AM
1098
April 21, 2012 12:57PM
1002
April 21, 2012 10:17PM
Re: Problem with creating a stored procedure
981
April 22, 2012 11:16PM
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.