• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Subject: Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
  • From: Susanne Schneider <email@hidden>
  • Date: Wed, 12 Oct 2011 10:48:50 +0200

Hi Raymond,

I would gess this is more an Oracle than an WebObjects problem. Oracle can be very picky regarding user rights if you are dealing with separate user schemes for your EOModel. Maybe the function is defined by another user than that used by WebObjects to execute it?

You should check if the function owner is the user executing and, if they are not equal, if the necessary execute rights have been given. Furthermore if the function itself accesses tables from another user than owner or executer, than you have another problem to solve :-)

HTH,
Susanne

Am 11.10.2011 21:11, schrieb email@hidden:
Send Webobjects-dev mailing list submissions to
	email@hidden

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.apple.com/mailman/listinfo/webobjects-dev
or, via email, send a message with subject or body 'help' to
	email@hidden

You can reach the person managing the list at
	email@hidden

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Webobjects-dev digest..."


Today's Topics:

    1. Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a
       procedure or is indefined ) (Rafal Szczepanski)
    2. Compare old Server to the new mac mini Server (ISHIMOTO Ken)
    3. R?p?: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not
       a procedure or is indefined ) (Raymond NANEON)
    4. Re: Compare old Server to the new mac mini Server (Ramsey Gurley)
    5. Re: Compare old Server to the new mac mini Server (Tim Worman)
    6. Long time no write?and a problem with "Unbound classpath
       container" (Lon Varscsak)


----------------------------------------------------------------------

Message: 1
Date: Tue, 11 Oct 2011 11:13:58 +0200
From: Rafal Szczepanski<email@hidden>
Subject: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a
	procedure or is indefined )
To: email@hidden
Cc: email@hidden
Message-ID:<001e01cc87f6$1d55f960$5801ec20$@com>
Content-Type: text/plain; charset="us-ascii"

Hi Raymond,



I'm using Oracle functions and everything works smooth. Can you please
provide more details about your configuration?



Cheers,

Rafal





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.apple.com/pipermail/webobjects-dev/attachments/20111011/f8e7ed28/attachment.html

------------------------------

Message: 2
Date: Tue, 11 Oct 2011 11:19:47 +0200
From: ISHIMOTO Ken<email@hidden>
Subject: Compare old Server to the new mac mini Server
To: WebObjects List Mailing<email@hidden>
Cc: email@hidden
Message-ID:<email@hidden>
Content-Type: text/plain; charset="us-ascii"

Hi,

I have replaced one of my Server.



The old Server was a mac mini 2GB intel core duo with FrontBase 4 and Wonder-D2W Application.

The Average Transaction Time was : 0.626s (3 Instances used)

The new Server is a mac mini 8GB i7 with FrontBase 5 and the some Wonder-D2W Application.

The Average Transaction Time is : 0.036s (3 Instances used)


about 17 Time faster.



Thank you

Ken Ishimoto

--------------------------------------------------------
K's ROOM
--------------------------------------------------------
[E-Mail]<email@hidden>
[iChat:]<email@hidden>
[HP]          http://www.ksroom.com/
_____________________________________________________________________
This e-mail has not been scanned for viruses because it was written on an Mac,
and there are NO Viruses on an Apple Computer.
For further information visit http://www.apple.com




-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.apple.com/pipermail/webobjects-dev/attachments/20111011/aca64a75/attachment.html

------------------------------

Message: 3
Date: Tue, 11 Oct 2011 09:54:27 +0000 (GMT)
From: Raymond NANEON<email@hidden>
Subject: R?p?: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not
	a procedure or is indefined )
To: Rafal Szczepanski<email@hidden>
Cc: email@hidden
Message-ID:<email@hidden>
Content-Type: text/plain; charset="utf-8"

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
Â
Â
-------------- next part --------------
Skipped content of type multipart/related

------------------------------

Message: 4
Date: Tue, 11 Oct 2011 08:34:40 -0700
From: Ramsey Gurley<email@hidden>
Subject: Re: Compare old Server to the new mac mini Server
To: ISHIMOTO Ken<email@hidden>
Cc: WebObjects List Mailing<email@hidden>,
	email@hidden
Message-ID:<email@hidden>
Content-Type: text/plain; charset="us-ascii"

Skipped content of type multipart/alternative-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4233 bytes
Desc: not available
Url : http://lists.apple.com/pipermail/webobjects-dev/attachments/20111011/cdabf880/smime.bin

------------------------------

Message: 5
Date: Tue, 11 Oct 2011 11:35:28 -0700
From: Tim Worman<email@hidden>
Subject: Re: Compare old Server to the new mac mini Server
To: Ramsey Gurley<email@hidden>
Cc: WebObjects List Mailing<email@hidden>,
	email@hidden
Message-ID:<email@hidden>
Content-Type: text/plain; charset=us-ascii

Also, I'm wondering how many developers are running their apps and database on the same box? Obviously there's an opportunity to cut down on transaction time there but it also creates a single point of failure.

Tim Worman
UCLA GSE&IS

On Oct 11, 2011, at 8:34 AM, Ramsey Gurley wrote:

Hi Ken,

Impressive.  Out of curiosity, how did you take the measurements?  I've seen some built in metrics stuff in ERD2W, but I've never put it to use.  So naturally, I'm wondering if this sort of info is available at the flip of a switch, or is it something you had to implement yourself?

Ramsey

On Oct 11, 2011, at 2:19 AM, ISHIMOTO Ken wrote:

Hi,

I have replaced one of my Server.



The old Server was a mac mini 2GB intel core duo with FrontBase 4 and Wonder-D2W Application.

The Average Transaction Time was : 0.626s (3 Instances used)

The new Server is a mac mini 8GB i7 with FrontBase 5 and the some Wonder-D2W Application.

The Average Transaction Time is : 0.036s (3 Instances used)


about 17 Time faster.



Thank you

Ken Ishimoto

--------------------------------------------------------
K's ROOM
--------------------------------------------------------
[E-Mail]<email@hidden>
[iChat:]<email@hidden>
[HP]          http://www.ksroom.com/
_____________________________________________________________________
This e-mail has not been scanned for viruses because it was written on an Mac,
and there are NO Viruses on an Apple Computer.
For further information visit http://www.apple.com




_______________________________________________ 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

_______________________________________________ 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



------------------------------

Message: 6
Date: Tue, 11 Oct 2011 11:50:10 -0700
From: Lon Varscsak<email@hidden>
Subject: Long time no write?and a problem with "Unbound classpath
	container"
To: email@hidden
Message-ID:
	<email@hidden>
Content-Type: text/plain; charset=windows-1252

Hey, it's been 8 months since I've left my long-time company of
SmartHealth and have mostly been out of the WO space since.  I have
done a few projects for my old employer, so I'm not completely rusty.

However… :)

I went to start a new project today, and I'm getting "Unbound
classpath container" errors on all of the WO Frameworks.  My
~/Library/Application\ Support/WOLips/wolips.properties seems fine.
Although, I can't seem to find the WO Frameworks anywhere. :)  So I'm
assuming that is the issue.

The weird thing is, that the last project I did worked fine and
haven't "removed WO" from my machine.  I am running Lion (although I'm
positive I upgraded to this before my last project).

Any reason why the system would delete frameworks?  Maybe after a
software update?

-Lon


------------------------------

_______________________________________________
Webobjects-dev mailing list
email@hidden
http://lists.apple.com/mailman/listinfo/webobjects-dev

End of Webobjects-dev Digest, Vol 8, Issue 752
**********************************************

-- Susanne Schneider Coordinator secuTrial Development

iAS interActive Systems GmbH
Dieffenbachstraße 33 c, 10967 Berlin

fon    +49 30 22 50 50 - 498
fax    +49 30 22 50 50 - 451
mail   email@hidden
web    http://www.interActive-Systems.de

----------------------------------------------------
Geschäftsführer: Dr. Marko Reschke, Thomas Fritzsche
Sitz der Gesellschaft: Berlin
Amtsgericht Berlin Charlottenburg, HRB 106103B
----------------------------------------------------
_______________________________________________
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


  • Follow-Ups:
    • Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
      • From: Raymond NANEON <email@hidden>
  • Prev by Date: NSArchiver
  • Next by Date: OT: need directors for the WOCommunity Association
  • Previous by thread: Rép : Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
  • Next by thread: Rép : Re: Calling PL/SQL FUNCTION In WebObjects( FUNCTION is not a procedure or is indefined )
  • Index(es):
    • Date
    • Thread