I'm a Firebird newbie, so please bear with me :-)

I tried a stored procedure

CREATE PROCEDURE DELETE_PROPERTY (THE_PROPERTY_ID INTEGER)
AS

begin
/* DELETE FROM PROPERTY_STYLE TABLE */

DELETE FROM PROPERTY_STYLE WHERE property_id = :THE_PROPERTY_ID;

/*property_features*/

DELETE FROM PROPERTY_FEATURES WHERE PROPERTY_ID = :THE_PROPERTY_ID;

SUSPEND;
end

... then, whenever I run this sql command in PHP:

SELECT * FROM DELETE_PROPERTY WHERE the_property_id = 12

I got this error:

Dynamic SQL Error SQL error code = -84 procedure DELETE_PROPERTY does
not return any values At line 1, column 31

Can you please help me find out where I have gone wrong?

Thanks.

Arnold