CODEWITHSUNDEEP
oracle-databaseoracle10goverloadingprocedures
user867647
user867647

Reputation: 13

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 declarations for check_val" ...

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

Thoughts?

Upvotes: 1

Views: 636

Answers (2)

Allan
Allan

Reputation: 17429

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.

Upvotes: 0

DCookie
DCookie

Reputation: 43533

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

Upvotes: 1

Related Questions