Skip to Content
author's profile photo Former Member
Former Member

Invalid Column Index Error

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 07, 2008 at 10:28 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2008 at 01:09 PM

    -

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.