Hi Kevin, There are not a way to use function returned PIPELINE Table in WO ? It's not define in EOAttribute class which set the stored Procedure arguments? So I go to use rawRowSql to execute my function in WO.
Thanks Raymond NANEON [email protected] Le 17 oct. 2011 à 22:21, Kevin Ren a écrit : > Hi, Raymond, > > 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. > > ================================================ > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/naneon.raymond%40neuf.fr > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
