Invalid Column Index Error

[Former Member]

Hi all,

I am trying to create a new report using

1. Crystal Report XI

2. Oracle 9i

3. A stored Procedure

4. JDBC connection.

But i could not do it.

Invalid Column index error is coming.

Can anyone help.

Thanks

Saravanakumar.

[Former Member]

-

[Former Member]

I know this is an old thread but I too am getting a column index error accessing an Oracle 10g database stored procedure using Crystal Reports XI, using the New Report wizard to select the stored procedure. It prompts me for the sp parameters; I select "set to null" and click OK and get

Failed to retrieve data from the database. Details:  SQL Exception: [SQL State:] null [Error message:] Invalid Column Index [Database vendor code 17003]

I can run the procedure and get data just fine with no errors using PL/SQL.

[Former Member]

Hi

Please give following information;

1. Exactly at what stage is this error coming

2. Could you give the exact and complete error message

There are some known issues and possible work arounds but would need above details.

Thanks