on 04-23-2020 6:06 PM
I am using SAP PO 7.5 . I need to use JDBC look up for Oracle database. I am not getting option to specify schema name. Hence I am not able to fetch table details that I need to use in mapping. Would you please help me here.
This is the connection string I am using in my adapter.
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.208.156.45)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=HAYONEQA)))
I can see following list of tables.
AUDIT_ACTIONS DUAL NTV2_XML_DATA OGIS_GEOMETRY_COLUMNS OGIS_SPATIAL_REFERENCE_SYSTEMS OL$ OL$HINTS OL$NODES SAM_SPARSITY_ADVICE SDO_COORD_AXES SDO_COORD_AXIS_NAMES SDO_COORD_OP_METHODS SDO_COORD_OP_PARAM_USE SDO_COORD_OP_PARAM_VALS SDO_COORD_OP_PARAMS SDO_COORD_OP_PATHS SDO_COORD_OPS SDO_COORD_REF_SYS SDO_COORD_SYS SDO_DATUMS SDO_DATUMS_OLD_SNAPSHOT SDO_ELLIPSOIDS SDO_ELLIPSOIDS_OLD_SNAPSHOT SDO_INDEX_HISTOGRAM_TABLE SDO_PREFERRED_OPS_SYSTEM SDO_PREFERRED_OPS_USER SDO_PRIME_MERIDIANS SDO_PROJECTIONS_OLD_SNAPSHOT SDO_SRIDS_BY_URN SDO_SRIDS_BY_URN_PATTERN SDO_ST_TOLERANCE SDO_TOPO_DATA$ SDO_TXN_IDX_EXP_UPD_RGN SDO_TXN_JOURNAL SDO_UNITS_OF_MEASURE SDO_XML_SCHEMAS STMT_AUDIT_OPTION_MAP SYSTEM_PRIVILEGE_MAP TABLE_PRIVILEGE_MAP USER_PRIVILEGE_MAP XS$VALIDATION_TABLE
Hi Raghuram,
Is the issue resolved? if yes, please let us know the solution as i am facing the same issue.
Thanks,
Naidu,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.