topic Oracle Database data select failing in Application Development and Automation Discussions

Oracle Database data select failing

Former Member — Wed, 15 Feb 2012 11:26:35 GMT

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.

Re: Oracle Database data select failing

Former Member — Wed, 15 Feb 2012 11:44:46 GMT

Hi,

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

Also check your authorizations with BASIS ppl.

Regards

Re: Oracle Database data select failing

former_member214857 — Wed, 15 Feb 2012 12:13:45 GMT

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

Best regards

Re: Oracle Database data select failing

Former Member — Wed, 15 Feb 2012 13:07:06 GMT

Hi Carlos,

The result is same, it still does not work.