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

[Peter Bateman]

Hi Brett:

   Here is some ideas.

   AFL does not have permission to read the metadata.

   I would try dbaudit=full to see what PH is doing then
   try the same thing with SQLPLUS.

   Try running QSHOW with the OWNER=AFL this should
   cause show database AFL  to display only the records
   owner by AFL.

Regards,
Peter
>
>
>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
>
> >
>
>
>
>
>
>
>
>
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
>list archive at Google.

_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft® SmartScreen 
Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.