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

Reply via email to