Just create a view on the db side, create a dblink, then create a synomn on the ars side. Test link.. select * from synonm... ( I know I cannot spell .. ;-) then create a view form.. watch out of Date fields.. and use an escalation or a filter to write back..
voila .. works great.. been doing this for years.. .. Day 1 since the view form came out.. Hope that helps.. ARS DB ARS VIEW ~~> Synonmn ~~> DBlink ~~> View of tables ~~> Tables test your link ! On 4/2/08, Brian Goralczyk <[EMAIL PROTECTED]> wrote: > > ** I queried the error on google and came up with a bit from someone > else. The amusing part is that they state that Oracle claims that the error > doesn't happen in 10g which caused me to immediately check and notice you > are on. So I file that under interesting. > > Personally, I would first make the database view in your database to the > one that you are connecting. Make sure that everything works that way. > Then you have the choice of either creating the view form and attaching to > your view or attempting to create the same process that your view is > creating. One note of caution. If you create your view, you CAN NOT use > the same name as the view form. And vice versa, you CAN NOT create a view > form with the same name as a view that was created in the database. Remedy > tries to create a database view to match the form and errors out. > > I have included the piece that the individual wrote, mostly cause it > amuses me with the contridiction. It came from this site.. > http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm > > " > > The Oracle docs note this on the ora-00904 error*: > > > > *ORA-00904 string: invalid identifier* > *Cause:* The column name entered is either missing or invalid. *Action: > * Enter a valid column name. A valid column name must begin with a letter, > be less than or equal to 30 characters, and consist of only alphanumeric > characters and the special characters $, _, and #. If it contains other > characters, then it must be enclosed in double quotation marks. It may not > be a reserved word. > > *According to Oracle documentation, ORA-00904 does not occur in Oracle 10g > > When ORA-00904 occurs, you must enter a valid column name as it is either > missing or the one entered is invalid. > > To avoid ORA-00904, column names cannot be a reserved word, and must > contain these four criteria to be valid: > > - begin with a letter > - be less than or equal to twenty characters > - consist only of alphanumeric and the special characters ($_#); > other characters need double quotation marks around them > > Another important factor in correcting ORA-00904 is remembering to run > catproc.sql > > You can also check your trace file to find the particular error which is > causing the ORA-00904 to occur. " > > On Wed, Apr 2, 2008 at 3:37 PM, Pierson, Shawn <[EMAIL PROTECTED]> > wrote: > > > ** > > > > What I've had to do in the past in a similar situation is to have the > > view form referencing a view on my DB that was using a linked server. If > > you get that part, you can at least see the data. > > > > > > > > However, if you have issues modifying or submitting the data, > > unfortunately the next best solution is to build active links on buttons > > that run SQL commands for insert and update. > > > > > > > > Thanks, > > > > > > > > Shawn Pierson > > > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Gary Dries > > *Sent:* Wednesday, April 02, 2008 2:14 PM > > *To:* arslist@ARSLIST.ORG > > *Subject:* Issues with building a view over a DB Link > > > > > > > > ** > > > > I have created a Oracle (10g) to MSSQL (2003) dblink, I am able to > > create the view, but I get sever fields that retrun the error > > > > "Failure during SQL operation to the database : ORA-00904: "ADDRESS1": > > invalid identifier (ARERR 552)." > > We are researching several possible issues, such as permissions, and the > > build of the table that I am creating the view of. > > > > One suggetion I found searching the list is to create the view in Oracle > > to the SQL db and then create the Remedy view to the Oracle view. > > > > > > > > Is it possible to create a view from a view, and if it is, can the data > > in the SQL table be modifed from Remedy in this view of a view of a SQL > > table? > > -- > > Gary Dries > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > Private and confidential as detailed > > here<http://www.sug.com/disclaimers/default.htm#Mail>. > > If you cannot access hyperlink, please e-mail sender. > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > -- Patrick Zandi Dev Technology Group --> www.devtechnology.com Exceeding your Expectations ! By Design... _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
