Apple

Raymond NANEON

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@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden

References:

>Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined ) (From: Raymond NANEON <email@hidden>)

>Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined ) (From: Kevin Ren <email@hidden>)

Prev by Date: Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

Next by Date: Q about locked ec (again)

Previous by thread: Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )

Next by thread: CLOSE_WAIT when database is offline

Index(es):

Date

Thread