OraFAQ Forum: Forms

Tue, 02 May 2006 23:58

NAVEENSHENOI
Messages: 4
Registered: April 2006
Location: COCHIN

Junior Member

Hi,
Is there any way to apply SET cammands like SET PAGES,set head etc in a trigger (eg.when buuton pressed)?
naveen

[Mod-edit: removed POLL]

[Updated on: Wed, 03 May 2006 00:22] by Moderator

Wed, 03 May 2006 00:21

Frank
Messages: 7901
Registered: March 2000

Senior Member

set pagesize is a sqlplus command.
when-button-pressed is a forms trigger.
So, this does not make sense. What do you try to achieve?

Wed, 03 May 2006 00:26

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

SET PAGESIZE and SET HEADING are Purely SQL * PLUS Commands..

Triggers is PL/SQL construct. It is nothing to do with these commands.

Thumbs Up

Rajuvan.

Wed, 03 May 2006 01:04

NAVEENSHENOI
Messages: 4
Registered: April 2006
Location: COCHIN

Junior Member

What i need is to spool the data in a table into a file when the user press the button.

Wed, 03 May 2006 01:12

Frank
Messages: 7901
Registered: March 2000

Senior Member

Search for text_io in the Forms-Help

Wed, 03 May 2006 08:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If they are running 9i/10g and want to spool to their PC then they need to run 'client_text_io' from 'webutil'.

David

Previous Topic:	DELETING A FILE
Next Topic:	Calling report from forms and Problem in calling report from forms9i (merged)

Goto Forum:

]

Current Time: Wed Feb 12 18:28:40 CST 2025