Database migration to another server, PLSQL stored procedure execution error, stored procedure call is likely a SYS system package SYS. Dbms_snapshot (actually is not familiar to me about this, others write SQL), before also migrated to other test database server execution, there is no problem, now the executive to the fault, compile and no error,

CodePudding user response:

I can think on point only user permissions, may cause the cause of the oracle installation, SYS. DBMS_SNAPSHOT execute permission I already gave the current user, or compiler would be an error, I couldn't think of other reasons for a while,

CodePudding user response:

Shown above package there is no well,

CodePudding user response:

But I ordered in one layer, compile also normal, can enter SYS. DBMS_SNAPSHOT inside the package, also can see the insides of the bag is not familiar with oracle package at all, whether SYS. DBMS_SNAPSHOT package and call the other contents (call something does not exist or an error).

CodePudding user response:

Original package is made up by baotou root package body, like interfaces with interface implementation, I found that my inside a stored procedure call system bag, only in baotou no inclusions... As for what reason cause no inclusions I don't know, is the package system, I guess in baotou root package body should be installed automatically! Estimate is for this reason