topic Re: Erro ORA-903 when executing native SQL in Application Development and Automation Discussions

Erro ORA-903 when executing native SQL

Former Member — Fri, 22 Dec 2006 13:09:12 GMT

Hello,

I am having the error "ORA-00903: invalid table name"

when executing the following sql

EXEC SQL.

select a.matl_type

from sapsr3./bi0/pmaterial a

into :l_mattyp

where a.material = :l_material.

ENDEXEC.

this is in a BW machine.

i checked in db02 for the owner of the table and it is sapsr3.

What might be problem?

Thanks for any help.

Re: Erro ORA-903 when executing native SQL

Former Member — Fri, 22 Dec 2006 15:06:15 GMT

Hi jose,

I found this information while searching for ur question.

In the course of a local currency changeover to the Euro in Oracle, phase CONVERSION terminates with a red traffic light, namely at a table /xxxxx/yyyyy that belongs to a namespace /xxxxx/. From the long text of the log message or from the dump analysis (Transaction ST22) it is clear that SQL error 903 'invalid table name' occurred when executing the following EXEC SQL statement:

SELECT /*+ FULL ( /xxxxx/yyyyy ) */ COUNT ( * ) FROM /xxxxx/yyyyy

WHERE MANDT = ?

Additional key words

EMU, EEMU, EMU, euro conversion, ORA-00903, EXEC SQL, SQL error 903, EWUGENEW

<b>Cause and prerequisites</b>

In report EWUGENEW (generating program), the EXEC SQL statement listed above is assembled for Oracle. This statement causes a short dump for a table /xxxxx/yyyyy that is attached to a namespace /xxxxx/.

<b>Solution</b>

You have two options:

1. You apply in your system the relevant Hot Package specified below. For Add-On Euro Conversion 3.0F (EURO-CNV), the correction is contained in CRT91.

2. You implement the attached advance correction of one line in report EWUGENEW.

Create a new changeover package in both cases and carry out the changeover again with this package.

Hope this will b helpful for u.

Regards....

Arun.

Re: Erro ORA-903 when executing native SQL

Former Member — Fri, 22 Dec 2006 15:15:57 GMT

hi jose,

since u have mentioned it as a bw machine. The problem might be different from my previous post. It is one of the bug which is common in BW machine with oracle database. So please consult with your DBA person.

Regards....

Arun.

Re: Erro ORA-903 when executing native SQL

Former Member — Fri, 22 Dec 2006 15:42:35 GMT

I've been doing some testes and realized the problem is the name of the table and fields.

It does not recognize the names user in BW (/bic/, /bi0/).

Are these tables stores with another name in Oracle?