RE: Different Oracle clients give different results
Oracle says this is intended behavior for desc function just more rigorously enforced in later versions. I am still skeptical as desc works in 8.1.6 svrmgrl. Perhaps enforced in sqlplus but not svrmgr...too many inconsistencies. Thanks Rick Brian McGraw brian.mcgraw@infinity-insu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rance.comcc: Sent by: [EMAIL PROTECTED] Subject: RE: Different Oracle clients give different results 12/31/2002 01:28 PM Please respond to ORACLE-L Rick - Are all of the sqlnet.ora files resolving hostnames in the same order i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also check for a rogue tnsnames.ora file in the same path as the executable. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Different Oracle clients give different results
Rick - Are all of the sqlnet.ora files resolving hostnames in the same order i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also check for a rogue tnsnames.ora file in the same path as the executable. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Different Oracle clients give different results
Brian, Yes I have checked all of this. Three other co-workers are having same problem except they just have the one Oracle client 8.1.7. It appears to be client related. Thanks Rick Brian McGraw brian.mcgraw@infinity-insu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rance.comcc: Sent by: [EMAIL PROTECTED] Subject: RE: Different Oracle clients give different results 12/31/2002 01:28 PM Please respond to ORACLE-L Rick - Are all of the sqlnet.ora files resolving hostnames in the same order i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also check for a rogue tnsnames.ora file in the same path as the executable. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
