OraFAQ Forum: Client Tools » using TOAD where i will write cursor program and where i will run?

Home » Other » Client Tools » using TOAD where i will write cursor program and where i will run?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using TOAD where i will write cursor program and where i will run? [message #222972]

Wed, 07 March 2007 01:35

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

using TOAD where i will write cursor program and where i will run?

Report message to a moderator

Re: using TOAD where i will write cursor program and where i will run? [message #222973 is a reply to message #222972]

Wed, 07 March 2007 01:37

Frank
Messages: 7901
Registered: March 2000

Senior Member

Press F1

Report message to a moderator

Re: using TOAD where i will write cursor program and where i will run? [message #223153 is a reply to message #222973]

Wed, 07 March 2007 14:56

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

No, do not press F1. It will start this year's Formula 1 car racing season too early - it is scheduled for March 18th in Melbourne, Australia (that's down under, where people stand on their heads). So - wait a little bit longer.

Write your cursor programs in SQL (or even Procedure) Editor. It will be either an anonymous PL/SQL block (so run it by clicking on "Execute as script" button) or perhaps a named procedure (so you'd run it by typing "EXEC procedure_name" and pressing the same "Execute as script" button again.

There might be different issues about the whole thing (for example, passing parameters, using functions instead of procedures etc.), but - you'll tell us when you come to it.

Report message to a moderator

Re: using TOAD where i will write cursor program and where i will run? [message #223230 is a reply to message #223153]

Thu, 08 March 2007 01:42

Frank
Messages: 7901
Registered: March 2000

Senior Member

Seeing his vast batch of very basic questions the OP poured out over us at the time he posted this, I thought it wise to point out to him that there is a thing called 'Help'.

Report message to a moderator