Re: SQL*PLUS 8.0 returns LESS rows from Oracle 7.3.3, WHY??

NO_SPAM.jizwang_at_cc.umanitoba.ca (Dr. J. Wang) writes:

>
>
> Hi there,
>
> I am using SQL*PLUS 8.0 came with Oracle 8.0.3 for NT against Oracle 7.3.3
> server on a Unix box. About 80% time I receive LESS rows than I used SQL*Plus
> directly on the Unix box (SQL*Plus installed with Server 7.3.3). I also can
> not use "desc table1" in SQL*PLUS 8.0 for NT. It complains "ERROR:
> ORA-12663: Services required by client not available on the server".
>
> Yes, I did set compatibility to 7 in SQL*PLUS 8.0 environment. It doesn't
> help.
>
> Anyone has some clues?
>

Jizhong:

The 12663 error would seem to indicate that the Advanced Networking Option is installed on the client side but not on the server. Look in the sqlnet.ora file on the NT machine. Make sure that the encryption and checksumming parameters are set to "requested" rather than "required."

I have no idea why you are getting fewer rows.

-- 
                                        Rick
                                        Rick Wessman
                                        Middleware Security Products
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com