Pro*C errors

[joeGrammar]

Hey guys, I'm trying to pre-compile a Pro*C program with SQLCHECK=SEMANTICS and I'm getting the following errors


Error at line 141, column 11 in file C:\csdnbatch\apps\brp_dev_area\Rel2\batchlib_db\GetClntEvntTxt.pc
141 BEGIN
141 ..........1
141 PCC-S-02346, PL/SQL found semantic errors
Error at line 142, column 12 in file C:\csdnbatch\apps\brp_dev_area\Rel2\batchlib_db\GetClntEvntTxt.pc
142 GET_CE_DSC
142 ...........1
142 PLS-S-00201, identifier 'GET_CE_DSC' must be declared
Error at line 142, column 12 in file C:\csdnbatch\apps\brp_dev_area\Rel2\batchlib_db\GetClntEvntTxt.pc
142 GET_CE_DSC
142 ...........1
142 PLS-S-00000, Statement ignored

The code is as so:

EXEC SQL EXECUTE
BEGIN
GET_CE_DSC
isqlClntEvntTyp,
:szParmEnglsh1 :iIndParmEnglsh1,
:szParmEnglsh2 :iIndParmEnglsh2,
:szParmEnglsh3 :iIndParmEnglsh3,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szParmFrnch1 :iIndParmFrnch1,
:szParmFrnch2 :iIndParmFrnch2,
:szParmFrnch3 :iIndParmFrnch3,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlParm :iIndParm,
:szsqlClntEvntDsc
);
END;
END-EXEC;


Any ideas dudes?

 

[stevecal]

Could be one of two things, but firstly you need to make sure you qualify what package GET_CE_DSC is declared in.

It could also be that GET_CE_DSC is not declared in a package at all. Or even that it does not exist...

 

[joeGrammar]

OK, where would it look for a package? Where would this be declared?

 

[joeGrammar]

Never mind, <cough> I'm missing a stored procedure in my database