urgent! pls help!call function in a procedure

From: MEL <n2231409_at_droid.fit.qut.edu.au>
Date: Sun, 5 Sep 1999 15:36:32 +1000
Message-ID: <Pine.GSO.4.10.9909051528180.5821-100000@droid.fit.qut.edu.au>

hello
pls help me how to write this:
how to call a function which return no of children in a department inside a procedure, the function takes an employee's ssn browse through the
dependent table, and return the total number of children of this employee
has,
call this function inside a procedure.

the procedure will take the dept no as an input parameter and print out a list of employees in that dept, their addresses, and the number of children each employee has. execute the procedure for every dept in the database. the output for one dept should look like this: department: xxxx
supervisor: yyyyy

employee          address     no of children
aaaa              bbbbb        x

 what i think is:
when the function return the no of children, how to link with other fields to print out as the requirement? what to do with the return number from the function? what do i do inside the procedure?

pls help! thks a million Received on Sun Sep 05 1999 - 00:36:32 CDT