Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Mixing Native Sql with "Open Sql" from SAP.

Petri BRNov 23 2010 — edited Nov 23 2010
Hello, I have a doubt, and I really dont know if there is someone that can help me.

But I'll try to explain.

I have a select on an SAP PROGRAM (SAP OPEN SQL), that gives me a range of rows, that I want to use by parameters in a native sql on a select that goes outside the SAP enviroment by a dblink.

I can do that making a loop and executing the sql, that goes outside the SAP enviroment by a dblink, the number of registers that the query on SAP returns.
What I want to know is if there's a way to automate that, and pass the range of rows to the NATIVE ORACLE QUERY SQL.


OBS: by the way... Open SQL consists of a set of ABAP statements that perform operations on the central database in the R/3 System. The results of the operations and any error messages are independent of the database system in use. Open SQL thus provides a uniform syntax and semantics for all of the database systems supported by SAP. ABAP programs that only use Open SQL statements will work in any R/3 System, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP Dictionary.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2010
Added on Nov 23 2010
3 comments
1,053 views