Skip to Content
avatar image
Former Member

SAP Syclo Agentry + Oracle Backend (Complex Table)

Hello All , I am working on syclo agentry frontend and oracle as backend . But when i try to write query for complex table then its throwing error like Error 931 : ORA-00931 : missing identifier My query syntax is below : << if rebuild " select (first select query) " " Insert (second insert query) " else " select (first select query) " " Insert (second insert query) " >> When i run first time then if part is working but second time onwards after else its throwing error Error 931 : ORA-00931 : missing identifier But same query is working in MS SQL backend can you suggest ? What are need to change in syntex as oracle backend ? Thanks & Regards, Kunal Varaiya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 11, 2014 at 03:38 PM

    Kunal,

    MS SQL and Oracle SQL syntax can be different depending on your query.  You don't need to change the Agentry flunky syntax tags at all when moving between databases, but you do need to make sure that when Agentry expands your flunkies, you have a valid query that will run against your specific database.  Turn on logging and examine the server or user or backend log to see the actual query that Agentry was attempting to send to Oracle.  It will probably be obvious what is wrong.  Try copying the query out of the log and running it through an Oracle client to debug the query if the syntax problem in not obvious.

    Jason Latko - Senior Product Developer at SAP

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Steve , I will try today in and make confirm . reason is to make delta thats why i am using two scripts in if as well as  in else condition . Because i dont have rights to make triggers in back end system . Thanks & Regards, Kuanal Varaiya