how i i execute a stored procedure from sql*plus which gives a r

[2314]

how i i execute a stored procedure from sql*plus which gives a return value

 

[lewisp]

Is it a procedure or a function? If a function, you could try

set serveroutput on

declare
  x varchar2(255); -- or whatever your return type is
begin
  x := your_function;
  dbms_output.put_line(x);
END;
/

If the code is a procedure with an OUT parameter, change the first line of code to

[tt]your_function(x);[/tt]


...although I'm sure theres a more elegant solution.

 

[sem]

Or

VAR result VARCHAR2(4000)
EXEC :result := function(parameters)
PRINT result

Or if your function doesn't modify database just:

  select function(parameters) from dual;

BTW in Oracle and many other languages procedure returning a value is called function.

Regards, Dima

http://seminihin.narod.ru