MySQL Forums
Forum List  »  Stored Procedures

My error or bug ?
Posted by: Federico Giampietro
Date: June 23, 2005 06:11AM

I wrote this simple procedure on 5.0.7 beta:

CREATE PROCEDURE `caronte`.`sptraduzione`(IN ptabella char(16), IN pbroker char(16), IN pnome char(16))
BEGIN
SELECT valore
FROM ptabella
WHERE broker = pbroker AND nome = pnome;
END

When I try to recall it :

call sptraduzione('tradconti', 'CARGILL', '7505P')

I get :

1146-Table caronte.ptabella doesn't exist.

Why?????
Why stored procedure don't use the CONTENT of parameter ptabella ?

To developers:
Please add some Stored Procedures example into the documentation... how to debug it without ?

Thanks, Federico

Options: ReplyQuote


Subject
Views
Written By
Posted
My error or bug ?
2814
June 23, 2005 06:11AM
2000
June 23, 2005 07:15AM
1890
June 23, 2005 07:47AM
1905
June 23, 2005 08:26AM


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.