I am creating this stored procedure. but I am not able to solve these errors.

[viny2cool]

Here is my code :

CREATE OR REPLACE PROCEDURE BranchAppProc
(BranchIN IN Branch.Branchname.Branchname%TYPE,
BranchPOPUIN IN Branch.Branchname.Branchpopulation%TYPE)
IS
BranId Branch.branchID%TYPE;
BranRec Branch%ROWTYPE;
CURSOR BranCur
 IS
SELECT * FROM Services LEFT JOIN Application ON
Services.ApplicationID=Application.ApplicationID
WHERE BranchID=BranchID;
BranInfoRec BranCur%ROWTYPE;
NO_APP_FOUND_EX EXCEPTION;
BEGIN
SELECT * INTO BranRec FROM Branch 
WHERE
Coalesce(BranchName.BranchName)=BranchIN;
dbms_output.put_line('---------------------------------------------------------');
dbms_output.put_line('Branch Details');
dbms_output.put_line('---------------------------------------------------------');
dbms_output.put_line('Branch Name:'||BranRec.branchName.branchname||' '||BranRec.BranchName.BranchPopulation);
dbms_output.put_line('Branch Address:'||BranRec.BranchAddr);
dbms_output.put_line('Branch City:'||BranRec. BranchCity);
dbms_output.put_line('BranchZip:'||BranRec. BranchZip);
dbms_output.put_line('char(10)');
dbms_output.put_line('---------------------------------------------------------');
dbms_output.put_line('Branch Details');
dbms_output.put_line('---------------------------------------------------------');
OPEN BranCur;
FETCH BranCur INTO BranInfoRec;
IF BranCur %NOTFOUND=TRUE THEN
RAISE NO_APP_FOUND_EX;
END IF;
LOOP
EXIT WHEN BranCur%NOTFOUND;
dbms_output.put_line('App Id:'|| BranInfoRec.APPLICATIONID);
dbms_output.put_line('AppName:'|| BranInfoRec.APPLICATIONNAME);
dbms_output.put_line(‘App Start Date:'|| BranInfoRec.APPLICATIONSTARTDATE);
dbms_output.put_line(‘Dept:'|| BranInfoRec.DEPT);
dbms_output.put_line('---------------------------------------------------------');
END LOOP;
CLOSE BranCur;
EXCEPTION
when NO_DATA_FOUND then
dbms_output.put_line('No record found for customer');
when NO_APP_FOUND_EX then
dbms_output.put_line('There are no accounts for the customer');
END;
 

errors:

LINE/COL ERROR
-------- -----------------------------------------------------------------
15/1 PL/SQL: SQL Statement ignored
17/10 PL/SQL: ORA-00904: "BRANCHNAME"."BRANCHNAME": invalid identifier
23/1 PL/SQL: Statement ignored
23/47 PLS-00302: component 'BRANCHCITY' must be declared
36/1 PL/SQL: Statement ignored
36/46 PLS-00302: component 'APPLICATIONID' must be declared

[debasisdas]

what is this in your code ?

Branch.Branchname.Branchname%TYPE

[nbiswas]

I think the following are the problematic areas

BranchIN IN

Branch.Branchname.Branchname%TYPE

,
BranchPOPUIN IN

Branch.Branchname.Branchpopulation%TYPE

)

BranchIN IN Branch.Branchname.Branchname%TYPE,
BranchPOPUIN IN Branch.Branchname.Branchpopulation%TYPE)

dbms_output.put_line('Branch Name:'||

BranRec.branchName.branchname

||' '||

BranRec.BranchName.BranchPopulation

);

[viny2cool]

Got it .................thanks a lot for help.