java.sql.SQLException: Missing IN or OUT parameter at index:: 1 in SAP xMII

[Former Member]

Hi Experts,

I am trying a very basic job of database in SAP xMII,getting the following error while creating a trigger

"java.sql.SQLException: Missing IN or OUT parameter at index:: 1"

I have a table with ID as Primary key in Oracle and created a sequence for auto increment the column ID in the table.

I created a trigger for the column so that it will generate automatically while doing inserts into the table..

The data into my table will be loaded from another table..

My sample trigger syntax:

CREATE OR REPLACE TRIGGER  trg_trigger

BEFORE INSERT ON  TableName

REFERENCING OLD AS OLD NEW AS NEW

FOR EACH ROW

BEGIN

select seq_PostingData.nextval INTO :NEW.PostingId from dual;

END;

I guess its an java error but I tried with no luck,

please help,its urgent

Thanks & Regards,

Mahaboob

[agentry_src]

Hi Mahaboob,

For Oracle, you need to be doing FixedQueryWithOutput as the query type.  Please confirm that first.

Have you also checked your syntax in Toad or other query workbench outside of MII?

One last thought, please verify that the Oracle driver in use is appropriate for the version of the database.

Regards, Mike