Re: FRM-41003
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 14 Nov 2003 14:35:27 -0800
Message-ID: <1068849349.797019_at_yasure>
>
>
> "FRM-41003: This function cannot be performed here."
>
> OK - Apologies - I was assuming that if FRM-41003 meant nothing to the
> reader then they probably would be unable to help.
>
> The Oracle Forms Error Messages book suggested the control block, but
> Forms itself hinted at the fact that the table may not exist. Neither
> of which are true (honest). The same user in SQL*Plus can describe
> and issue statements against the tanle in question. And it's in the
> Database Objects section of Forms.
>
> The table name and columns are correctly spelt and the block/item
> properties are seemingly set for a database data block, not a control
> block. This error occurs irrespective of which text item I issue
> ENTER_QUERY from (or any other DML built-in).
>
> Shaun.
Date: Fri, 14 Nov 2003 14:35:27 -0800
Message-ID: <1068849349.797019_at_yasure>
Mr E Guest wrote:
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1068833309.278248@yasure>...
>
[Quoted] >>Mr E Guest wrote: >> >>>Forms, Shmorms... >>> >>>So, I've got a database block based on a table in Forms 6i. The >>>Database properties appear to be fine. The user has access to the >>>table. All the items are database data items and the block itself is >>>a database data block. >>> >>>Why, then, do I get FRM-41003? (which suggests the block is a control >>>block). >>> >>>Maybe it's the alcohol abuse... >>> >>>Shaun. >> >>Why do you assume a 41003 means it is a control block? In fact why >>do you assume that 41003 is a valid error message from which we can >>help you? ;-) >> >>Please repost the exact error message with text.
>
>
> "FRM-41003: This function cannot be performed here."
>
> OK - Apologies - I was assuming that if FRM-41003 meant nothing to the
> reader then they probably would be unable to help.
>
> The Oracle Forms Error Messages book suggested the control block, but
> Forms itself hinted at the fact that the table may not exist. Neither
> of which are true (honest). The same user in SQL*Plus can describe
> and issue statements against the tanle in question. And it's in the
> Database Objects section of Forms.
>
> The table name and columns are correctly spelt and the block/item
> properties are seemingly set for a database data block, not a control
> block. This error occurs irrespective of which text item I issue
> ENTER_QUERY from (or any other DML built-in).
>
> Shaun.
This error message is very generic and does not indicate anything about the funtion being attempted nor do you indicate what the user is doing when they get the message? Query? Insert? Update? Delete? Are there any procdures or functions or LOVs with a record group? involved? Did it ever work? What was changed?
Can you provide some specifics? I'd like to help you but I am still very unclear about what is going on.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Nov 14 2003 - 23:35:27 CET