Stored Procedure in MySql

[ravindra patil]

Sorry i know this is not particular section to post my issue but there is no section available for MySql due to that i am posting my issue over here.

This is my stored procedure but it is not working ...

CREATE PROCEDURE sp_select_custId (IN custId INTEGER)
BEGIN
select * from customer c,tapedelivery t where c.CustomerID=t.CustomerId And c.CustomerID = custId;
END;

But it is not running ..it is giving error ..please suggest me correct syntax/way to create this procedure.

[Mark Spritzler]

Sorry, it is the wrong forum to post this and we don't have an appropriate forum for you to post it.

We can leave this here for now, but you might want to try and find a MySql forum or check out the MySql website for more help.

Mark

[Mark Spritzler]

In Oracle

This

c.CustomerID = custId;

would need to be

c.CustomerID = :custId;

The ":" is binding the var to the statement.

Mark