Live ORACLE

if you are Oracle Developer ,than this Blog most likely will make you happy.

About my Blog

This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.

About Me

I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.

Specifying Invoker's Rights With a Procedure

Posted on 12:53:00 AM No Comments
Labels: 


CREATE OR REPLACE PROCEDURE Create_dept

     (v_deptno  NUMBER,

      v_dname   VARCHAR2,

      v_mgr     NUMBER,

      v_loc     NUMBER)

AUTHID current_user

AS

BEGIN

  INSERT INTO departments

  VALUES     (v_deptno,

              v_dname,

              v_mgr,

              v_loc);

END;

/


CALL create_dept(44, 'Information Technology', 200, 1700);


Share/Save/Bookmark

0 comments:

Post a Comment



Newer Posts Older Posts Home Page
Subscribe to: Post Comments (Atom)
 
http://www.dpriver.com/images/sqlpp-banner-2.png

Thanks for reading my Blog ... you Visitor Number :-