	sp_GetFullname

Item Location

DATA >

sp_GetFullname

Description

Procedure body sp_GetFullname(fname NVARCHAR2,lname NVARCHAR2), Package DATA

Parameters

Name	Datatype	Precision	Description
fname	nvarchar2		NVARCHAR2, parameter of DATA.sp_GetFullname
lname	nvarchar2		NVARCHAR2, parameter of DATA.sp_GetFullname

Variables and Constants and their Impact Analysis

Name	Types	Value
No Data

Cursors

Name	Definition
No Data

Source Code

procedure sp_GetFullname(fname in nvarchar2,lname in  in nvarchar2)
    Is 

    Begin
        return(GetFullName(fname,lname));
    end sp_GetFullname

References
The items listed in the matrix below are called / used by the Procedure “sp_GetFullname”

Name	Types	Description
<DEFAULT SCHEMA>.DATA.sp_GetFullname	Procedure	Procedure interface sp_GetFullname(fname NVARCHAR2,lname NVARCHAR2), Package DATA
<DEFAULT SCHEMA>.DATA.GetFullName	Function	Function body GetFullName(fname NVARCHAR2,lname NVARCHAR2) return GetFullName, Package DATA
NVARCHAR2	PL/SQL System type	PL/SQL System Object

Impact Analysis
The items listed in the matrix below are using / calling the Procedure “sp_GetFullname”

Name	Types	Description
n_tr_demopfc.uf_GetFullname	Function	function string uf_GetFullname(string,string)