The same signature of Stored procedure

[USER100001]

Hi,

I am coding a program to discover Database metadata(using JDBC). My problem is that, when I call method getProcedures(" MySchema", "MyPackage" , "PROCNAME") ; I get ResultSet which contain 2 rows with procedures with same name(schema.pac kage.name). This is not problem if column 'OVERLOAD' contain value 1 and 2 but it isn't. So my question is: how is it possible that if I call method getProcedures and get RS with procedures taht have same schema, package, name is not overloaded?

thx for any commnents

[debasisdas]

If the procedure is within a package that must be over loaded . Check for signature of both the procedures.

[USER100001]

Signature is the same. I can differ columns from ResultSet -getProcedureCol umns() when procedure is overloaded. I look at 'OVERLOAD' column in RS. But here this column is null. When I call getProcedures(. ..) my ResultSet contains 2 procedure with same schema, package and name. But when I call getProcedureCol umns() column in ResultSet with name 'OVERLOAD' is null. I don't know how is ti possible that is null.. That is not problem if column OVERLOAD have 1 or 2 or 3.. but it hasn't.

thx for any comments