problem with begin on the precedure of Derby

[nykel]

good morning, i am trying to create a procedure with Derby database base and an error occurs with the "begin" statement.

the source is like this

create procedure SPC_TESTAR()
begin    
	select nome from teste
end

the error message is like this

Erro de sintaxe: Encountered "begin" at line 2, column 1.

thanks for all reply..

[doWhile]

See the syntax for procedures CREATE PROCEDURE statement

[nykel]

thanks doWhile, i saw the link , eu i studied the sintax but is missing something to understand it.
have you a simple example? please.
i ned understand it.
thanks

[nykel]

hi, i am here again

i got the procedure like this

CREATE PROCEDURE APP.spc_testde(idade int)
PARAMETER STYLE JAVA
LANGUAGE JAVA
EXTERNAL NAME 'br.com.hrtech.prodedures'

but where i can put the commands like this

select * from teste

thanks