SAP 4.0B and "Exec Sql" in ABAP code
Posted on 2003-02-19
I attempting to use "EXEC SQL" in ABAP code on a SAP 4.0B system to access
Z tables at the
Oracle level and tables in a remote database connected using Oracle's
DBLINK. The problem I have is that when I do a select on either the
remote table or an SAP table (VBAP)it gives table not found. I assume
that I am connecting with an id different than the owner of the SAP
tables. Here is what I need to find out.
1. Are there special considerations to using the Exec Sql command?
2. Is there a owner for SAP tables that has to be defined in SQL
Is there a command that can establish connection as the owner id
so that subsequent DB activities don't need to qualify the owner.
3. Is anyone currently connecting to remote Oracle databases via
DBLINK? I am looking for feedback on how it works.