Help | Site Map
Connecting Tech Pros Worldwide
Reply
 
LinkBack Thread Tools
  #1  
Old August 18th, 2008, 08:05 AM
Newbie
 
Join Date: Aug 2008
Posts: 3
Default how to create a txt file from PL/SQL procedure

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
Reply
  #2  
Old August 18th, 2008, 09:57 AM
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: India
Age: 24
Posts: 2,016
Default

Check UTL_FILE PACKAGE
Reply
  #3  
Old August 18th, 2008, 03:01 PM
Newbie
 
Join Date: Aug 2008
Posts: 3
Default

Quote:
Originally Posted by amitpatel66

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?
Reply
  #4  
Old August 22nd, 2008, 12:39 PM
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: India
Age: 24
Posts: 2,016
Default

Check here
.
Reply
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles