Hello Sir,
I created an interactive report based on a SQL-Query, I then wanted to insert another value from the table into this SQL query.
However, when I tried to do this I got the following error: ORA-00904: "D". "SPID": invalid ID.
I have already googled it and it says it could be because the wrong column name was entered or it would be solved if an alias was used, which I have already tried but still get the same error.
I have also run the SQL query in the SQL command and it shows me the correct result.
So what could be the cause of the error?
Vinish Kapoor
Will you explain the following point?
"I then wanted to insert another value from the table into this SQL query"
What exactly you are trying to do?
Ana
Sure, I can explain it.
This is the SQL query on which the interactive report is based:
With this query, the report is displayed normally.
However, when I try to retrieve another column from the Form table for the report, I get the error described above.
Shashank
@Enlightened Ritish Rana
In the error instead of F.SPID it says D.SPID, what might be the reason?
Can you please check the alias used and confirm?
Ana
Hello yes I have also seen that but in the query I use f.SPID