Home » Developer & Programmer » Forms » run a procedure made in the DB (form developer 6i second release)
run a procedure made in the DB [message #285738] Wed, 05 December 2007 07:23 Go to next message
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

Re: run a procedure made in the DB [message #285740 is a reply to message #285738] Wed, 05 December 2007 07:25 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And the question is?

MHE
Re: run a procedure made in the DB [message #285744 is a reply to message #285738] Wed, 05 December 2007 07:27 Go to previous messageGo to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
how can i run the procedure in the form
Re: run a procedure made in the DB [message #285746 is a reply to message #285744] Wed, 05 December 2007 07:33 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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;
Re: run a procedure made in the DB [message #285911 is a reply to message #285738] Thu, 06 December 2007 01:27 Go to previous messageGo to next message
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
Re: run a procedure made in the DB [message #285913 is a reply to message #285738] Thu, 06 December 2007 01:30 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Write the procedure in the program unit and then call.
Re: run a procedure made in the DB [message #285928 is a reply to message #285738] Thu, 06 December 2007 02:07 Go to previous messageGo to next message
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
Re: run a procedure made in the DB [message #285940 is a reply to message #285738] Thu, 06 December 2007 02:53 Go to previous messageGo to next message
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
Re: run a procedure made in the DB [message #286006 is a reply to message #285738] Thu, 06 December 2007 05:06 Go to previous messageGo to next message
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
Re: run a procedure made in the DB [message #286017 is a reply to message #286006] Thu, 06 December 2007 05:28 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Did you commit?

MHE
Re: run a procedure made in the DB [message #286021 is a reply to message #285738] Thu, 06 December 2007 05:32 Go to previous messageGo to next message
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????

Re: run a procedure made in the DB [message #286022 is a reply to message #286017] Thu, 06 December 2007 05:33 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Maaher wrote on Thu, 06 December 2007 12:28

Did you commit?

MHE

DID YOU COMMIT?

MHE
Re: run a procedure made in the DB [message #286026 is a reply to message #286021] Thu, 06 December 2007 05:37 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

@ashraf_al_ani:

Quote:

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


does your procedure compile correctly.the reason for asking this is your procedure name is del_range and you end your procedure as lost.

regards,


Re: run a procedure made in the DB [message #286031 is a reply to message #285738] Thu, 06 December 2007 05:53 Go to previous messageGo to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
thanks alot brothers

I commit and every thing is ok

best regards
Re: run a procedure made in the DB [message #286038 is a reply to message #285738] Thu, 06 December 2007 06:15 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
BUt
Quote:

does your procedure compile correctly.the reason for asking this is your procedure name is del_range and you end your procedure as lost.

Previous Topic: Procedure on alter user [MERGED]
Next Topic: FRM-40505 :ERROR Unable to perform query
Goto Forum:
  


Current Time: Thu Dec 08 04:32:52 CST 2016

Total time taken to generate the page: 0.09365 seconds