Hi all

I am trying to do one Stored Procedure (MySql database) and excecute it in
Delphi.

For beginning I wrote and compilled one easy Procedure in PL/SQL which is:

create procedure Sample()
Begin
Select * from A;
End


Then in Delphi, using Button click iam trying to call that Procedure By the
following Way;

storedProc1.close;
storedProc1.connection := Conn;
StoredProc1.open;(or) ExecProc

AdoDataSet1.Recordset := StoredProc1.recordset.

When iam trying to do this iam getting error stating

OleExecption with Message [MySql][ODBC 3.51 Driver][mysqld-5.0.13-rc-nt]
Sql Syntax Error, Error near to 'Call Sample1()'


What I did wrong, Please Send Me Sample Program for the same

Thanks in Advance

Balu