Home » SQL & PL/SQL » SQL & PL/SQL » order of executing procedures (oracle XE apex)
order of executing procedures [message #333957] Tue, 15 July 2008 00:51 Go to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,

While writing trigger on trans (table name) for before insert or update or delete
i called two procedures to fire.

one of the line in the procedure (first_procedure) executes

trans.amount := trans.qty * trans.unit_rate;

in another procedure (second_procedure) , i am using this trans.amount to update another master file.

so long first_procedure executed before second_procedure,
no problem arises. calling the procedure is also written
on order as
first_procedure()
second_procedure()

My subordinate says, nowadays the invoking second procedure
need not wait for first_procedure. Parallaly runs. Hence
you must pass some parameters with values to second_procedure
to control the events.

is it true?

yours
dr.s.raghunathan

Re: order of executing procedures [message #333964 is a reply to message #333957] Tue, 15 July 2008 01:04 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is wrong.
Procedures are called sequentially as you wrote them.

Regards
Michel

[Updated on: Tue, 15 July 2008 01:05]

Report message to a moderator

Previous Topic: SELECT and tablespaces
Next Topic: BULK UPDATE
Goto Forum:
  


Current Time: Fri Dec 09 17:55:25 CST 2016

Total time taken to generate the page: 0.32951 seconds