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

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

While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?

2 Answers  

---

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers   Wipro,

---

FLEX FIELDS?

2 Answers  

---

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  

---

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,

---

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---

Can functions be overloaded ?

2 Answers  

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,

---

We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,

---

What r the validation types?

3 Answers  

---