overloading in oracle

Hi!

We've got the following problem: we have a package and we declared 2 procedures with same name but the parameters are referencing different columns in the same table. Unfortunately the column-datatypes are of the same type.

the compilation runs trough it without any error-messages, but wenn we try to compile another package containing a procedure that calls the overloaded procedures we receive an 'to many declarations of "procedure-name" match this call' - error.

Is it possible to get a workarround for this without having to change procedure-names.

to make things clearer a short code-snippet:

procedure my_procedure (
  my_parametername1 in my_table.my_column1 %type,   ...
)

procedure my_procedure (
  my_other_parametername2 in mytable.my_other_column2 %type,   ...
)

procedure call_my_procedure (
...

   begin

      my_procedure( ...)
)

the package that contains call_my_procedure fails to compile with the error described in the beginning.

thanx in advance
Tom

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 10 2000 - 08:26:55 CST