Topic
2 replies Latest Post - ‏2012-04-04T17:12:29Z by DGawron
jvarga
jvarga
5 Posts
ACCEPTED ANSWER

Pinned topic Missing IN or OUT parameter at index

‏2012-04-02T16:49:18Z |
I am trying to do a simple Insert into an Oracle data table, using a SQL Call. The Statement is:

insert into PORTAL.PORTAL_PROXY (proxy_type, employee_no, proxy_employee_no, create_user_id, modify_user_id)
values (trim(?),trim(?),trim(?),trim(?),trim(?))

I can execute the statement in Toad (by replacing the ?'s with "&" params) just fine. And once in a great while it works when I try to run it in a portlet, but most of the time it fails with the attached error (in a separate text file for the sake of an easier to read post), the crux of which is:

4/2/12 11:32:39:789 CDT 0000008b SystemOut O -- TIME: 2012-04-02 11:32:39,789 --
Category: bowstreet.system.server.logging.event.criterion.abnormal
Priority: ERROR
Msg: Component: MODEL
Error in method InsertProxyUserInvokeBase. Missing IN or OUT parameter at index:: 6

Now, as you can see from the INSERT statement above, there are only 5 parameters and they are all populated, as I get this when I turn on Log SQL Statements in the SQL Call builder:

SQL Builder: InsertProxyUserStatement
SQL Statement: http://insert into PORTAL.PORTAL_PROXY (proxy_type, employee_no, proxy_employee_no, create_user_id, modify_user_id) values (trim(?),trim(?),trim(?),trim(?),trim(?))
IN Parameter 1: PMMHJOBCAT
IN Parameter 2: 0N9876
IN Parameter 3: 0H1234
IN Parameter 4: 0X1234
IN Parameter 5: 0Z1234

There are a lot of threads on the Oracle forums about this error but the ones with solutions all seem to be for JDeveloper, so none of them were really any help.

Any ideas?
Updated on 2012-04-04T17:12:29Z at 2012-04-04T17:12:29Z by DGawron
  • jvarga
    jvarga
    5 Posts
    ACCEPTED ANSWER

    Re: Missing IN or OUT parameter at index

    ‏2012-04-02T16:51:45Z  in response to jvarga
    OK Forum software did some weird formatting there (there should be no URLs or strikethrough) but hopefully you get the gist of it.
  • DGawron
    DGawron
    251 Posts
    ACCEPTED ANSWER

    Re: Missing IN or OUT parameter at index

    ‏2012-04-04T17:12:29Z  in response to jvarga
    There is a bug in the Oracle driver; I've seen this scenario several times before. See if you can locate a more recent version of the driver.