comment on

Your error message doesn't seem to agree with what I see. Let me give you a few hints, though.

Your code fragment, as you posted it, compiles fine. Therefore the error should not be in these lines.
From a SQL point of view, your query is wrong in several places:

You are declaring 8 fields but you are passing only 5 values.
You are passing unquoted values "I00" and "I99", which will fail once your program manages to send your query to the DBMS. Perhaps that you are using "I" instead of "1"?

You should be better off using placeholders. See DBI Recipes for examples.
Your query is using multiple VALUES clauses. AFAIK, only MySQL and IBM DB2 support this syntax. If you are using another DBMS, check its docs to be sure you can do it.
As for your specific problem, since the error is not visible in this example, perhaps reading Before asking a database related question ... could give you some ideas.

 _  _ _  _  
(_|| | |(_|><
 _|

In reply to Re: DBI error by gmax
in thread DBI error by Win

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.