开发者

Execute stored procedure with parameters

开发者 https://www.devze.com 2023-03-06 08:44 出处:网络
I have stored procedure and should get its result. From debugging of Java part: return getJdbcTemplate().call(newCallableStatementCreator(inParams), getDeclaredParameters开发者_C百科());

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号