Knowledge Base

component ‘SET_NO_OUTLINES’ must be declared

Posted Nov 19 2010 by Wim Jans in  with 3 Comments

When exporting data from a database, you receive following error:

EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 41:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully

You are probably using another version of the export tool than the version of the database.

For instance, you use the Oracle 10g export tool to export a schema from an Oracle 9i database.



The export tool of Oracle contain some version specific code.

In this case, the export tool is executing a procedure at connect time (set_no_outlines) which does not exist on an Oracle 9i database.



It is good practice to keep the version of the Oracle client tools and database in sync.



This problem will disappear if you use the Oracle 9i version of the export tool.


Tags: , , , Categories: 

Popular Posts

Related Posts

  • The_Medeiros

    I´m using 9i Database with 10.2 client and found this big bull s… error “6550″. The incredible is how a new client version can´t connect on the older DB. Pls Oracle Developer Team, try to do as Microsoft did and turn our life more easy. Tks and Rgrds

  • Jeff

    I get this error, the systems are running windows 7 x64. I cannot find a client version of oracle running on windows 7 x64 platform so I need to have the newer releases (wich is 10gR2). Can I somehow use this export tool of oracle 9i in the source code of my oracle 10gR2?

    • http://dbmotive.com/ Wim Jans

      This is not possible, the version of the export tool must match the version of the database.
      You cannot use a higher or lower version of a client export tool

Oracle Gold Partner DbMotive is an Oracle Gold Partner