hi,
PROCEDURE hashierarchy(I_Cntry in varchar2,cmpy_or_prsn_id in number,outType OUT boolean) IS
L_Cntry varchar2(20) := Null;
L_Owner varchar2(20) := Null;
sqlt Varchar2(30000);
status number;
begin
L_Cntry := I_Cntry;
L_Owner := 'EWR' || L_Cntry || 'MASTER.cstm_hrch';
SELECT count(dpnd_cmpy_or_prsn_id) into status FROM || L_Owner|| WHERE parn_cmpy_or_prsn_id = cmpy_or_prsn_id;
if(status > 0) then
outType:=true;
else
outType:=false;
end if;
getting error at line which is BOLD:
Encountered the symbol "|" when expecting one of the following(double quoted delimited identifier)
wat i do is:
L_Owner := 'EWR' || L_Cntry || 'MASTER.cstm_hrch';
i pass country name for eg UK then
table name EWRUKMASTER.cstm_hrch will be stored in L_Owner string
i want to use this L_Owner in select query
pls help
thx