Home » SQL & PL/SQL » SQL & PL/SQL » creation of a procedure depends on a parameter (form developer 6i second release)
creation of a procedure depends on a parameter [message #281570] Sun, 18 November 2007 07:29 Go to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
Dear all

I want to create a procedure to delete a number of records depends of an input parameter
I mean that the procedure when it works it asks for a parameter such as the name of the department
So how can I do such thing?


best wishes



Re: creation of a procedure depends on a parameter [message #281590 is a reply to message #281570] Sun, 18 November 2007 09:19 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Pass desired value through the procedure parameter. Something like
CREATE PROCEDURE prc_delete (par_what_to_delete IN NUMBER)
IS
...
and call it as
exec prc_delete(4);
Previous Topic: Install PL/SQL Examples in my current user
Next Topic: where to get some example database?
Goto Forum:
  


Current Time: Mon Dec 05 09:11:25 CST 2016

Total time taken to generate the page: 0.13699 seconds