storedProceedure on postgreqsl ??
storedProceedure on postgreqsl ??
- Subject: storedProceedure on postgreqsl ??
- From: Theodore Petrosky <email@hidden>
- Date: Thu, 12 Aug 2010 10:19:17 -0700 (PDT)
I have a stored proceedure in my postgresql db 8.4.4
CREATE OR REPLACE FUNCTION approvetime(jobid int) RETURNS void AS $$
DECLARE
jobid int;
BEGIN
UPDATE t_e_time SET c_is_accepted = TRUE WHERE c_job_id = jobid;
END;
$$ LANGUAGE plpgsql;
I created the stored proceedure AcceptETimeForJob with the External Name as the name of the function (approvetime) in EOModeler with an argument of jobid. At least this is what I thought I should do.
I created a NSDictionary
keyDictionary.setObjectForKey(Integer.parseInt(jobListArray.objectAtIndex(i).primaryKey()), "jobid");
then I issued (at least I thought)
EOUtilities.rawRowsForStoredProcedureNamed(theProject().editingContext(), "AcceptETimeForJob", keyDictionary);
the only thing I see in the pg logs is:
asacksadmin 127.0.0.1(65462)LOG: 00000: execute <unnamed>: select * from approvetime ($1) as result
asacksadmin 127.0.0.1(65462)DETAIL: parameters: $1 = '10072'
what am I doing wrong? I have been trying every permutation of this and that and my head is starting to hurt.
Ted
_______________________________________________
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