nested block



Serena's Software Change Management utility:Changeman ZMF: Application change, upgrade control and LifeCycle Management

nested block

Postby bernadettedg » Thu Oct 09, 2014 3:05 pm

error changeman for code block in RED

CREATE OR replace PROCEDURE test_not_found
(OUT O_TIPO_ERRORE CHAR(3),
OUT O_CODICE_ERRORE SMALLINT,
OUT O_MESSAGGIO_ERRORE VARCHAR(2000))
BEGIN
DECLARE SQLCODE INTEGER DEFAULT 0;
DECLARE L_MSG_STMT VARCHAR(600) DEFAULT NULL;
DECLARE NOTE_LOG VARCHAR(600) DEFAULT NULL;

DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN
GET DIAGNOSTICS EXCEPTION 1 L_MSG_STMT = MESSAGE_TEXT;
SET O_CODICE_ERRORE = SQLCODE;
END IF;

SET O_CODICE_ERRORE = 0;
SET O_TIPO_ERRORE = 'DB2';
SET O_MESSAGGIO_ERRORE = NULL;
-- Legge il messaggio di errore
SELECT MESSAGGIO_ERRORE
INTO O_MESSAGGIO_ERRORE
FROM TBARTE_MESSAGGI_ERRORE
WHERE 1='aaa';

SET NOTE_LOG='SP:Test - '||L_MSG_STMT;
CALL SPARTE_P_INS_LOG('A'
,null
,O_TIPO_ERRORE
,O_CODICE_ERRORE
,NOTE_LOG);

END;

thanks :|
bernadettedg
 
Posts: 2
Joined: Fri Mar 07, 2014 8:29 pm
Has thanked: 1 time
Been thanked: 0 time

Re: nested block

Postby Terry Heinze » Thu Oct 09, 2014 7:21 pm

Is there a question in there somewhere?? :?
.... Terry
Terry Heinze
 
Posts: 239
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 12 times
Been thanked: 11 times

Re: nested block

Postby NicC » Thu Oct 09, 2014 10:40 pm

Or any red stuff?

And what is that code meant to represent? What language is it written in? And what has it to do with Changeman?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

These users thanked the author NicC for the post:
bernadettedg (Fri Oct 10, 2014 1:57 pm)
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: nested block

Postby bernadettedg » Fri Oct 10, 2014 2:01 pm

Thanks
The question has been solved
:D
bernadettedg
 
Posts: 2
Joined: Fri Mar 07, 2014 8:29 pm
Has thanked: 1 time
Been thanked: 0 time

Re: nested block

Postby NicC » Sat Oct 11, 2014 1:07 pm

Except the question of 'what is your question?'
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: nested block

Postby BillyBoyo » Sat Oct 11, 2014 3:42 pm

I don't think there's any problem with deleting this whole topic in its present state.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to ChangeMan ZMF