I want to create a user defined routine in C which would take Character string from Stored procedure. Can any one tell me how can I declare parameters both at C and stored procedure level?

I can create a procedure like this:

create procedure debug()
external name
language C
end procedure;

I want parameter declaration for "kcstest" as well as for debug.

Help would be apprecaited.