Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Encountered the symbol "|" when expecting one of the following(double quote

511922Mar 15 2007 — edited Mar 15 2007

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2007
Added on Mar 15 2007
3 comments
247 views