Hello all,

I am very new to use stored procedure, i write a simple Pro-Fortran code to call a stored procedure.
Ex:-

------------------------ORACLE code----------------------------
create or replace
PACKAGE DEMO AS
PROCEDURE TESTFORTRAN(runid in T_Run.id%type);
END DEMO;

create or replace
PACKAGE BODY DEMO AS
PROCEDURE TESTFORTRAN(runid in T_Run.id%type) AS
sqlStatement varchar2(2000);
BEGIN
sqlStatement := 'Select T_PROJECT.NAME , T_TURBINE.OVERALL, T_PROJECT.CREATED from
T_RUN,T_PROJECT, T_TURBINE
where T_TURBINE.T_RUN_ID=runid ';
EXECUTE IMMEDIATE sqlStatement;
END TESTFORTRAN;
END DEMO;

---------------------------END of ORACLE code----------------------


now in pro fortran i called these procedure:-

c---- begin PL/SQL block -----------------
EXEC SQL EXECUTE
1 BEGIN
2 DEMO.TESTFORTRAN(:RUNID);
3 END;
4 END-EXEC
c ---- end PL/SQL block -----------------



but when i compine it i am getting an error:

PCC-S-0061: Error at line 23, column 6. PLS-201: identifier 'DEMO.TESTFORTRAN' must be declared.

can any one please help me in this?

Check if the package is compiled without any error and cross check if you have spelled the object name correctly.

__________________
Regards
Debasis