Scenario:
We need to pass directory location so that it will pick file names and delimited file names with ';' as mentioned in below example
For Example:
Dir: <FOLDER_LOCATION>
Sample_File.txt(File)
Sample_File.csv(File)
Sample_File.xls(File)
Output should be 'Sample_File.txt;Sample_File.csv;Sample_file.xls'
Steps:
Step1:
Create a procedure and select target technology as Oracle
Step 2:
Go to Option and create new option whose name is "Dir" , Data type as "Text" and Direct Value "<DIRECTORY_LOCATION>" (eg : C:/Sample_files)
Step 3:
Copy below code and paste in target side and select technology as Oracle and Logical Schema accordingly
<?
import java.io.File;
public class FileLists{
public static String FileNames() {
File f = null;
String[] FileList;
String fileNames="";
try{
f = new File("<%=odiRef.getOption( "Dir" )%>");
FileList = f.list();
for(String FileName:FileList)
{
if(FileName.contains("."))
{
if (!fileNames.isEmpty())
fileNames = fileNames+','+ FileName ;
else
fileNames = FileName;
}
}
}catch(Exception e){
e.printStackTrace();
}
return fileNames;
}
}
?>
select '<?=FileLists.FileNames()?>' from dual
Step 4:
Drag and drop the procedure into package and go to options and provide value to Dir option as below
We need to pass directory location so that it will pick file names and delimited file names with ';' as mentioned in below example
For Example:
Dir: <FOLDER_LOCATION>
Sample_File.txt(File)
Sample_File.csv(File)
Sample_File.xls(File)
Output should be 'Sample_File.txt;Sample_File.csv;Sample_file.xls'
Steps:
Step1:
Create a procedure and select target technology as Oracle
Step 2:
Go to Option and create new option whose name is "Dir" , Data type as "Text" and Direct Value "<DIRECTORY_LOCATION>" (eg : C:/Sample_files)
Step 3:
Copy below code and paste in target side and select technology as Oracle and Logical Schema accordingly
<?
import java.io.File;
public class FileLists{
public static String FileNames() {
File f = null;
String[] FileList;
String fileNames="";
try{
f = new File("<%=odiRef.getOption( "Dir" )%>");
FileList = f.list();
for(String FileName:FileList)
{
if(FileName.contains("."))
{
if (!fileNames.isEmpty())
fileNames = fileNames+','+ FileName ;
else
fileNames = FileName;
}
}
}catch(Exception e){
e.printStackTrace();
}
return fileNames;
}
}
?>
select '<?=FileLists.FileNames()?>' from dual
Step 4:
Drag and drop the procedure into package and go to options and provide value to Dir option as below
No comments:
Post a Comment