return value from stored procedure..

[Guest_imported]

I need a value( true or false - or a single row ) returned by a stored procedure.. but i don't know why i can't return the value.. it keeps returning an error message( compilation errors )... It looks a very simple procedure.. and I want to execute this procedure on the browser... please, help me...

-------------------------------------------------------
CREATE OR REPLACE PROCEDURE SP_BADWORD
( WORD IN VARCHAR, BADWORD_MODE OUT VARCHAR )
IS
BEGIN
SELECT BADWORD INTO BADWORD_MODE FROM SY_BADWORDS WHERE BADWORD = WORD;

END SP_BADWORD;
-------------------------------------------------------

 

[carp]

I tried taking your code verbatim and it compiled and worked fine.