Variable parameter in Apex
708558Jun 24 2009 — edited Jun 25 2009Hi All
I am planning to pass more than 1 parameter to the SQL through one field and use this in "IN" Statement.
E.g.
SQL => Where Account number IN (:P50_ACNO)
Parameter Passed => '1234', '4567'
I am able to do this in TOAD by specifying &P50_ACNO but when I use '&' sign in APEX I am getting the following error message.
report error:
ORA-01008: not all variables bound
My idea is to declare one text field and pass more than one values through it.
Can you please help.