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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / muneer

IN ABOVE ANS ONLY FOPEN IS A FUNCTION REMAINING ARE
PROCEDURE
FUN IN UTL FILE ARE
F OPEN
IS OPEN
FOPEN NCHAR

MUNEER

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,


What are do's and dont's of Interface?

0 Answers  


what are the error tables in AP?

6 Answers  


What are the requests groups?

3 Answers  


What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,






what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,


When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,


Types of cursors?

3 Answers  


what is the difference between request group and request security group in oracle apps?

2 Answers   BirlaSoft,


suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,


please explain open interface import

2 Answers  


AOL?

4 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)