Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Java.sql.SQLException: Invalid column index

Accepted answer
3684
Views
14
Comments
2»

Answers

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Donald.

    No worries. It was an interesting learning. Never thought about using Function on WITH clause in BIP. 

    An old workmate once told me while running SQL on different tools.

    "We have two pieces of software talking with the database. They make not talk the same way all the time"

    Cheers

    Fernando.

  • Donald
    Donald Rank 4 - Community Specialist

    Good one, I will remember that, "We have two pieces of software...." smiley

    Regards,

    Donald

  • User_6NK6Y
    User_6NK6Y Rank 1 - Community Starter

    hello

    i am getting an error when running procedure call dm report

    the error is

    java.sql.SQLException: Invalid column index

    any idea?

    thanks