Dear Oracle-ers...
saya mau bikin table menggunakan procedure di dlm packages.. kurang lebih spt
ini :
create or replace package PKG_create_table is
procedure sp_create_table;
end PKG_create_table;
/
create or replace package body PKG_create_table is
procedure sp_create_table as
begin
execute immediate
'create table tb_02 as select * from tb_01';
end;
end PKG_create_table;
tp saat di-execute muncul ora-01031 : insufficient privileges..
sedangkan saat script ini :
begin
execute immediate
'create table tb_02 as select * from tb_01';
end;
saya execute secara manual, tabel bisa di-create dengan sukses.. knp ya..??
utk role privileges user db yg bersangkutan, sudah di grant utk 'dba'
thanx before for your help...
[Non-text portions of this message have been removed]
