Re: can't call procedure
If thats the exact code you have written then the problem is that you create the procedure as CC but the call is to SS.
If thats just a typo in the post then maybe it's being applied to a different database. Use the following select on the information schema to see where it's being created.
SELECT routine_schema, routine_name FROM information_schema.routines
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Subject
Views
Written By
Posted
4578
April 15, 2005 02:27AM
Re: can't call procedure
2408
April 15, 2005 03:30AM
2364
April 15, 2005 06:23AM
2321
April 15, 2005 08:19AM
2572
April 15, 2005 11:33AM
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.