Using a Parameter value in an Oracle case statement

Question

I am trying to pass a parameter value in my case statement as below

CASE WHEN b.Billing_code IN  ('Audio_And_Others') THEN [:Audio_Comm_Percentage] END AS Commission_Rate

My Parameter being [:Audio_Comm_Percentage] and will be set as a decimal number e.g. 0.12 or 0.05 etc.

I am getting a "missing expression" message when I run this

Answer 1

等待大神答复