Run Instant with Break Lines Getting Invalid Package

Question

I’m creating a package dynamically:

DECLARE
  vpackageletras VARCHAR2(2000);
  vvalorpossuia  VARCHAR2(10);
  vvalorpossuib  VARCHAR2(10);

BEGIN

  IF letras.possuia THEN
    vvalorpossuia := 'TRUE';
  ELSE
    vvalorpossuia := 'FALSE';
  END IF;
  IF letras.possuib THEN
    vvalorpossuib := 'TRUE';
  ELSE
    vvalorpossuib := 'FALSE';
  END IF;

  vpackageletras := 'CREATE OR REPLACE PACKAGE letras AS' || CHR(13) ||
                    '  possuiA    CONSTANT BOOLEAN NOT NULL := ' || vvalorpossuia || ';' || CHR(13) ||
                    '  possuiB    CONSTANT BOOLEAN NOT NULL := ' || vvalorpossuia || ';' || CHR(13) || 
                    'END letras;';
  EXECUTE IMMEDIATE vpackageletras;
END;

This if I want to add a new CONSTANT I just add it down, for example, the possesC, and I guarantee that I will not lose the data that already exists in the PACKAGE.

However when running this script a package letters is invalid, and editing via PLSQL and running is valid.

Answer 1

I was thinking the problem was the line breaking, so I sought alternatives for this, instead of using CHR(13) I used CHR(10)

Chr(13) = Avanço de linha = Line Feed
Chr(10) = Retorno de Carro = Carriage Return

so Package is no longer Invalid.

Thank you very much.