hi,

any one know how to retrieve the metadata showing the input parameter
fields and output parameter fields
that belongs to one store procedure ?

e.g.

I have procedure:

set term ; !!
create procedure CS_PM_GET_CASE_LIST(PROJECT_ID integer)
returns
(CL_ID integer, CL_CODE varchar(32), CL_TITLE varchar(50),
CL_SUBMIT_BY varchar(32))
as
declare variable submit_id integer;
declare variable assignee_id integer;
declare variable category_id integer;
declare variable case_type_id integer;
begin
for select CPMCS_ID, CPMCS_CODE, CPMCS_TITLE, CPMCS_CREATED_BY,
from CS_PM_CASE where CPMCS_CPMP_ID = :PROJECT_ID
into :CL_ID, :CL_CODE, :CL_TITLE, :submit_id
do
begin
select CSU_CODE FROM CS_SYS_USER
where CSU_ID = :submit_id into :CL_SUBMIT_BY;
SUSPEND;
end
end!!
set term ; !!

anyway i could show info e.g.

Field Parameter Type
_____ ______________
PROJECT_ID Input
CL_ID Output
CL_CODE Output
CL_TITLE Output
CL_SUBMIT_BY Output

and

Field Field Type
_____ ______________
PROJECT_ID Integer
CL_ID Integer
CL_CODE varchar
CL_TITLE varchar
CL_SUBMIT_BY varchar


??

TIA