Windows Oracle Data Access Components (MOSC)

MOSC Banner

sql query do not return expected output from Windows machine

edited Apr 2, 2019 5:05AM in Windows Oracle Data Access Components (MOSC) 4 commentsAnswered

Hello Team,

Apologies if this question is put in incorrect space. If this is not the correct space, please go through my question and point me to correct one.

Question :
My EBS 9.2.0.8 database is running on AIX Server. When I execute a query ( select * from "some_view" ) from plsql_developer/oracle client from laptop it returns the expected O/P.

However, when same query is run from sqlplus from Windows Server 2012 R2 Standard, it says "No rows Returned" .

I have enabled the trace for the session and here is the O/P of TKPROF for that Query :

cpu      = cpu time in seconds executing

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center