Hi Ute,
Try changing the sequence in the store procedure to match the
sequence created by EOModeler :-D....
If you want the sequence to be corrected in EOModeler, try to set the
column attribute for each input parameter as 001, 002 etc.. and your
Out parameter to 000.
This doesn't work every-time though, I am using a oracle DB and with
the latest ojdbc drivers, setting column as 001, 002 doesn't work!
-- In which case changing the sequence in the DB would be a better
idea.
Hope this helps!
Thx
Ashwin
On Jan 2, 2007, at 2:09 AM, Ute Hoffmann wrote:
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/aprabhu%
40apple.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
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]
