I'm trying to create DB ALIAS for Oracle 10.2 with Optim 8.1
The user I'm using in Oracle has this privileges:
SELECT ANY DICTIONARY
But when finished to config, I get this error:
ORA-06550: line 1, column 38:
PLS-00302: component 'PSTO01V0100_CSSSPCMGT' must be declared
ORA-06550: line 1, column 30:
I attached a screenshot.
Any help will be appreciated.
Pinned topic Error DBALIAS for Oracle 10.2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-04T16:04:59Z at 2012-06-04T16:04:59Z by LuchoT
LuchoT 270004S6SF2 Posts
Re: Error DBALIAS for Oracle 10.22012-06-04T16:04:59ZThis is the accepted answer. This is the accepted answer.Solved
I found more details about this error in the file PR0CNFG.010:
ErrData: ORArc=6550, OpSysErr=0, ParseErrOffset=0
ErrMsg: ORA-06550: line 1, column 38: PLS-00302: component 'PSTO01V0100_CSSSPCMGT' must be declared ORA-06550: line 1, column 30: PL/SQL: Statement ignored
This happened because exist a syntax error;
The oracle user has a object (table) with the same name of the schema:
I Created a DBALIAS with another user that no has a object with the same name of the schema.
I Hope this helps.