I’m ready for a nap

Proper Syntax for an Oracle SQL Expression, passing in User.Identity.Name

For a hidden field, I am attempting to 'weld' the Account_ID of the currently logged in user, to an Account_ID field. Taking into account the uppercase situation with Oracle, I am attempting to use the following code:

ACCOUNT_.ACCOUNT_ID in (Select ACCOUNT_ID from URO_PP_ACCOUNTS where USERNAME = '{Context.User.Identity.Name}')

(the command references this table with an ACCOUNT_ prefix)

Testing this in Oracle SQL Developer with 'admin' instead of {Context.User.Identity.Name}, it doesn't return errors - but when I try to generate and run this, I am getting the following error.

What syntax should I use for this (or is it even possible?)

Component: ctl00_PageContentPlaceHolder_view1Extender
Controller: URO_PP_MESSAGES; View: grid1; Timed out: false
Exception: Oracle.DataAccess.Client.OracleException
Message: ORA-00907: missing right parenthesis
Stack:
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at OSP.Data.TransactionManager.ExecuteReader(PageRequest request, ViewPage page, DbCommand command)
at OSP.Data.DataControllerBase.OSP.Data.IDataController.GetPage(String controller, String view, PageRequest request)
at OSP.Services.DataControllerService.GetPage(String controller, String view, PageRequest request)
1 person has
this question
+1
Reply