SELECT EXTN_ATTRIBUTE_CHAR014 AS SCHOOL_NAME,
ORGANIZATION_NAME AS ACCOUNT_NAME,
ORGANIZATION_TYPE AS ACCOUNT_TYPE,
PARTY_NUMBER AS ACCOUNT_NUMBER
FROM HZ_ORGANIZATION_PROFILES org
WHERE :p_account_name IS NULL
OR ORGANIZATION_NAME IN (:p_account_name)
there is relational operator error for this
SELECT EXTN_ATTRIBUTE_CHAR014 AS SCHOOL_NAME,
ORGANIZATION_NAME AS ACCOUNT_NAME,
ORGANIZATION_TYPE AS ACCOUNT_TYPE,
PARTY_NUMBER AS ACCOUNT_NUMBER
FROM HZ_ORGANIZATION_PROFILES org
WHERE ORAGANIZTION_NAME IN (:p_account_name)
for this i am unable to generate all names records but can generate single name or multiple select values