Overloaded Stored Procedures in Oracle

Posts   
 
    
jibbers
User
Posts: 3
Joined: 30-Aug-2007
# Posted on: 30-Aug-2007 12:57:55   

Hi,

I am by no means an oracle database expert, I do however no sql server and have used llblgen with that before.

I'm working in a team where basically i'm doing the llblgen stuff and another guy has developed the oracle database.

Does llblgen recognise overloaded stored procedures from Oracle?

Running llblgen against the database is only returning one of the stored procedures at the moment, am i missing something?

Thanks, Mark

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 30-Aug-2007 15:02:32   

Does llblgen recognise overloaded stored procedures from Oracle?

Would you give me examples of overloaded storedProcedures? (just the declaration)

jibbers
User
Posts: 3
Joined: 30-Aug-2007
# Posted on: 30-Aug-2007 17:03:47   

Hi,

Example package methods are:


procedure get_team( id_in NUMBER, team_out OUT team_cur_type, retseverity OUT NUMBER, retcode OUT NUMBER, retdesc OUT VARCHAR2)

procedure get_team( nickname VARCHAR2, team_out OUT team_cur_type, retseverity OUT NUMBER, retcode OUT NUMBER, retdesc OUT VARCHAR2)

Thanks.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39910
Joined: 17-Aug-2003
# Posted on: 30-Aug-2007 18:20:48   

No, overloaded procs aren't supported on oracle, it will obtain the first one.

Frans Bouma | Lead developer LLBLGen Pro
jibbers
User
Posts: 3
Joined: 30-Aug-2007
# Posted on: 30-Aug-2007 19:08:35   

Ok, thanks.

Is there any plan include support in the future?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39910
Joined: 17-Aug-2003
# Posted on: 30-Aug-2007 19:11:27   

jibbers wrote:

Ok, thanks.

Is there any plan include support in the future?

Not at the moment.

Frans Bouma | Lead developer LLBLGen Pro