Hi,
I'm having an issue where a user has been using SQL*PLUS to query a SID on an Oracle Database Server 11g Release 1.
They have a read-only SQL account to run the query, which returns 67,000+ rows when they run it on their old laptop, but 0 rows when they run it on their current laptop.
They are using the same version of SQL*PLUS on both laptops (SQL*PLUS: Release 8.1.7.0.0, connecting to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production).
I used SQL Developer to connect and run the query using the user's username/pwd and it worked for me returning the query as expected.
Can anyone recommend what sort of settings and environment variables I need to check? Things in the registry, SQL*PLUS settings seem to match up too, as does the TNS_ADMIN environment variable.
I've attached the script:
I'm having an issue where a user has been using SQL*PLUS to query a SID on an Oracle Database Server 11g Release 1.
They have a read-only SQL account to run the query, which returns 67,000+ rows when they run it on their old laptop, but 0 rows when they run it on their current laptop.
They are using the same version of SQL*PLUS on both laptops (SQL*PLUS: Release 8.1.7.0.0, connecting to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production).
I used SQL Developer to connect and run the query using the user's username/pwd and it worked for me returning the query as expected.
Can anyone recommend what sort of settings and environment variables I need to check? Things in the registry, SQL*PLUS settings seem to match up too, as does the TNS_ADMIN environment variable.
I've attached the script:
Code:
set arraysize 1
set echo off
set verify off
set pages 6000
set lines 600
spool c:\personaldata\jbquery.txt
col pdname heading 'Period' format A6
col pdyear heading 'Year' format 9999
col pdnum heading 'Pd Num' format 9999
col bu heading 'BU' format A6
col costc heading 'Cost Centre' format A12
col acc heading 'Account Code' format A12
col brs heading 'BRS' format A12
col prj heading 'Project Code' format A12
col Drbal heading 'Dr Bal' format 9999999999.99
col Crbal heading 'Cr Bal' format 9999999999.99
col Pdbal heading 'Net Pd Bal' format 9999999999.99
SELECT
C.SEGMENT1 bu,
C.SEGMENT2 costc,
C.SEGMENT3 acc,
C.SEGMENT5 prj,
L.PERIOD_NET_DR - L.PERIOD_NET_CR Pdbal
FROM APPS.GL_CODE_COMBINATIONS_V C,
APPS.GL_BALANCES L,
apps.fnd_flex_values_vl g
WHERE C.CODE_COMBINATION_ID = L.CODE_COMBINATION_ID
And g.flex_value_set_id=1002626
And c.segment5 = g.flex_value
and l.currency_code = 'GBP'
and l.actual_flag = 'A'
and l.period_year = '2011'
and l.period_num >= '04'
and l.period_num <= '04'
and c.segment3 >= '000000'
and c.segment3 <= '795000'
and L.PERIOD_NET_DR - L.PERIOD_NET_CR <> 0
/
spool off
set lines 100
set pages 24
set verify on
set echo on