Apple

may be this is your typo. Your table type is OBJ_ETU instead of OBJ_ETUDIANT .

create or replace TYPE OBJ_ETUDIANT AS OBJECT

TYPE TAB_ETUD IS TABLE OF OBJ_ETU;

FUNCTION PROFIL_ETUDIANT(

etuID in NUMBER

) return TAB_ETUD PIPELINED;

1, if i declare OBJECT and TABLE type, i use return/out parameter type as CURSOR.

2, if I declare RECORD and TABLE type, i use return type as PIPELINED table.

All these are in JEE application from JDBC, not WO app.

goo dluck,

Kevin

========================================================

This e-mail message and attachments do not necessarily reflect the views of
the New Zealand Ministry of Justice and may contain
information that is confidential and may be subject to legal privilege. If you
are not the intended recipient, you are hereby notified that you must not use,
disseminate, distribute or copy this e-mail message or its attachments. If you
received this message in error, please notify the Ministry of Justice
by telephone (call collect: 00-64-4-918-8800) or return the
original message to us by e-mail, and destroy any copies.
Thank you.

================================================