Dmitry, You could try creating a local view object in the ARS DB. Have the view do all of the "fancy DB LINK stuff". This way ARS only sees a simple table and does not have to do anything special to select/update the "linked table".
-- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 11/27/06, Bezhenar, Dmitry <[EMAIL PROTECTED]> wrote:
** Hi List, I've created a link from Oracle on Solaris to MS SQL database using one additional Oracle-on-Windows server (with tg4msql installed). Now I can make SQL requests to MS SQL database from sqlplus - for example, select * from <Tablename>.<DBlink-name>; Now I need to create a view form in Remedy Administrator. There is a statement in Basic manual that I should use the following format for the table name - [EMAIL PROTECTED] Whatever I try to input here the following error occurs - Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). Should I do anything else with a DBLink? Thank you. Kind Regards / C уважением Dmitry Bezhenar
