OraFAQ Forum: Forms » run a procedure made in the DB

Home » Developer & Programmer » Forms » run a procedure made in the DB (form developer 6i second release)

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

run a procedure made in the DB [message #285738]

Wed, 05 December 2007 07:23

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

Dear All

I have a procedure made in the DB and its name is del_range
i just to run it in a form using a trigger when button pressed

best regards

Report message to a moderator

Re: run a procedure made in the DB [message #285740 is a reply to message #285738]

Wed, 05 December 2007 07:25

Maaher
Messages: 7065
Registered: December 2001

Senior Member

And the question is?

MHE

Report message to a moderator

Re: run a procedure made in the DB [message #285744 is a reply to message #285738]

Wed, 05 December 2007 07:27

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

how can i run the procedure in the form

Report message to a moderator

Re: run a procedure made in the DB [message #285746 is a reply to message #285744]

Wed, 05 December 2007 07:33

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

Senior Member
Account Moderator

There's nothing special about it - just call the procedure! (Though, we don't know what it is supposed to do, but I hope you do):

WHEN-BUTTON-PRESSED trigger code:

del_range;

Report message to a moderator

Re: run a procedure made in the DB [message #285911 is a reply to message #285738]

Thu, 06 December 2007 01:27

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

I did the same thing but it didnt execute
are there any properties we must changee in the form
or datablock please inform me

Report message to a moderator

Re: run a procedure made in the DB [message #285913 is a reply to message #285738]

Thu, 06 December 2007 01:30

varu123
Messages: 754
Registered: October 2007

Senior Member

Write the procedure in the program unit and then call.

Report message to a moderator

Re: run a procedure made in the DB [message #285928 is a reply to message #285738]

Thu, 06 December 2007 02:07

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

i have wrote the procedure in the database but i want to run that procedure by a form

Report message to a moderator

Re: run a procedure made in the DB [message #285940 is a reply to message #285738]

Thu, 06 December 2007 02:53

varu123
Messages: 754
Registered: October 2007

Senior Member

Then you have to do nothing more than what Maaher suggested.

What error did you get?
WHats your code?
Post it

Report message to a moderator

Re: run a procedure made in the DB [message #286006 is a reply to message #285738]

Thu, 06 December 2007 05:06

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

there is no error
but when i press the button nothing happened
and the data in my table remains and nothing happened to it
please inform me and give me your advice

best regards

Report message to a moderator

Re: run a procedure made in the DB [message #286017 is a reply to message #286006]

Thu, 06 December 2007 05:28

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Did you commit?

MHE

Report message to a moderator

Re: run a procedure made in the DB [message #286021 is a reply to message #285738]

Thu, 06 December 2007 05:32

ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq

Member

dear all
ive wrote this procedure in the DB

CREATE OR REPLACE PROCEDURE TEST.del_range IS
begin
DELETE FROM emp
WHERE ((emp.sex = '2'));
END lost;

so how can i call this procedure in my form????

Report message to a moderator