This Bugzilla instance is deprecated, and most Eclipse projects now use GitHub or Eclipse GitLab. Please see the deprecation plan for details.
Bug 234385 - Support optional arguments for StoredProcedures
Summary: Support optional arguments for StoredProcedures
Status: RESOLVED WORKSFORME
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-05-28 10:48 EDT by Mike Norman CLA
Modified: 2022-06-09 10:33 EDT (History)
1 user (show)

See Also:

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 Mike Norman CLA 2008-05-28 10:48:14 EDT 
Arguments to Stored Procedures can have defaults:

Sybase:
create procedure newPart @desc varchar(40), @price money,
  @quant int = 0, @reorder int = 10 as ...

Oracle:
CREATE OR REPLACE PROCEDURE SP_TEST(parm1 VARCHAR2, parm2 VARCHAR2 := 'foo') IS

When invoking the SP, you may skip any argument that has a default.
This is especially important for SP's from Oracle Apps - some SP's have
literally HUNDREDs of arguments but common usage requires only a few.
Comment 1 Tom Ware CLA 2009-04-16 10:56:33 EDT 
Updating priority due to revised bug categorization process.  See the following page for details:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines#Priority_and_Target_Milestone 

If you feel the updated priority is incorrect, please send an email to eclipselink-users@eclipse.org.
Comment 2 James Sutherland CLA 2011-03-07 10:21:19 EST 
Confirmed that this is already supported, for both stored procedures and plsql stored procedures.  You just define the desired arguments to the stored procedure call.
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:33:39 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink