Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle forms 4.5 prob (eventually db link / synonym)

Re: oracle forms 4.5 prob (eventually db link / synonym)

From: Andreas Zimmermann <newsgroup.reply_at_online.de>
Date: Thu, 10 Feb 2005 13:01:53 +0100
Message-ID: <cufier$e70$1@online.de>


hi,

just checked (cause OS / RDBMS) was not upgraded by me personally, so this is the detailed client's setup:

server: oracle 9i (9.2.0.1.0) on sun/solaris 9 (SunOS 5.9 Generic_112233-11 sun4u sparc sunw, ultra 250)

client: win2k with oracle forms 2000 (4.5.10.22.0) & reports application

should exclude your last mentioned source of error imo - or am i wrong ?!

kind regards

Andreas Zimmermann

Frank van Bortel schrieb:

> Andreas Zimmermann wrote:
> 

>> hi,
>>
>> well, not that i found it so far ... do you (or anyone) remember any
>> details on that (or might even hand me kindly a link or something
>> where i can look it up myself) ?!
>>
>> or maybe anyone with another idea ?!
>>
>> thx to you anyways and all others in advance ;-) !
>>
>> kind regards
>>
>> Andreas Zimmermann
>>
>> Frank van Bortel schrieb:
>>
>>> Andreas Zimmermann wrote:
>>>
>>>> hello,
>>>>
>>>> i have following problem:
>>>>
>>>> server: oracle 9i on sun/solaris
>>>> client: win2k with oracle forms 2000 (4.5.10.22.0)
>>>> & reports application
>>>> development environment : TOAD 7.5.2.0 on win2k
>>>>
>>>> additional information:
>>>>
>>>> on server there are two db instances running (orc1 & orc2) for two
>>>> customers which belong together in parts of their organization. both
>>>> instances are partly associated with each other by (a working)
>>>> database link via synonyms (e.g. both use the same customer table on
>>>> orc1 but each has own specific orders table in their belonging
>>>> instance).
>>>>
>>>> situation:
>>>>
>>>> we just migrated old oracle 8.1.7 db to 9i without severe problems
>>>> neither on db nor on apllication side (some views / triggers /
>>>> procedures to recompile, nothing great) ... after a few days of use
>>>> by the customers, there came up an oracle / forms error which reduce
>>>> me to despair over days (as you can guess by me posting here now
>>>> ~lol~).
>>>>
>>>> on ocr1 there is a table named 'status' which can be accessed from
>>>> orr2 via a public synonym (including mentioned db link which
>>>> definately works) ... table is quite simple, 4 colums, 1 PK nothing
>>>> else worth mentioning. when we now try to insert a row via our usual
>>>> form (as user of orc2 with apropriate rights to do so), there comes
>>>> up following forms error:
>>>>
>>>> FRM-40506: ORACLE error -- unable to check for record uniqueness.
>>>>
>>>> after looking up some information about that (FRM-40506, Cause:
>>>> Oracle Forms encountered a processing error while checking a
>>>> record's primary key items for uniqueness. The table associated with
>>>> the current block of the form does not exist, or you do not have
>>>> authority to access the table.) i tried to insert exactly the same
>>>> row data into that table as same db user from orc2 (using synonym /
>>>> db link) data via TOAD - which worked perfectly. from ocr1 the same
>>>> form also works without any problem within the application itself
>>>> (as proved).
>>>>
>>>> so what could be forms' problem here ?! and how to solve it ?! or is
>>>> it possibly a migration prob from 8.1.7 to 9i ?!
>>>>
>>>> any idea would be appreciated ... thx !
>>>>
>>>> kind regards
>>>>
>>>> Andreas Zimmermann
>>>
>>>
>>>
>>>
>>> You probably used a bug, which is now resolved (or vice versa,
>>> of course :) ). I do recall something with synonyms and
>>> db links.
>>> Is there a hint of a resolved bug in the installation mnl?
> 
> 
> Something else: network stacks. upgrade to 9iRel2? it might
> be your forms has some difficulties with that (being a V7 tool)
Received on Thu Feb 10 2005 - 06:01:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US