on 12-18-2009 9:15 AM
Hi Experts,
we have created a table in the Oracle Database DBTAB by logging into oracle directly.
Now I need to insert records in this table from ABAP report by using EXEC- ENDEXEC block.
But I am getting a dump saying-- "Table doesnot exists in the Database" alothough table has been created.
EXEC SQL.
INSERT INTO DBTAB@ifsap
(A,
B,
C,
D)
VALUES
(:a,
:b,
:c,
:d)
ENDEXEC.
I have tried table name as DBTAB as well as DBTAB@ifsapc also but the same error is coming.
Could you suggest?
Thanks
Depesh
Hello Depesh,
please let's start at the beginning again.
> we have created a table in the Oracle Database DBTAB by logging into oracle directly
In which schema was the table DBTAB created?
Was this table created in the same oracle database on which the SAP system is running?
> I have tried table name as DBTAB as well as DBTAB@ifsapc also but the same error is coming.
Again .. in which schema was the table created?
If you don't know the answers of the questions from above .. please run the following query and post the output:
shell> sqlplus / as sysdba
SQL> SELECT OWNER, TABLESPACE_NAME FROM DBA_TABLES WHERE TABLE_NAME = 'DBTAB';
Regards
Stefan
P.S.: By the way .. if you purchase the oracle license by SAP ... please keep sapnote #581312 (Point 3 and solution) in your mind.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks all for your response.
I can now access DBTAB.
1) Yes, Table is created in the same oracle version on which SAP is running and both are in the same schema
2) There is no need to create DBTAB in TA SE11 i.e if it is created in Oracle directly on which SAP is running, I can access it using Native SQL.
@ifsap or @ifsapc is used to maintain consitency if the devlopement and quality server having different backend DB version.
Issue: Problem was that the authorization was not extended to my ID to access this table.
Thanks
Depesh
Hi Depesh,
if you create a table via native SQL, this table is not known by SAP DDIC.
Try if you can see this table via TA SE11(For sure the table ist not visible).
You have to create the Table by SAP Code, not native SQL.
regards
Uwe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
yes, I'm sure.
You have only acces on a Database Table via ABAP if this table is known by SAP DDIC.
Try TA SE11.
Nevertheless, if you wan't update Objects which are created by native SQL,
use also native SQL for dml.
Otherwise create the Object with ABAP or SAP Transactions.
have someone additional opinons?
regards
Uwe
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.