Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Stored Procedure Question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Stored Procedure Question

Subject: Stored Procedure Question
From: Ute Hoffmann <email@hidden>
Date: Tue, 2 Jan 2007 11:09:30 +0100

Hallo, I have a projekt where I need to call a MS SQL Server stroed Procedure from WebObjects.

I have created the stored Procedure in EOModeller and filled the two needed parameters via Java Code when calling the porcedure.

The parameters values seem to be transmitted correctliy. But I get a procedure not found exception on calling the procedure.

This error lists the paramaters for the procedure in the wrong sequence. The definition of the procedure I got from the database admin states: prozedureName (projektnr, monat) while the error states prozedureName (?,?) with monat(1,wert), projektnr(2,wert). (error diction maybe a little different, written from memory)

Is it possible that the wrong sequence of the parameters triggers the error and if yes, how can I change the sequence? I have not found a way to do so in eomodeller as he sorts the parameters after the name alphabetically? Yes, I do put the values into the value dictionary starting with projektnr and following with monat in the code where I call the procedure.

Or have I to look for a different reason why the procedure is not found?

Thanks a lot,

Ute

_______________________________________________
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:

Re: Stored Procedure Question
From: Ashwin Prabhu <email@hidden>


Prev by Date:
WebServerResources & subfolders

Next by Date:
Which PostgreSQL JDBC driver are you using?

Previous by thread:
WebServerResources & subfolders

Next by thread:
Re: Stored Procedure Question

Index(es):

Date
Thread