Embedded PL/SQL in Pro*C Question

Do I need to declare a PL/SQL procedure in a specific library in order for the Pro*C compile to find the module.

I get the following error message for this code;

EXEC SQL EXECUTE
  BEGIN
      SP_TRUNCATE_RTN(:table_name);   END;
END-EXEC; (1) PCC-S-02201, identifier 'SP_TRUNCATE_RTN' must be declared

Thanks in advance

REMOVEjames.stewart_at_pwgsc.gc.ca

Omit REMOVE to email. Received on Fri Mar 10 2000 - 21:51:03 CET