in order to run utl_file package we need to give any specific path? if yes what

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

Question Posted / rameshmcaou

1 Answers
7067 Views
KPMG, I also Faced
E-Mail Answers

in order to run utl_file package we need to give any specific path? if yes what is that?where u will..

Answer / ravi soma

Yes,We have to specify the path of where we will upload the
data from the apps base tables to legacy file.

one can find the path using the fallowing command
select value from v$parameter where name='utl_file_dir'.

we need to register in oracle apps using the package name.

Is This Answer Correct ?

10 Yes

0 No

Post New Answer

More Oracle Apps Technical Interview Questions

what are the tables of auto invoice.

2 Answers

what are the important table names in purchasing?

3 Answers TCS,

What is ment by Global Templates in Oracle.

1 Answers IBM,

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers

when we run payment batch what are the 3 concurrent programs?

1 Answers Genpact, Wipro,

How to register a form and stored procedure in oracle apps

2 Answers Mastek, TCS,

how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers Amdocs,

how to set org context?

3 Answers

what are the match approvals in PO?

3 Answers

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers CTS, iGate,

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers IBM,

What are the different components you should consider while defining a responsibility in oracle apps?

0 Answers

For more Oracle Apps Technical Interview Questions Click Here