| using external table [message #453314] |
Wed, 28 April 2010 04:17  |
swapna053
Messages: 18
Registered: March 2010
|
Junior Member |
|
|
hello,
I am using apex 3.2 oracle 10g
I have a folder EXP in C drive where *.csv files are present.
I am using external table to fetch data from the csv file to db table through a procedure.It works fine.
Server Side:
Now i installed the application in one machine (server machine) and gave create directory privileges and copied exp folder and *.csv files to this server machine.
Now i am accessing the application from a client machine through browser.In that machine also i created EXP folder with csv files.
But the external table always point to server machine EXP and not Client machine EXP Folder.
What need to be done so that it points to its own EXP folder?
Thanks
[MERGED by LF]
[Updated on: Thu, 29 April 2010 04:15] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| run batch file from client machine [message #453470 is a reply to message #453314] |
Thu, 29 April 2010 03:41  |
swapna053
Messages: 18
Registered: March 2010
|
Junior Member |
|
|
Hello,
I am using a bat file called gen.bat.
The code is like this
if exist "%EXP_PATH%\data\*.csv" goto found
echo no *.csv files found.
goto end
:found
rem delete filename file
del %EXP_PATH%\filenames.txt
rem to go to directory
cd %EXP_PATH%\data
:end
Now here %EXP_PATH% is a n environment variable and the value is C:\exp
Now i have shared the exp folder and i am trying to run from another machine, but the problem is the environment variable comes as null there.
Waht need to be done for that?
Thanks
|
|
|
|
| Re: using external table [message #453471 is a reply to message #453340] |
Thu, 29 April 2010 03:45 |
swapna053
Messages: 18
Registered: March 2010
|
Junior Member |
|
|
Hello,
I shared the folder in the server machine, now the problem is i have a batch file which is used to find the csv files and through batch script copies to a file called filenames.txt This filenames.txt is pointed by external table.When i run that batch file from client machine,the bat files uses Environment variable and that comes null in the client machine?
Thanks
[Updated on: Thu, 29 April 2010 03:48] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: run batch file from client machine [message #453479 is a reply to message #453477] |
Thu, 29 April 2010 04:34 |
swapna053
Messages: 18
Registered: March 2010
|
Junior Member |
|
|
Hello,
It goes like this
On the server side:
I have exp folder in c drive
which has 2 folder
- data ->which contains all the *.csv files
- scripts - > which contains some batch file.
The work of one of this batch file is to copy the name of the csv file and put into a file called filenames.txt.
This filenames.txt file is pointed by external table.
Now since i am using a environment variable(EXP_PATH) whose value(C:\exp) is set at server side, in the client side when i was running the batch file , the ev value comes as null.
Now,you mean to say if i am running the batch file from client side then i should create another ev at client side?
Thanks
[Updated on: Thu, 29 April 2010 04:41] Report message to a moderator |
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
