My error or bug ?
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
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.