Execute stored procedure with parameters

I have stored procedure and should get its result.

From debugging of Java part:

return getJdbcTemplate().call(newCallableStatementCreator(inParams), getDeclaredParameters开发者_C百科());

I've discovered procedure's name and its parameters.

How can I execute this procedure with these parameters from e.g. Oracle Sql Developer.

Thank you.

In SQL Developer you can run a stored procedure from the SQL Worksheet window like this:

exec myproc (myparam1 => 'a', myparam2 => 2);

using named parameters, or using position parameters:

exec myproc ('a', 2);

Press the green "Run Statement" button in the toolbar to run the command.