Hi Team, When I try to create a table using normal SQL statement it works, but when I do same in PLSQL code it gives insufficient privilege error .Please assist.
create or replace procedure soap_call_update3 is
SQL_ST2 VARCHAR2 (4000 CHAR);
BEGIN
SQL_ST2 := 'CREATE TABLE DISTINV.PRE_TEMP (id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY START WITH 1 INCREMENT BY 1,
PART_ID VARCHAR2(150 CHAR),PART_ID_QUALIFIER VARCHAR2(150 CHAR))';
EXECUTE IMMEDIATE SQL_ST2;
end;
Error report -
ORA-01031: insufficient privileges
ORA-06512: at "DISTINV.SOAP_CALL_UPDATE3", line 8
ORA-06512: at line 1
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges