PH can see Oracle, but displays no records on the Oracle database

[Brett Greiner]

The previous issue was the LIBPATH not pointing to the Oracle lib
directory. Thanks for all the input.


Now the records for the Oracle database are not showing up when doing a
'show database afl'.
 
But you can setup a cursor to access the Oracle data.
 
Any ideas?
 
Brett

 
Q S H O W   (PowerHouse  8.43.D1)
Copyright 2005 COGNOS INCORPORATED
 
> show database afl
12 May 2006                   Allied Farmers                      Page
1
                       D A T A B A S E  R E P O R T
                  For DICTIONARY:  /test/dict/afldict.pdc
    Database:           AFL
    Organization:       RELATIONAL
    Null Values Allowed:Yes
    Type:               ORACLE
    Hold Cursor:        Unspecified
    Open:               AFL
    Userid:             AFL
    Records & Sizes:    ** none ** 
 
 
Q U I Z (PowerHouse 8.43.D1)
Copyright 2005 COGNOS INCORPORATED

> SQL DECLARE TEST_CURSOR CURSOR FOR SELECT * FROM ASSET_CATEGORY

> access TEST_CURSOR

> go

Records selected: 1

>