Execute stored procedure with parameters

parameters plsql execute procedure
sergionni picture sergionni · May 17, 2011 · Viewed 96.5k times · Source

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.

Answer

Tony Andrews picture Tony Andrews · May 18, 2011

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.

Related questions

Default Values to Stored Procedure in Oracle

I have a stored procedure as follows. CREATE OR REPLACE PROCEDURE TEST( X IN VARCHAR2 DEFAULT 'P', Y IN NUMBER DEFAULT 1) AS BEGIN DBMS_OUTPUT.PUT_LINE('X'|| X||'--'||'Y'||Y); END; When I execute the above procedure EXEC …

Read More
How are parameters sent in an HTTP POST request?

In an HTTP GET request, parameters are sent as a query string: http://example.com/page?parameter=value&also;=another In an HTTP POST request, the parameters are not sent along with the URI. Where are the values? In …

Read More
What are the -Xms and -Xmx parameters when starting JVM?

Please explain the use of Xms and Xmx parameters in JVMs. What are the default values for them?

Read More