Plex 2E

  • Private Community
Back to discussions
Expand all | Collapse all

SQL Exec not working - Looking for Stored Procedure

  • 1.  SQL Exec not working - Looking for Stored Procedure

    Posted Aug 20, 2015 09:50 AM

    I have been using the SQL Exec command in JAVA with no problem up until now. Based on my original post on how to use it https://communities.ca.com/message/241718940#241718940

     

    I now get the error

     

    • The name 'SELECT L1.ROWID_TABLE, L1.TABLE_NAME , L1.ROWID_PARENT, L1.DISPLAY_NAME FROM C_REPOS_TABLE L1' is not a valid identifier. SP=?

     

    The output fields are in the same sequence as the view it is built over.

     

    I know this does work, but cant figure out why it doesn't anymore



  • 2.  Re: SQL Exec not working - Looking for Stored Procedure

    Posted Aug 23, 2015 03:56 PM

    can you attach the generated source?



  • 3.  Re: SQL Exec not working - Looking for Stored Procedure

    Community Manager
    Posted Aug 31, 2015 01:53 PM

    Gavin, were you able to work out a solution to your problem?