Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )
Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )
- Subject: Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is undefined )
- From: Kevin Ren <email@hidden>
- Date: Tue, 18 Oct 2011 09:21:01 +1300
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