Skip to Content
avatar image
Former Member

DBCON Setting to connect to Oracle

I am working on a scenario to connect to PI Java Schema Tables on Oracle DB.

Could someone shed some light on what should be the value in the CON ENV field?

DATABASE_NAME;JAVASCHEMA_NAME

or Just JAVASCHEMA_NAME

or

HOSTNAME:1521;JAVASCHEMA_NAME

Pls advice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 17, 2013 at 11:08 PM

    Hi Vicky,

    As far as I know, there are 2 Oracle schemas when you have a dual stack PI System:

    SAPSR3 = ABAP Oracle schema

    SAPSR3DB = Java Oracle schema

    The Oracle port depends on the listener... usually it's 1521.

    Hope it helps!

    Add comment
    10|10000 characters needed characters exceeded

    • Yes, that's correct. You can declare an internal table with ABAP code, for example:

      data:

      internaltable LIKE remotetable OCCURS 0 WITH HEADER LINE.

        SELECT *

        FROM remotetable

          INTO CORRESPONDING FIELDS OF TABLE internaltable

          WHERE etc...

      Hope this helps!