Empty Bind_Param In A DB XML Leads To Upload Failure (Doc ID 1448609.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

1. When trying to upload a db.xml file, that has a missing Bind_Parm, the upload fails with the error :

DatabaseError error: ORA-00936: missing expression Failed sql statement: (update SAVED_QUERY set INSERT_USER = '<VALUE1>',UPDATE_DATE = '<DATE TIME>',SQL_FIND_ALL = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid',UPDATE_USER = '<VALUE1>',INSERT_DATE = '<DATE TIME>',SAVED_QUERY_GID = '<VALUE2>',USE_IN_FINDER = 'N',BIND_PARAM = ,DOMAIN_NAME = '<DOMAIN>',SAVED_QUERY_XID = '<VALUE2>',QUERY_NAME = 'glog.server.query.order.OrderReleaseQuery',USER_QUERY_NAME = '<VALUE2>',IS_CONDITION = 'Y',IS_HIDDEN_FOR_MILESTONES = 'N',SQL_CHECK_ONE = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid' where SAVED_QUERY_GID = '<VALUE2>' ) Failed python exec: (c.execute("update SAVED_QUERY set INSERT_USER = '<VALUE1>',UPDATE_DATE = '<DATE TIME>',SQL_FIND_ALL = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid',UPDATE_USER = '<VALUE1>',INSERT_DATE = '<DATE TIME>',SAVED_QUERY_GID = '<VALUE2>',USE_IN_FINDER = 'N',BIND_PARAM = ,DOMAIN_NAME = '<DOMAIN>',SAVED_QUERY_XID = '<VALUE2>',QUERY_NAME = 'glog.server.query.order.OrderReleaseQuery',USER_QUERY_NAME = '<VALUE2>',IS_CONDITION = 'Y',IS_HIDDEN_FOR_MILESTONES = 'N',SQL_CHECK_ONE = 'select order_movement_gid from order_movement where order_release_gid = $GID and perspective = ''B'' order by order_movement_gid' where SAVED_QUERY_GID = '<VALUE2>' "))

When removing/populating data in the bind_param field on the xml, the error does not occur and the transmission is 'successful', but the data is not inserted into the db.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.