Re: stored procedure vs parámetro de salida
No uso ODBC o ADO, pero debería funcionar. Tienes que capturar la salida con variables de usuario, que luego puedes consultar con SELECT, por ejemplo así:
CREATE PROCEDURE Ejemplo (IN i INT, OUT o INT) DETERMINISTIC
SET o = i + 1;
...
CALL Ejemplo(1, @a);
SELECT @a; ===> 2
Un saludo,
Miguel Pérez
Afina Sistemas - Partner de MySQL en España
Subject
Views
Written By
Posted
15666
March 04, 2008 08:14AM
3836
March 04, 2008 11:31AM
3389
March 04, 2008 12:59PM
3053
July 10, 2008 12:50PM
7388
March 05, 2008 02:35AM
2940
March 05, 2008 04:43AM
2958
March 06, 2008 05:00AM
Re: stored procedure vs parámetro de salida
3496
March 07, 2008 03:52AM
2957
March 07, 2008 08:36AM
4228
March 07, 2008 09:02AM
3363
March 07, 2008 10:27AM
3171
May 03, 2008 05:02PM
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.