Execute stored procedure with parameters

Question

I have stored procedure and should get its result.

From debugging of Java part:

return getJdbcTemplate().call(newCallableStatementCreator(inParams), getDeclaredParameters());

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.

Please post the procedure's name and parameters as you have discovered them. You will need them to run the procedure from SQL Developer. — Thomas Jones-Low
– Thomas Jones-Low, Commented May 17, 2011 at 23:58

Tony Andrews · Accepted Answer · 2011-05-18 09:09:49Z

24

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.

answered May 18, 2011 at 9:09

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thanks! It helped me in great deal. Thanks once again.

what about out parameter ?