Urgent: storedProcedure question
Oliver Runge <[email protected]> Thu, 12 Aug 2004 22:08:32 +0200
| Newsgroups | gmane.comp.web.webobjects.eof |
|---|---|
| Message-ID | <[email protected]> |
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 = (
{
allowsNull = Y;
columnName = i_content;
externalType = BLOB;
name = content;
parameterDirection = 1;
valueClassName = NSData;
},
{
allowsNull = N;
columnName = i_name;
externalType = VARCHAR2;
name = name;
parameterDirection = 1;
width = 255;
valueClassName = NSString;
valueType = S;
},
{
allowsNull = Y;
columnName = 000;
externalType = NUMBER;
name = returnValue;
parameterDirection = 2;
precision = 10;
valueClassName = NSNumber;
valueType = l;
}
);
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?
Regards
Oliver