30EA .. ORA-00906: missing left parenthesis when migrating procedure
SYBASE ...
DECLARE insert_cur CURSOR FOR
SELECT acct_type,acct_no FROM ln_acct where
(@LoanTypes in ('ALL','*') or charindex(','+rtrim(ln_acct.acct_type)+',' , ','+@LoanTypes+',') > 0) AND
(@LoanClasses in ('ALL','*') or charindex(','+rtrim(convert(varchar(10),ln_acct.class_code))+',' , ','+@LoanClasses+',') > 0)
is converted to
CURSOR insert_cur
IS SELECT acct_type ,
acct_no
FROM ln_acct
WHERE ( v_LoanTypes IN ( 'ALL','*' )
OR INSTR(',' || v_LoanTypes || ',', ',' || RTRIM(acct_type) || ',') > 0 )
AND ( v_LoanClasses IN ( 'ALL','*' )
OR INSTR(',' || v_LoanClasses || ',', ',' || RTRIM(CAST(class_code AS VARCHAR2)) || ',') > 0 );
where the translated IN clause in line AND ( v_LoanClasses IN ( 'ALL','*' ) gives the error