Home » Developer & Programmer » Data Integration » OUTER JOIN does not work with SUBSTR (10g)
icon5.gif  OUTER JOIN does not work with SUBSTR [message #387543] Thu, 19 February 2009 18:39 Go to next message
Manoy
Messages: 2
Registered: February 2009
Junior Member
Hi OWB Gurus! Smile

I'm just new to OWB. And right now, I've already spent half of the day solving this problem. Confused

I have two tables that I want to merge.


TABLE 1
ID Score
AB080917 10
AC090130 20

TABLE 2
Man_No Rank
AB20080916 2
AB20090130 1

In the JOINER function, I used the link statement below:

SUBSTR(table1.ID,-6) = SUBSTR(table2.Man_No,-6)

I got this error, however:


ORA-06550: line 365, column 7:
PL/SQL: SQL Statement ignored

ORA-06550: line 482, column 41:
PL/SQL: ORA-00936: missing expression

I tried removing the (+) sign, and executed the mapping successfully. But of course, I didn't get the desired result. Sad What could be the problem? Any suggestions will be greatly appreciated. (I'll read all of them tomorrow.) Smile

Manoy
Re: OUTER JOIN does not work with SUBSTR [message #387548 is a reply to message #387543] Thu, 19 February 2009 20:04 Go to previous message
Manoy
Messages: 2
Registered: February 2009
Junior Member
Hello! Smile

I just did a workaround.
I've observed that the SQL statement above really be read by OWB. So, instead, I transformed first the variables above before linking them.
And everything went fine from there. Surprised

Manoy

Previous Topic: Missing Records
Next Topic: oracle interview quesiton
Goto Forum:
  


Current Time: Fri Mar 29 01:52:07 CDT 2024