I have created a stored procedure that passing an Employee ID, will do the needed work in the stored procedure to return a result set of classes taken information along with other items not shown in example. I have completed, and tested in IB_Manager so I know it works.

In IB_Cursor I tried doing a SELECT * FROM EMP_CLASS_LIST to invoke the procedure, but I do not understand, and need some examples how to set up the parameter passing.


Header from the Remote Procedure:
CREATE PROCEDURE EMP_CLASS_LIST (
IN_EMPLOYEE_ID VARCHAR (10))
RETURNS (
OUT_CLASS_ID VARCHAR (10),
OUT_SECTION VARCHAR (6),
OUT_CLASS_DESC VARCHAR (60),
OUT_GRADE_LEVEL VARCHAR (2),

--
Sent by: Christopher Hart, cjh@... on 1/8/2004 5:41:11 PM
--------------------------------------------------------------------------------------------------

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient you
are hereby notified that you have received this message in error and that
any review, dissemination, distribution or copying of this message
including any attachments is strictly prohibited.  If you received this in
error, please contact the sender and delete the material from any computer.

Profile Technology Group, LLC