Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS: 7.0.01
i wont to pull the data from the form which is present in the same database( as arsystem tablenamespace) under user sys(System tablenamespace) using remedy view forms using SQL query. my query in Remedy view form is "SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='ARADMIN' AND TABLE_NAME='T1' " when i am trying to load the columns its throwing error like "Failure during SQL operation to the database : ORA-00933: SQL command not properly ended (ARERR 552)." Please help in solving the issue. Regards, SQL -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677247.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"