what are the functions you are used in utl_file at the time
of transferring the data?

Answer Posted / samad

HI,

We will use following three functions to generate the file.

1)Utl_File.fopen = To open (or) Create the file
2)Utl_File.Put_line = To Transfer the data into the File.
3)Utl_File.fclose = To close the File after Data
transfer.

REGARDS
SAMAD
samadsmilein@gmail.com

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are you familiar with internet architecture of oracle apps 11i?

849


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

922


How can you achieve loose coupling in soa framework?

1013


How do you register report in oracle apps?

895


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2151


How is choreography different from orchestration?

910


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2376


A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

1971


tell me the scenarios of the independent in reports

2405


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

2462


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2397


What do you understand by soa?

929


what are the balancing segments in AR?

1869


can we get profile values in report without using user exists is it possible how?

2581


how to print multi lay outs,muti currency,muti language in xml publisher

11570