How to call a stored procedure in mysql?
5093Jul 3 2009 — edited Aug 27 2009Hi,
I set up a databaselink to mysql and it's ok, the select to the tables in mysql works o.k.
Select * from "tabla1"@bdpruebassp; and i get all rows from mysql. So the conection it's o.k
Now I have to call a store procedure, without parameters, I try
begin
procedureprueba@bdpruebassp;
end;
begin
"spprueba3"@bdpruebassp;
end;
but it doesn't work I get ORA-06550 PLS-00201 PL/SQL: Stament ignored
How can I solve this?
Thanks in advance