|
|
| Re: Anything like spool? [message #441128 is a reply to message #441111] |
Thu, 28 January 2010 23:11   |
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 #441172 is a reply to message #441130] |
Fri, 29 January 2010 03:40 |
cookiemonster
Messages: 13938
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
