Oracle Database data select failing

[former_member305388]

Hi Experts,

We have done SAP system upgrade and the programs using native sql are failing after the upgrade. while checking in debug I found the connection is successfully established to database but the select is failing.

I also used the standard program ADBC_DEMO_METADATA to get the table details which is also failing. In the old system this program fetches the table fields and index properly.

So now the issue is where to check whats causing the data selection to fail as connectivity seems fine?

Thanks.

[Former Member]

Hi,

Are you able to login to database using the tool TOAD.

Also check your authorizations with BASIS ppl.

Regards

HM

[former_member214857]

Hi

Try to use Database schema in "Database Schema" field. Usually this is SAPSR3 for Oracle databases.

Best regards

[former_member305388]

Hi Carlos,

The result is same, it still does not work.