• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

URGENT: Oracle 8i And OLEDB data provider

How do you perform a LEFT OUTER JOIN in Oracle 8i using the OLEDB data provider?  I can not use the Oracle data provider because all previous code was written in OLEDB
0
MageDribble
Asked:
MageDribble
  • 5
  • 3
1 Solution
 
Bob LearnedCommented:
It is pretty trivial to change to the Oracle client just by doing a global replace from OleDb to Oracle.

Bob
0
 
MageDribbleAuthor Commented:
I know that and you know that but my manager refuses to listen.  He wants everything coded in OleDB.
0
 
Bob LearnedCommented:
That's just plain silly, since the Oracle client is optimized for Oracle.

Left outer join for 8i:

Select  last_name,  department_name
From  employees e, departments d
Where e.department_id = d.department_id(+);

Bob
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
MageDribbleAuthor Commented:
I've tried it using the Oracle data provider and it works fine but once I try that in the OleDB but it did not work.
0
 
MageDribbleAuthor Commented:
My co-worker issued a GRANT SELECT on the other schema.  The two schemas had the same structure and we were trying to find differences.  Apparently the OleDB connection was just going straight through and hitting only 1 schema.  When we tested it in TOAD, it worked fine but OleDB had issues.
0
 
Bob LearnedCommented:
1) We use 9i here, so I had to look up 8i LEFT OUTER JOIN syntax

2) What was the exception that you were getting from OleDb?

Bob
0
 
MageDribbleAuthor Commented:
I asked the programmer and now he said there was no error.  It was just querying 1 table and not returning any mismatching results.  When he ran it in TOAD, it worked fine but OleDB would not show the mismatches.  Apparently, it was querying the same table.  He thinks the GRANT SELECT priveledge is causing the OleDB to passthrough to the other table.  He's re-loading the schemas and going to try it fresh.
0
 
MageDribbleAuthor Commented:
your answer to the problem I asked was correct so I am giving you the points.  The problem was with the way my programmer was granting privledges so we were able to resolve that.  Thanks again for your help!

Mage
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now