Forum Stats

  • 3,827,131 Users
  • 2,260,743 Discussions
  • 7,897,181 Comments

Discussions

Oracle Designer CDD Error

user5815482
user5815482 Member Posts: 16
edited Aug 5, 2015 12:22PM in Designer

Please,

Trying to modify a PL/SQL procedure under Designer 10G produce the error bellow, I checked the connection's OK, any idea how to solve this issue, thanks in advance.

Message

-------

CDD-22202: An error occurred trying to store text.

Cause

-----

The logic was not saved to the Repository. The database could be

down or you could have lost your network connection.

Action

------

Export the logic to a file and try to save it again later.

--------------------------------------------------------------------------------

Best Answer

  • Mark Striekwold
    Mark Striekwold Member Posts: 442 Bronze Badge
    edited Jul 30, 2015 3:40PM Answer ✓

    What version of the database are you using? Colleagues of mine had trouble saving the pl/sql logic as well and were getting strange errors like "CDD-22202 An error trying to store text". They were using a versiioned repository. After downgrading to database 11.1.0.7 everything worked fine again inside the repository. So if you are using database 11gR2 or 12c change compatible to 11.1.0.7 in your DB.

Answers

This discussion has been closed.