Hi Raymond,
In general when dealing with functions from EOF you must, in addition to the
arguments, define the return type in your eomodel.
You define the return type by adding an attribute with the column name 0
(zero). Off the top of my head I believe the attribute name and direction have
Hi,I declare External Type ARRAY, OBJECT and so one and stuck on the same error :com.webobjects.jdbcadaptor.JDBCAdaptorException : Unable to determine JDBC type for attribute '020_returnValue' when preparing output parameter for stored procedure.I try all Oracle externalsTypes which are familiar
So how to declare column of the array as external Type?Envoyé depuis iCloudLe 17 oct 2011 à 03:33, Paul Yu p...@mac.com a écrit:I would think you would need to somehow define every attribute of the returned attribute(s) from this procedure.I would think that EOF knows that an Array will be coming
Hi Paul,See my attached pictures in others posts. You will see I define the stored procedure and his arguments. My problem is on external type. I know it's a table or array. But in WO, the EOAttribute don't know it. The EOAttribute use basic type of Oracle and not complexes types like object,
Here is the columns of return array (an pl/sql structure) :create or replaceTYPE OBJ_ETUDIANT AS OBJECT(/* TODO enter attribute and method declarations here */ID_ETU NUMBER(7),CIV_NOM VARCHAR2(77),NOM VARCHAR2(40),PRENOM VARCHAR2(30),DATE_NAIS VARCHAR2(10),COM_NAIS VARCHAR2(93),EMAIL
Hi Raymond,
alas I have not much experience with using PL/SQL function through an
eomodel. We are using most of our PL/SQL functions through JDBC directly.
But the direction seems to be a very reasonable assumption. Oracle at
least distinguishes between procedures (without return value) and
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
