Teradata stored procedure compilation:- Warning: 5527 Stored Procedure Created with Warnings.

Database

Teradata stored procedure compilation:- Warning: 5527 Stored Procedure Created with Warnings.

Hello
I am trying to replace a stored procedure with the following command:
.COMPILE FILE PR_GENERATE_EXCLUSION_TABLE_v1.1.sql

The compilation returns the following output
*** Procedure has been replaced. 2 Errors/Warnings.
*** Warning: 5527 Stored Procedure Created with Warnings.
*** Total elapsed time was 23 seconds.

Warnings reported during compilation
---------------------------------------------------------------------------
SPL5000:W(L267), E(3807): Object 'PPROC.COL_TYPE_TEMP_TABLE' does not exist.
SPL5000:W(L595), E(3807): Object 'COL_TYPE_TEMP_TABLE' does not exist.

Inspite of the message saying that the procedure has been replaced, I continue to see the old version of the procedure. Could you please let me know why it is the case?
1 REPLY
Teradata Employee

Re: Teradata stored procedure compilation:- Warning: 5527 Stored Procedure Created with Warnings.

I believe these are just warnings "table does not exist". This shouldn't stop the SP from compiling. Try dropping the SP and then creating it and see if it works that way.