You need more than just the plan to see what Oracle is actually doiing; use 'set autotrace on' and execute the query again and you'll see...
Why does the same user have BOTH public and private database links? That makes no sense. The owner will always use the private link and since...
Provide create table statements and sample data.
Who owns the private database link? Only that user can access the private link; all others use the public link.
It's the tabletspace where the table is created. If that doesn't exist you need to change it to an tablespace that does exist.
It's global so any user that wants to use it can; simply grant them privileges on the stored procedure.
You an try this as SYS:
CREATE TABLE stats$error_log (
Share your code first.
Nothing is attached.
Use google.com and look for oracle 12c new features.
Restate your question so we can understand it.
This blog post describes how the two week numbering conventions in Oracle are defined, along with some other interesting information:
Where is your code?
Ask your instructor.
That won't work as you've discovered. You have two choices:
Replace the assignment statements with the script code in your PL/SQL block