...I don't understand this table

[stef]

I've got a simple table, but I don't get any support for this table.
The name of the table is basesph, is this maybe the problem.

I get no support with F6, no discription. If I set this table as type, i get no F6 support either.

In the browser window I will get all support ?!?!?#$%
Any idees ;-)

 

[Marco Kalter]

Can you show me an example of the SQL or PL/SQL text where you press F6 to describe the table?

 

[stef]

select BS.IDBASESPH,
BS.IDCLASSIFICATION,
BS.DESCRIPTION_1,
from BASESPH BS;

When I now select the text "BASESPH" right click, and I want to get the description of the table. The option is not available.
Strange is that I've got the option "Disable".

F6
I found out now why I got no result with the F6 key. I had a test script. In this test script i declared a function, after adding the function, you can not use the F6 key for the rowtype.

example:
updBs basesph%rowtype;
nResult number;

function CreateNewSphText(
vcLang sprachtext.idsprache%type,
vcText sprachtext.text%type
) return number is
bla bla
...
...

-- Next begin
begin

-- Test statements here
bs_init.BS_initIns ( io_rec => updBs ) ;
updBs.

 

[Marco Kalter]

Which object type do you see when you right-click on BASESPH and select "Properties" from the popup menu?

 

[stef]

okay, today I met my table basesph.

this is the property info:

CONSTRAINT_NAME BASESPH
CONSTRAINT_TYPE P
TABLE_NAME BASESPH
STATUS ENABLED
DEFERRABLE NOT DEFERRABLE
DEFERRED IMMEDIATE
VALIDATED VALIDATED
GENERATED USER NAME
LAST_CHANGE 11.09.2008 13:28:39

INDEX_NAME BASESPH

 

[Marco Kalter]

It seems that you also have a constraint named BASESPH. For some reason this constraint object takes precedence over the table object. We'll enhance this.

 

[stef]

thx a lot
i will, for the time being, changing my constraint to a diffrent name