Oracle Designer CDD Error

user5815482

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.

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

Mark Striekwold

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.

Mark Striekwold

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.

user5815482

I'm using Oracle Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bits.

What action I need to do to change the compatibility? under Oracle DB or Oracle Designer or elsewhere?

Thank you very much.

Mark Striekwold

Inside the Oracle DB and the statement looks something like: ALTER SYSTEM SET COMPATIBLE = '11.1.0.7.0' SCOPE = SPFILE;.

user5815482

I've altered the compatibility to 11.1.0.7 but when I restart the instance, I get the error :

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

It seems that this version isn't compatible

Mark Striekwold

According to the documentation on http://docs.oracle.com/cd/E11882_01/server.112/e23633/intro.htm the parameter should be in the range of 10.0.0.0.0 to 11.2.0.n.n.  So 11.1.0.7 should be a valid number. You could switch your setting back to 11.2.0 to check if the error with the listener disappears.

user5815482

What I've read, this option is just valid after an upgrade and also for versions lower than 11.2.

So I'm trying to install a brand new 11g release 1 database to see if I'll get rid of the CDD messages.

user5815482

Thank you very much Mr Mark, I installed Oracle DB 11gR1 and no more CDD errors.

Another question if you have some grasp of Forms, when I compile some PLL, I get errors about missing package/function : CG$FORM_ERRORS.RAISE_FAILURE.

Any Idea about this function or where it's included?

Mark Striekwold

CG$ refers to case generator which was the old name designer. The CG$FORMS_ERRORS is inside the designer library (OFGTEL) and you can find the designer libs inside cgenf61/admin folder.

user5815482

You're right, many thanks Mark.