Re: Stored Procedure Question

Tue, 03 Jan 2006 21:44:36 -0800

make sure that in your eomodel that there are no () after the procedure name or external name. Only if there are NO arguments should you put () after the external name in the EOModel.

--
Nathan


On Jan 2, 2006, at 6:36 PM, Jonathan Miller wrote:

Hi-

I'm trying to call a stored procedure in my database using the EOUtilities.executeStoredProcedure method but it seems that when EO creates the SQL it creates extraneous {} around the SQL call.

I'm using WO 5.3, Openbase 9.0

Here is the Java code

NSDictionary dict = new NSDictionary(aPerson.valueForKey("principalid"), new String("principalid"));
try {
NSDictionary results = EOUtilities.executeStoredProcedureNamed(ec, "setPrimaryToFalse", dict);
} catch(com.webobjects.jdbcadaptor.JDBCAdaptorException e) {
NSLog.out.appendln("Procedure Failed");
}

Here is the SQL code

//THREAD_0x424e20:157932975.355600:2006-01-02 12:16:15 -1000
{ call SET_PRIMARY_TO_FALSE ('Jon')}   
go

Does anybody know if I'm doing something wrong?

Thanks in advance

Jon


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

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]

Reply via email to