See Call Stored Procedure - MySQL that Walter has just contributed to the community. It should be the same for Oracle too.

Thanks ! That worked, after some refinements:

• to find out the right JDBC connect string for my DB (a local 11.2 Express Edition):

jdbc:oracle:thin:@localhost:1521/XE

• to change the procedure call syntax, in the database tool plugin configuration, to:

begin jogetaddrecord('Test 001');end;

I have got a couple more related questions now:

1) how can I refer to a form's field in the stored procedure call. E.g. I want to pass as input parameter the content of a form field, not a constant string.

2) how is the transaction handled in this case? Seems like a commit happened anyway, even though not explicitly issued in my procedure.

wrt to question 1 - I found how to, by using a hash variable. e.g. 

begin jogetaddrecord('#form.test.comment#');end;

question # 3

how are return values from select queries, or pl/sql functions, typically handled?

thanks

Fabio