Does the procedure run?

[Trevisolli]

Good morning guys.

follows an excerpt that I have seen long ago and, I decided to post:

Select all

 
begin 
	default_value('0','global.cod_empregado'); 
	if :global.cod_empregado <> '0' then 
    	p_popula_empregado; 
	end if; 
end; 

Populate the employee?

Personal, only 1 information ...
There are no global calls in this case, so I posted it here.
Otherwise, the default_value would be replaced by the supplied value, okay?.

[dr_gori]

Maybe this makes sense yes. See:
* If the default_value had not been placed in the IF case if this variable has not been created by another program. That is, it placed the default_value to avoid the error.
* If any other program has set the: global.cod_empregate, hence I would enter IF

Remember that the global variables are per session. If another form set, maybe still be in memory, even if this proorgama not seven that global.