Oracle stage

prashantnandi · Post by **prashantnandi** » Mon Nov 20, 2006 7:19 am

Hi,

I have a job which has reference look up as Oracle table.
When i try to use Sparse look up on the Oracle reference table from
the look up primary source i am getting the the below error.

ORA-01480: trailing null missing from STR bind value

But if instead of Sparsed look up if i use Normal look up ,then its working
The screen shot of error in detail is as below

TLookup_36,0: GenericQuery:esqlErrorHandler
Open failed for: GenericStmt_1
query is: SELECT ACCT_NUM,trim(WEB_ID) as WEB_ID,WEB_SITE_ID FROM CAT01.ST_ACCT WHERE WEB_ID = :WEB_ID AND WEB_SITE_ID= :WEB_SITE_ID
sqlcode is: -1480
esql complaint: ORA-01480: trailing null missing from STR bind value

ray.wurlod · Post by **ray.wurlod** » Mon Nov 20, 2006 7:42 am

Welcome aboard.

Please post questions about parallel jobs in the parallel job forum.

Search to learn about how to do images here - you can not post them directly.

kduke · Post by **kduke** » Fri Dec 22, 2006 4:33 pm

Search asktom.oracle.com use ORA-1480. It is a bug. There is a fix for it.