Home » Developer & Programmer » Forms » Anything like spool? (FORMS 6i)
icon11.gif  Anything like spool? [message #441111] Thu, 28 January 2010 21:23 Go to next message
wkloveforms
Messages: 14
Registered: January 2010
Junior Member
IN FORMS,IS there anything like the 'spool(PL/SQL)' or the 'into outfile(MySQL)'?
Re: Anything like spool? [message #441128 is a reply to message #441111] Thu, 28 January 2010 23:11 Go to previous messageGo to next message
beginnerHere
Messages: 55
Registered: October 2009
Member
I don't think you can use spool in forms (sorry if i turn out to be wrong)

If you want to get your data out to a file then you would either have to make use of the UTL_FILE package or the TEXT_IO package.

Hope it somehow helps.
Re: Anything like spool? [message #441130 is a reply to message #441111] Thu, 28 January 2010 23:16 Go to previous messageGo to next message
wkloveforms
Messages: 14
Registered: January 2010
Junior Member
hi..

i want something like copyfromrecordset(Visual Basic)

can get the records one time..

Re: Anything like spool? [message #441172 is a reply to message #441130] Fri, 29 January 2010 03:40 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
wkloveforms wrote on Fri, 29 January 2010 05:16

i want something like copyfromrecordset(Visual Basic)


Since alot of us here don't use vb it'd probably simpler if you explained without reference to it what you are trying to do.
You can't use spool in forms because it's a sqlplus command.
The standard way to write files from forms is either UTL_FILE or TEXT_IO as beginnerHere said. Which you should use depends on whether you want the resulting file on the database server or not.
Previous Topic: dividing a column "EMP_name" into "first_name", "last_name" columns of
Next Topic: do you want to save changes
Goto Forum:
  


Current Time: Sat Sep 24 16:22:03 CDT 2016

Total time taken to generate the page: 0.06224 seconds