OraFAQ Forum: Data Integration » OUTER JOIN does not work with SUBSTR

Home » Developer & Programmer » Data Integration » OUTER JOIN does not work with SUBSTR (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OUTER JOIN does not work with SUBSTR [message #387543]

Thu, 19 February 2009 18:39

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

Report message to a moderator

Re: OUTER JOIN does not work with SUBSTR [message #387548 is a reply to message #387543]

Thu, 19 February 2009 20:04

Manoy
Messages: 2
Registered: February 2009

Junior Member

Hello!

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

Report message to a moderator

Previous Topic:	Missing Records
Next Topic:	oracle interview quesiton

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 19:28:14 CST 2024