Designer 2000 package generation problem

From: Eric Janzen <ejanzen_at_telusplanet.net>
Date: Fri, 22 Oct 1999 20:01:12 GMT
Message-ID: <co3Q3.7534$Y6.738731_at_news1.telusplanet.net>

Hi there,

We are experiencing the following using Designer 2000 6.0.3.1.0

We create a package under the Package Definitions node We create a datastructure of type PL/SQL table and base it on a column in the database.
We then create a variable and base it on the datastructure we just created.

When we generate, it comes up like this:

TYPE T_GIVENNAME2_TYPE IS TABLE OF PERSONS.GIVEN_NAME_2%TYPE INDEX BY BINARY_INTEGER;

• Program Data T_GIVENNAME2 .T_GIVENNAME2_TYPE;

See the period in the line right under "Program Data". this causes compilation errors.

Why/How does the designer put this in???

Eric Janzen
E. Janzen Consulting
Edmonton, Alberta, Canada Received on Fri Oct 22 1999 - 22:01:12 CEST