1
I have a Package:
CREATE OR REPLACE PACKAGE LETRAS AS
possuiA CONSTANT BOOLEAN NOT NULL := TRUE;
possuiB CONSTANT BOOLEAN NOT NULL := TRUE;
possuiC CONSTANT BOOLEAN NOT NULL := TRUE;
possuiD CONSTANT BOOLEAN NOT NULL := FALSE;
possuiE CONSTANT BOOLEAN NOT NULL := FALSE;
possuiF CONSTANT BOOLEAN NOT NULL := FALSE;
END db1integra;
And though I would like to check in a select if there is a CONSTANT possesG, and if it exists then execute an action if it is TRUE if it is FALSE non-executive.
verification may be made in this way: (the script below does not work, I can not validate of a Non-constant that does not exist)
DECLARE
vsql VARCHAR(1000);
BEGIN
IF letras.possuig THEN
vsql := 'UPDATE EMPLOYEE
SET JOB = DEFAULT
WHERE EMPNO = ''000290''';
ELSE
vsql := 'UPDATE EMPLOYEE
SET JOB = DEFAULT
WHERE EMPNO = ''000210''';
END IF;
END;
Thank you very much.
My impression or only works in 11g? Is there any way to do this in 10g
– David
It seems that the Plscope only entered version 11g even. I don’t know any way to do this in 10g.
– Anthony Accioly
Okay, thank you very much I’ll see what I do here
– David