Hi again, I thought I'd post a hail mary question before calling it a night. One of the requirements for this project I'm working on is they want to use stored procedures for basically all database queries. I figured iBATIS made the most sense because I'm going to be calling custom SQL for every call. This is my first time using iBATIS. Everything was going pretty well (it really is as easy and as cool as they say;) until I tried using "EXECUTE" statements rather than "INSERT". I'm getting an exception from the database driver about a syntax error when it gets to a string with more than one word. So I suspected quotes are not being added around the parameters, but when I add them manually I get a different SQL error "Invalid parameter at index 1."
I'm going to dig up more documentation on iBATIS tomorrow, but I was hoping that someone here might have had a similar problem and might be able to save me some headache. Thanks for any help, Nathan