prog:oracle_accessible_by_12c
no way to compare when less than two revisions
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
— | prog:oracle_accessible_by_12c [2018/06/29 14:36] (aktuell) – angelegt gpipperr | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | =====Oracle PL/SQL - mit " | ||
+ | |||
+ | |||
+ | **Aufgabe: | ||
+ | |||
+ | |||
+ | <fc # | ||
+ | |||
+ | Beispiel Code: | ||
+ | <code plsql> | ||
+ | |||
+ | |||
+ | ------------------- | ||
+ | |||
+ | |||
+ | create or replace procedure execute_proc | ||
+ | | ||
+ | is | ||
+ | begin | ||
+ | | ||
+ | end; | ||
+ | / | ||
+ | |||
+ | |||
+ | ------------------- | ||
+ | |||
+ | SQL> exec execute_proc | ||
+ | BEGIN execute_proc; | ||
+ | |||
+ | * | ||
+ | ERROR at line 1: | ||
+ | ORA-06550: line 1, column 7: | ||
+ | PLS-00904: insufficient privilege to access object EXECUTE_PROC | ||
+ | |||
+ | |||
+ | ------------------- | ||
+ | |||
+ | |||
+ | create or replace procedure call_proc | ||
+ | is | ||
+ | begin | ||
+ | execute_proc; | ||
+ | end; | ||
+ | / | ||
+ | |||
+ | |||
+ | ------------------- | ||
+ | |||
+ | SQL> set serveroutput on | ||
+ | |||
+ | SQL> exec call_proc; | ||
+ | -- Info :: Procedure execute_proc executed | ||
+ | |||
+ | PL/SQL procedure successfully completed. | ||
+ | |||
+ | </ | ||
+ | |||
+ | Nun kann execute_proc nur noch von der Procedure call_proc aufgerufen werden. | ||
+ | |||
+ | Aber! Beachten! | ||
+ | |||
+ | Aus der Doku: | ||
+ | <code bash> | ||
+ | The ACCESSIBLE BY clause allows access only when the call is direct. The check will fail if the access is through static SQL, DBMS_SQL, or dynamic SQL. | ||
+ | </ | ||
+ | |||
+ | |||
+ | ---- | ||
+ | |||
+ | |||
+ | ==== Quellen ==== | ||
+ | |||
+ | * Oracle Doku => https:// | ||
+ | |||
+ | |||
prog/oracle_accessible_by_12c.txt · Zuletzt geändert: 2018/06/29 14:36 von gpipperr