Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01007: variable not in select list

AvaApr 12 2010 — edited Apr 13 2010
Hi All,

We are facing the following error while exeucting mappings in Oracle Warehouse Builder 11.1.0.7.0

earlier all mappings are executing fine. from this morning we are getting the following error.

we are using the join condition in mapping as follows:

INGRP1.COLA>=INGRP2.COLA

Can you please share how can we resolve the above error?

Regards,
Ava.

Comments

Hello,
UNC paths usually are restricted due to the security nature of Oracle Report.
Added <folderAccess> element in rwserver.conf file

<folderAccess>
<read>O:\temp\*</read>
<write>O:\temp\*</write>
</folderAccess>

Add this line to setDomainEnv.cmd script in $DOMAIN_HOME/bin directory
NET USE O: \\server01\my_directory /user:<userid> <password>
where:
O: – is the mapped drive letter
\\server01\my_directory – is the root of remote file system
<userid> – name of user authorized to connect to remote file system.
<password> – password for <userid>
then you can use O:\file to access files within my_directory
Thanks, Suresh

user6532048

I did add the drive from file explorer, I can access the new drive in the file explorer.
Is that I also need to add "NET USE" in setDomainEnv.cmd?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2010
Added on Apr 12 2010
#data-warehousing, #warehouse-builder
4 comments
2,513 views