| How can i issue SPOOL commands in forms. [message #83263] |
Sat, 30 August 2003 04:36  |
Susane
Messages: 27
Registered: September 2002
|
Junior Member |
|
|
hi to all,
Can anyone help me how can i incorporate the command of SPOOL in forms processing..
In SQL+ it is running.. the commands are as follows
1. SPOOL C:PAYROLL.DAT;
2. SELECT * FROM PAYROLL;
3. SPOOL OFF;
I used this command to create a text file from payroll table. To avoid this manual procedure for user. I issue this command in forms thru FORMS_DDL
but it doesn't work. Could anyone help me please..
Thanks and i really appreciate all your suggestions;
|
|
|
|
|
|
| Re: How can i issue SPOOL commands in forms. [message #83265 is a reply to message #83264] |
Sat, 30 August 2003 06:27  |
Susane
Messages: 27
Registered: September 2002
|
Junior Member |
|
|
hi sun..
Can you explain to me how can i used the text_io function. Please give me sample codes for this.. Sorry for that i am new programmer in oracle and im not familiar in this functions.
Pardon me thanks for the assistance..
sane
|
|
|
|
|
|
| Re: How can i issue SPOOL commands in forms. [message #83310 is a reply to message #83263] |
Fri, 19 September 2003 08:26 |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
make a external sqlscript called myspool.sql in your forms directory.
the content of the sscript is
---------------------
SPOOL C:PAYROLL.DAT
/
SELECT * FROM PAYROLL
/
SPOOL OFF
/
exit
--------------------
in your forms use this command, e.q within a buttontrigger:
host('sqlplus /w login/pass@databasename
@c:myformsmyspool.sql');
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
