oracle 10g overloaded procedures in a package

I'm trying to replicate the code found in:

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:59412348055

I did a copy and paste job. The package audit_pkg and the body compiled fine. But when I added the triggers the debug says "too many declaratio开发者_运维技巧ns for check_val" ...

Everything I've found says 10g supports overloading (or at least doesn't say otherwise).

Thoughts?

The procedure declarations in the package specification must match EXACTLY the declarations in the package body. This is where I usually encounter this error.

Is the column you're trying to use this package with a varchar2, number or date? If it's not, Oracle has to implicitly convert it to one of those three, and it won't know which one to use (and, therefore, which procedure to use). You may need to expand the package to handle more data types.