View Single Post
 
Old August 9th, 2010, 08:03 AM
angad angad is offline
Registered User
 
Join Date: Aug 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error "PLS-201: identifier procedurename() must be declared

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?