Rép : Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )

Raymond NANEON Tue, 11 Oct 2011 02:54:46 -0700

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 protected]> 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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com


This email sent to [email protected]

Rép : Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )

Reply via email to