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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain the difference between architecture followed in 10g & 11g?

652


How many schemas we have? how many you have used?

1608


testing tools?

1748


List the various types of value set.

618


What is a value set? List its various types.

648






WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2589


In support project one ticket alloted which steps follows manualy tell me ?

2219


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1797


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

639


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2460


How can we import the data into a database using sql * loader?

676


List the types of flexfield?

603


What is count(*) from po_vendors(any table)?

639


What is a flexfield? List out its types.

661


Do you know what are user profiles in apps. Any examples you can give?

656