Parametrized stored procedue on SQL prompt

[gyanendar]

How can i run parametrized input(2) stored procedure with 3 results fields on SQL prompt?

Please help.

[rski]

What do you mean 'SQL prompt'?
Can you give an example how do you want to call this procedure?

[amitpatel66]

Something like this:
[code=oracle]

-- In case procedures output variables return type is NUMBER

SQL>VAR my_out1 NUMBER
SQL>VAR my_out2 NUMBER
SQL>VAR my_out3 NUMBER
SQL> EXEC my_proc(10,20,: my_out1,:my_out 2,:my_out3);
SQL> PRINT :my_out1 :my_out2 :my_out3
[/code]