I use query database operator for a PAM process, which is used for fetching certain list of data from mdb of CA Service Catalog.
I observe that the query space around 254 characteres but my query have more characteres, this is my query:
left join usm_subscription_detail ON usm_request.request.id = usm_subscription_detail.request_id and usm_subscription_detail.subscription_type=5
left join usm_request_item_form ON usm_subscription_detail.id=usm_request_item_form.subscription_detail.id
where usm_request.request_id= '" + Process.var_request_id + '""
where Process.var_request_id contain the number of request id in service catalog
Thanks for your help!! i need increase the character or simplify my query.
If i save the query in a variable but the before of the = i put a number of request_id, this query run OK but not is dinamic, the result of the query i save in the variable var_descripcion