This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 21409 - Procedures list does not take into account Oracle packages
Summary: Procedures list does not take into account Oracle packages
Status: CLOSED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 3.x
Hardware: PC Windows ME/2000
: P3 blocker (vote)
Assignee: Radko Najman
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-03-11 00:24 UTC by Mark Scurrell
Modified: 2003-06-30 17:17 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Scurrell 2002-03-11 00:24:17 UTC 
We use Oracle packages to split up our stored procedures. Different stored 
procedures may have the same name in each package.  For example, "pack1.add" 
and "pack2.add".

The procedure list does not seem to distinguish between procedures of the same 
name that are in different packages.  It seems to combine all parameters for 
all procedures of the same name.  For example, it would list the 
procedure "add" with all the parameters from both "pack1.add" and "pack2.add".
Comment 1 Radko Najman 2002-03-19 10:29:23 UTC 
The problem is caused by Oracle implementation of
DatabaseMetaData.getProcedures() method - package names are returned
as procedure catalog names.

Fixed. Workaround for Oracle implemented.
Comment 2 Martin Schovanek 2003-03-12 16:43:34 UTC 
VERIFIED
Comment 3 Quality Engineering 2003-06-30 17:17:35 UTC 
Resolved for 3.3.x or earlier, no new info since then -> closing.