Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,187 of 2,288    |
|    .com to Siddhant Kumar    |
|    Re: Data in Text file thru Stored proced    |
|    05 Mar 04 06:45:47    |
   
   XPost: comp.databases.oracle.server   
   From: mcstockX@Xenquery   
      
   "Siddhant Kumar" wrote in message   
   news:495df6b8.0403050324.31e652a1@posting.google.com...   
   | I want to write a Text file containing data (either , or Tab   
   | delimited) using stored procedure. can any one guide me how to do   
   | this.? or point to a sample/link of code. DATABASE IS BOTH ORacle 8.x   
   | and Oracle 9   
      
   dbms_output.put_line if you want to spool to a file via the calling program,   
   like sqlplus   
      
   utl_file if you want to create a file on the server   
      
   htp.p and http header settings if you're doing PL/SQL gateway (web toolkit)   
      
   what's you interface?   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca