identifier 'EXCEL2COLLECTION.TP_SHEETS' must be declared

[sharedoyle]

I am getting the following error when I try to run the EXCEL2COLLECTION process PLS-00201: identifier 'EXCEL2COLLECTION.TP_SHEETS' must be declared

[antonscheffer]

The error "PLS-00201: identifier 'EXCEL2COLLECTION.TP_SHEETS' " is something you can ignore. The second error "ORA-06502: PL/SQL: numeric or value error" is more serious. That means it can not parse the XLS-file. Without that file it is impossible to say why that is happening.

[antonscheffer]

You could try that XLS-file at my demo application for this plugin at Demo application for EXCEL2COLLECTION That application uses the "package-parser" which, besides being much faster, provides more logging for me to debug.

[antonscheffer]

I removed the code to try using "a" package.