SELECT
  s.schemaName,
  CASE
    WHEN t.localizedText IS NULL 
    THEN s.schemaName 
    ELSE t.localizedText 
  END AS schemaDisplayName,
  s.schemaText,
  s.schemaType
INTO
  :schemaName,
  :schemaDisplayName,
  :schemaText,
  :schemaType
FROM
  DataStoreSchema s LEFT OUTER JOIN DataStoreSchemaTranslation t 
  ON t.schemaName = :schemaName 
  AND t.type = :type
  AND t.localeIdentifier = :localeIdentifier
WHERE
 s.schemaName = :schemaName 
ORDER BY schemaDisplayName ASC