Logic for creating the procedure

[zircon06]

Hi all.

I'm looking for looking for logic creation of procedure. I have procedure check_employeedetails. I want create this Procedure, execute and drop from schema.

Thanks in advance

 

[SantaMufasa]

I have procedure check_employeedetails. I want create this Procedure, execute and drop from schema.

So, if you have the procedure, do you want to post it for us to read? If you want to create, execute, and drop, what is preventing you from doing so?


What help do you want from us?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[zircon06]

Hi santa,

I'm looking procedure to do following



create check_employee details
Execute this procedure
Drop this procedure after this execution

all in one step process

Thanks

 

[SantaMufasa]

With the information you provide, here is the most code I can offer:

SQL> CREATE PROCEDURE CHECK_EMPLOYEE_DETAILS (<argument(s)>) IS
BEGIN
    <code>
END;
/

SQL> exec CHECK_EMPLOYEE_DETAILS (<argument(s)>)
SQL> DROP PROCEDURE CHECK_EMPLOYEE_DETAILS;

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[stefanhei]

Zircon,
SantaMufasa provided exactly the code for what you asked.
If your goal is to execute some PL/SQL-code without having a permanent procedure for that task, an anonymous block may fit your needs better. Syntax is:

DECLARE
 ... -- variable definitions
BEGIN
 ... -- your code to check the details
END;
/

Stefan

 

[zircon06]

Thanks for santa!!!! and stefan