do you have encryption turned on between the links ? this could be your issue as well. I have seen a required on one side and a requested on the other.. cause issues..
On 4/2/08, patrick zandi <[EMAIL PROTECTED]> wrote: > > 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... -- 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"
