At 12:12 PM 14/06/2003 +0000, you wrote:

>Hi,
>
>Could someone tell me why this simple stored procedure
>is returning no rows, even though I know for sure it
>should return rows for the id I pass in?
>
>SET TERM !! ;
>CREATE PROCEDURE SP_GET_USER (v_user_id INTEGER)
> RETURNS (r_id INTEGER, r_first_name VARCHAR(20),
>r_mi CHAR(1), r_last_name VARCHAR(30))
> AS
> BEGIN
> SELECT id, first_name, mi, last_name FROM USERS
>WHERE id = :v_user_id
> /* INTO :r_id, r_first_name, r_mi, r_last_name; */

INTO :r_id, :r_first_name, :r_mi, :r_last_name;

> EXIT; <--------------------- not needed
> END !!
>SET TERM ; !!

SQL questions don't belong in the Java forum. Take them to firebird-support.

Helen