Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1
- zalogować na użytkownika BBD_nazwisko
- 2
- Zawrappować procedurę
- wrap iname - PROC2.sql oname - PROC2.plb
- W SQL*PLUS
- @PROC2.plb
- Sprawdzić kod procedury
- SELECT line, text FROM USER_SOURCE
- WHERE name = 'PROC2' order by line;
- 3
- CREATE OR REPLACE PROCEDURE PROC2...
- EXECUTE PROC2...;
- SELECT line, text FROM USER_SOURCE
- WHERE name = 'PROC2' order by line;
- Czy nadal jest zawrapowana?
- 4
- SELECT DBMS_DDL.WRAP('create or replace function2(p1 NUMBER)...end;')
- FROMDUAL;
- 5
- BEGIN
- DBMS_DDL.CREATE_WRAPPED('CREATE OD REPLACE
- PACKAGE BODY Pakiet3 AS ..... END;')
- END;
- SELECT TEXT FROM USER
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement