Hello everybody,

I'm new to Oracle, come from a PostgreSQL /Python environment, and I'm
following a training in Oracle / Designer etc. (mostly self-study).

I have a problem in Designer. It seems that when it wants to store
information about diagrams I make a database error occurs. I found
this link
http://forums.oracle.com/forums/thre...633&tstart=105
but there isn't any mention of a solution.

Does anyone know how to solve this, or how I can get access to Oracle
bugs? TIA!

On 15 Jan 2008 09:03:59 GMT, Joolz <root (AT) localhost (DOT) localdomain.invalid> wrote:
Some extra info:

- it seems that the name of the element should be unique, not only in
a diagram but also across different types (eg ER and process)
- it happens not only when I make diagram entities, but also attributes

On 15 Jan 2008 09:03:59 GMT, Joolz <root (AT) localhost (DOT) localdomain.invalid> wrote:
Some extra info:

- it seems that the name of the element should be unique, not only in
a diagram but also across different types (eg ER and process)
- it happens not only when I make diagram entities, but also attributes

On 15 Jan 2008 09:03:59 GMT, Joolz <root (AT) localhost (DOT) localdomain.invalid> wrote:
Some extra info:

- it seems that the name of the element should be unique, not only in
a diagram but also across different types (eg ER and process)
- it happens not only when I make diagram entities, but also attributes

On 15 Jan 2008 09:03:59 GMT, Joolz <root (AT) localhost (DOT) localdomain.invalid> wrote:
Some extra info:

- it seems that the name of the element should be unique, not only in
a diagram but also across different types (eg ER and process)
- it happens not only when I make diagram entities, but also attributes

On 15 Jan 2008 09:03:59 GMT, Joolz <root (AT) localhost (DOT) localdomain.invalid> wrote:
Some extra info:

- it seems that the name of the element should be unique, not only in
a diagram but also across different types (eg ER and process)
- it happens not only when I make diagram entities, but also attributes

On 15 Jan 2008 09:03:59 GMT, Joolz <root (AT) localhost (DOT) localdomain.invalid> wrote:
Some extra info:

- it seems that the name of the element should be unique, not only in
a diagram but also across different types (eg ER and process)
- it happens not only when I make diagram entities, but also attributes

On 15 Jan 2008 09:03:59 GMT, Joolz <root (AT) localhost (DOT) localdomain.invalid> wrote:
Some extra info:

- it seems that the name of the element should be unique, not only in
a diagram but also across different types (eg ER and process)
- it happens not only when I make diagram entities, but also attributes

Joolz wrote:
State your version of Designer (5 digits - not Designer 10G),
and the version of database, you have your repository in.

Bugs can be accessed through metalink, the oracle support site.

The thread you mention, has:
- a workaround
- a bug number

Another workaround would be to run the following as
repository owner:
update ci_diagrams
set title = substr(title, 1, 40),
name = substr(name, 1, 40),
author = substr(author,1, 30)
where length(title) > 40
or length(name) > 40
or length(author) > 30
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

Joolz wrote:
State your version of Designer (5 digits - not Designer 10G),
and the version of database, you have your repository in.

Bugs can be accessed through metalink, the oracle support site.

The thread you mention, has:
- a workaround
- a bug number

Another workaround would be to run the following as
repository owner:
update ci_diagrams
set title = substr(title, 1, 40),
name = substr(name, 1, 40),
author = substr(author,1, 30)
where length(title) > 40
or length(name) > 40
or length(author) > 30
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up