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
2480
April 13, 2012 03:08PM
1194
April 15, 2012 11:43PM
1201
April 19, 2012 04:20PM
1417
April 19, 2012 04:46PM
1157
April 19, 2012 05:56PM
1188
April 19, 2012 08:47PM
1322
April 19, 2012 11:35PM
1377
April 19, 2012 11:50PM
1161
April 21, 2012 06:03AM
1074
April 21, 2012 10:37AM
1170
April 21, 2012 12:57PM
1078
April 21, 2012 10:17PM
Re: Problem with creating a stored procedure
1088
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.