daogu

Hi,

I have a procedure that contains a varchar2 variable,now i need to create a text file in from procedure and move varchar2 content into the file.

Can any one help?

Thanks in advance

---

Answer:

You Can use Text_Io package to create text file in front end. In Stored procedure we can use utl_file package.

Ex:

---

Answer:Thank you very mush..

---

Answer:Hi Gurupatham,

I am getting the error.

ORA-06550

PlS-00201:identifier ‘TEXT_IO.FILE_TYPE’ must be declared

for more info i have attached error message.

---

Answer:Given Example does not work in database environment(Stored Procedure). it Works only in form.

For Stored Procedure Use utl_File Package .

Ex:

---

Answer:may i know how to give Dir path?I am getting "ORA-29280: invalid directory path——–29280" error.

---

Answer:Hi,

I am using oracle client.I need to create text file in my system using Utl_File.File_Type.how to give dir path?

---

Answer:Do you want to use a different directory for different files or the same directory all the time?

David

---

Answer:Same dir for all files.but i need to create that dir in my sys not at server.(Server not accessable).

---

Answer:Then use ‘client_text_io’. Read about webutil in help.

David

Related posts:

1. Export query to excel Dears, I realy had searched alot and i couldn’t...
2. FLUSH in TEXT_IO similar to one in UTL_FILE Is there any procedure like FLUS existed in TEXT_IO...
3. Unzip file from froms then load. i have form (basically called loader) which read text...
4. Cannot read menu file Guys, I am having this problem about not being...
5. Import CSV directly into FORM 6 and d2kwutil and reading from file (win_api_file.read_file)(merged) Hi I know that this topic in not new,...