Re: Copy objects in Oracle froms 3.0

noel cronin (ncronin_at_unix1.tcd.ie) wrote:
>
> Can anybody enlighten me with regard to copying Oracle objects?
> When I load a form (using .inp file only) and try to copy an
> object such as a trigger from another .inp file, SQL*forms tells me that the
> object was not found. We need to copy blocks/triggers etc. Has anybody
> had problems doing this ?
>
You have to save the form that you want to copy from to the database then grant access to that form to the users that may want to copy anything from it.
I still subscribe to the 'dont save a form to the database' idea in most circumstances but for this I have a special reference form which contains the stuff I may want to copy/reference and do save that.

Hope this helps

Ian

-- 
_________________________________________________________________
  EMAIL =---> idixon_at_infocom.co.uk (Ian Dixon)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~