Re: Urgent: storedProcedure question

Francis Labrie <[email protected]> Thu, 12 Aug 2004 21:03:50 -0400
Newsgroups gmane.comp.web.webobjects.eof
Message-ID <[email protected]>
Hi,


Oliver Runge wrote:
> I'm currently trying to use a storedProcedure (or rather a function) 
> to insert a new row into a database. I got two parameters for my call, 
> one being the name of the object to insert and the other one being the 
> content (large text to be stored in a blob).
>
> I added a stored procedure to my model and it looks something like this
>
> {
>     arguments = (
> [...]
>     );
>     externalName = WER$FU_CREATEENTRY;
>     name = wer$fu_createEntry;
> }
>
>
> So now when I call the procedure the I get a ClassCastException an I 
> don't seem to be able to figure out why. Can anyone help me out here?


DBMS type (Oracle I think) and stack trace would be necessary to make 
an accurate diagnostic, but I suspect a datatype mismatch with your 
stored procedure or bad parameters ordering.


--
Francis Labrie
Saint-Bruno-de-Montarville, Quebec, Canada