Returning Values Procedures?

[amitstora]

Hi all!

Query:

1.Could both Procedures return values like Functions in Oracle!

Thanks&REgards,

Amit.

[nealh]

They can have output parameters:

create or replace procedure get_x(p_out out varchar2) is
begin
p_out := 'X';
end;