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.
This topic has been locked.
1 reply Latest Post - 2012-06-04T16:04:59Z by LuchoT
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 PostsACCEPTED ANSWER
Re: Error DBALIAS for Oracle 10.22012-06-04T16:04:59Z in response to LuchoTSolved
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.