DBIF_RSQL_SQL_ERROR

Former Member — Fri, 29 May 2009 11:56:13 GMT

Hi experts,

I have a query which gives me a dump: DBIF_RSQL_SQL_ERROR.

Database error text........: "ORA-00904: "MOAL1": invalid identifier"

The problem is with a selection.

It looks like as:

select f1 f2 f3 f4... fn

into corresponding fields of itab

from dbtab

where cond1

...

Te problem is with this MOAL1 field. When I use select * it does not give me a dump.

But when I try to select this field from the table it gives me an error.

The table which I use in the selection is in interface table which content cannot see through se16, only if I apply a query.

The type of the field is INT4.

Do you have any idea about the problem?

Re: DBIF_RSQL_SQL_ERROR

Former Member — Mon, 01 Jun 2009 18:38:20 GMT

I know this is old...however since there was no response and I ran into this note which I think is relevant here I am posting the OSS note here.

Please see Note 731946 - DBIF_RSQL_SQL_ERROR when inserting a type P variable in DB

Fred