An error occurred while executing a stored procedure: ORA-01031: insufficientprivileges. Debug the stored procedure and find that an error occurs when the stored procedure runs to create a table.
An error occurred while executing a stored procedure: ORA-01031: insufficient privileges. Debug the stored procedure and find that an error occurs when the stored procedure runs to create a table.
An error occurred while executing a stored procedure: ORA-01031: insufficient privileges.
Debug the stored procedure and find that an error occurs when the stored procedure runs to create a table, that is, you do not have the permission to create a table ,, however, the user who actually executes the stored procedure has the permission to create a table. After obtaining a solution on the internet, add the following content to the stored procedure: Authid Current_User, the modified stored procedure structure is as follows: