Have you tried creating a true Oracle view of the MSSQL and then creating the view form on that Oracle view Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Tuesday, January 30, 2007 11:57 AM To: [email protected] Subject: Error while creating a view form (ORA-00904) ** Hello List, I've set up a connection between ORACLE and MS SQL server using tg4msql. Now I'm trying to create a view form directly on the MS SQL table ([EMAIL PROTECTED]) After clicking on the "LOAD" button it shows me the list of fields and I choose the unique identifier. When I click the "CREATE" button it shows me the following error - Failure during SQL operation to the database : ORA-00904: "ROLEID": invalid identifier (ARERR 552). After switching on the sql logging I found an SQL statement, which fires this error - CREATE VIEW T3294 (C1) AS SELECT RoleID FROM [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> I tried to input the same statement using SQL'plus - it really fires Oracle error - ORA-00904: "ROLEID": invalid identifier At the same time if I type RoleID in quotes it works - SELECT "RoleID" FROM [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Anybody knows a workaround for this. Thank you. PS: I need this view form in order to be able to modify data in MS SQL tables. PPS: Our environment: ARS 6.3.16 on Oracle 9.2.0.7 on MS Windows 2003 + MS SQL 2000 (8.0.818) Kind Regards / C уважением Dmitry Bezhenar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
