Home » Developer & Programmer » Forms » How can i issue SPOOL commands in forms.
How can i issue SPOOL commands in forms. [message #83263] Sat, 30 August 2003 04:36 Go to next message
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 #83264 is a reply to message #83263] Sat, 30 August 2003 06:03 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
You can make use of the built in text_io functions to write into a file.
Re: How can i issue SPOOL commands in forms. [message #83265 is a reply to message #83264] Sat, 30 August 2003 06:27 Go to previous messageGo to next message
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 #83268 is a reply to message #83265] Mon, 01 September 2003 00:41 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Try the Forms Help. There are examples there...

MHE
Re: How can i issue SPOOL commands in forms. [message #83310 is a reply to message #83263] Fri, 19 September 2003 08:26 Go to previous message
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');
Previous Topic: Forms 9i DS not working - 06508 Error
Next Topic: viewing the tab canvas
Goto Forum:
  


Current Time: Thu Mar 28 10:54:23 CDT 2024