Topic
1 reply Latest Post - ‏2012-06-04T16:04:59Z by LuchoT
LuchoT
LuchoT
2 Posts
ACCEPTED ANSWER

Pinned topic Error DBALIAS for Oracle 10.2

‏2012-05-31T15:17:51Z |
Hello,
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:

CREATE PROCEDURE
CREATE TABLE
CREATE SESSION
UNLIMITED TABLESPACE
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.

Thanks.
Updated on 2012-06-04T16:04:59Z at 2012-06-04T16:04:59Z by LuchoT
  • LuchoT
    LuchoT
    2 Posts
    ACCEPTED ANSWER

    Re: Error DBALIAS for Oracle 10.2

    ‏2012-06-04T16:04:59Z  in response to LuchoT
    Solved

    I found more details about this error in the file PR0CNFG.010:

    SQLText: BEGIN
    cliente.PSTO01V0100_CSSSPCMGT.PSTV0100_CSSGETSIGNATURE(:RowsToGet,:SignToken); END;
    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:
    User: Customer
    Table: Customer
    I Created a DBALIAS with another user that no has a object with the same name of the schema.
    I Hope this helps.