Rép : Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
Rép : Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
- Subject: Rép : Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
- From: Raymond NANEON <email@hidden>
- Date: Tue, 11 Oct 2011 09:54:27 +0000 (GMT)
Hi Rafal,
I use Eclipse JEE Indigo , WOLips 3.7 and Wonder latest version. My function return a table.
i.e :
PL/SQL
TYPE TAB_ETUD IS TABLE OF OBJ_ETU;
FUNCTION PROFIL_ETUDIANT(
etuID in NUMBER
) return TAB_ETUD PIPELINED;
here my java method :
public boolean executeProcedure(NSMutableDictionary procResult, String procedure, NSDictionary dicoData){
boolean noError = true;
startsWorking();
EOAdaptorChannel adaptorChannel = adaptorChannel();
this.executedProcResult.removeAllObjects();
try {
EOStoredProcedure myProcedure = EOModelGroup.defaultGroup().storedProcedureNamed(procedure);
adaptorChannel.executeStoredProcedure(myProcedure, dicoData);
this.executedProcResult.addEntriesFromDictionary(adaptorChannel.returnValuesForLastStoredProcedureInvocation());
} catch (Throwable e) {
e.printStackTrace();
noError = false;
String exMessage = LoginLog.getMessageForException(e);
if (exMessage == null) exMessage = "Le message d'erreur inconnu";
this.executedProcResult.setObjectForKey(exMessage, "ERREUR");
}
if ((procResult != null) && (procResult != this.executedProcResult))
procResult.addEntriesFromDictionary(this.executedProcResult);
stopsWorking();
return noError;
}
So you think the error message is about the WOLips version or wonder version? The returned data is unsupported?
Thaks
Envoyé depuis iCloud
Le 11 oct 2011 à 02:13, Rafal Szczepanski <email@hidden> a écrit :
Hi Raymond,
I’m using Oracle functions and everything works smooth. Can you please provide more details about your configuration?
Cheers,
Rafal
_______________________________________________
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