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: comments in-line

Re: comments in-line

From: Andreas Zimmermann <Zimmermann_at_Lippmann-Soldan.de>
Date: Sun, 13 Jun 2004 23:32:03 +0200
Message-ID: <xn0djhhy08kdq58000@news.t-online.de>


hi daniel,

first thx for your quick answer and also thx for your nice words about the prearrangements of my first posting ... ;)

back to your inline comments, i have some additional notes or questions:

  1. i logged on to db before trying to load the form into forms developer, it's the right db (which works with compiled forms application without any so far shown errors) and the user has, as mentioned, all rights that he should need (oracle dba, application dba, application user + some additional roles i gave him cause i thought exactly that would be one of the probs) ... so last thing is the instance that you considered to be not set up correctly - could you maybe please give me a hint what could be the instance's prob (so that i know at least the direction i have to search in) ?!
  2. so far i think that the form i try to overwork is the main form of that application, but i will check in office tomorrow wether i'm wrong (and you're right) or not ... is there any hint or distinctive mark for such 'main forms' ?!
  3. you talk of a hard-coded directory ... where could that be hard coded - in the form or (more likely as far as i understood you) the .pll itself ?!

thx again for any help - i hope i'm not too annoying ...

kind regards

Andreas Zimmermann

---

Daniel Morgan wrote:


> Comments in-line
>
> Andreas Zimmermann wrote:
> > hi all,
> >
> > first of all, i'm new to this newsgroup stuff, so if there is
> > anything wrong in style, language or whatever - forgive me pls and
> > help my anyways ... ;)
> >
> > i'm an intern doing oracle & network administration plus oracle
> > forms & report development atm (i'm ocp dba and have experience in
> > db development too but am a newbie to oracle forms & reports) -
> > just to introduce myself.
> >
> > recurrencing to my prob, here is the setup i use in office ...
> >
> > laptop comp: x86 family 6 model 8 stepping 3 with 256 mb ram, OS:
> > Win 2k vers. 5.00.2195, SP 2 including hotfixes
> >
> > oracle server: 8.1.7.0.0
> > oracle forms: 6.0.8.23.2
>
> Already you have done better than many that should know better.
>
> > both on same machine for development
> >
> > i have to make some changes to a running custumer's form including a
> > new menu item and a new form plus db changes & stuff - and here my
> > problem starts:
> >
> > on form load existing .fmb into forms builder i get following msgs
> > ...
> >
> > - a bunch of tables / views could not be find (ORA-00942)
> >
> > - a bunch of objects could not be opened (FRM-18108)
> >
> > - a file could not be opened (FRM-10043)
>
> You are not logged onto the database,logged on as the wrong user, or
> logged onto an instance that is not set up correctly. Identify what is
> missing.
>
> > when i try to run the form then, there are some toolbars missing and
> > the positioning of the canvases is totally messed up - but the form
> > itself compiles without errors. seems some triggers and canvases are
> > missing (or invalid) ... :-/
>
> My suspicion is that objects have been inherited into the form from a
> master form. You need to open the master up first.
>
> > first i looked up oracle docs for error msgs, what obviously did not
> > really help me (guess you know what i mean if you ever looked that
> > up).
> >
> > then i checked db user and db itself for missing authorisations,
> > errors and stuff ... db is ok (at least the published version of the
> > aplication runs without any probs on it) and the user has all
> > rights on db (including oracle dba as well as application dba).
> >
> > after examining that i found out that there is a .pll library
> > attached to the form that is called 'reform.pll' so i figured that
> > the initial probs come from it (look at error msgs at the end),
> > might being corrupted or just in wrong path ... after recompiling
> > it (converted it to text and back to binary after checking for
> > obvious errors) and checking registry for path (forms60_path in
> > windows registry is set to directory where it is located) i started
> > the form again and it was still the same (also same on loading fmb
> > again).
> >
> > now i tried to detach and re-attach that .pll to the form but i
> > always got the following error msg:
> >
> > Attached Library Name
> >
> > C:\[path]\reform.pll
> >
> > contains a non-portable directory specification.
> >
> > Remove path ?
> >
> > Yes No
> >
> > no matter wether i remove it or not (tried out both) - the errors
> > still occur ... i browsed through some msg-boards to find something
> > about that, but didn't get anything but the path thingy i already
> > checked (see above) ... it also does not work if i copy the
> > mentioned pll into the directory where the form itself is located
> > (that's where it is located in runtime environment - checked that
> > out on phone with the customer).
> >
> > unfortunatley i'm the only one used to oracle on business ... none
> > of the original developers is within reach and the customer wants
> > the changes done - so i decided to post here and ask for help !
> >
> > does anyone have an idea what to do ?! thx in advance ...
> >
> >
> > kind regards
> >
> > Andreas Zimmermann
>
> Put the library in the directory that has been hard-coded in.
Received on Sun Jun 13 2004 - 16:32:03 CDT

Original text of this message

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