Issue 60847

Summary: Stored Proc Support
Product: Base Reporter: oiaohm <oiaohm>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, lionel, stlman
Version: OOo 2.0.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description oiaohm 2006-01-20 02:50:51 UTC
Most project I work on these days all interfacing with database has to happen
threw Stored Proc's.

Lack of support for this simple makes life harder than what it should be.

Stored Proc's can return one or many tables and other infomation.  OpenOffice
base need this feature.
Comment 1 oiaohm 2006-01-20 11:24:59 UTC
Should have been more exact here.

We have Table View Querys all with direct interfaces to control and use.

There is nothing for Stored Procs.  They are just as much part of database's
these days.

From the GUI you should be able to call the Stored Procs and the Wizard for
creating Forms and Reports Should be able to handle these.

Permissions on Stored Procs in databases is critical.   Even allowing writing of
database dependent Stored Procs from Base makes base more usable.
Comment 2 marc.neumann 2006-01-26 12:58:46 UTC

I reassign this enhancement to the User Experience team for evaluating.

Bye Marc
Comment 3 stlman 2007-05-11 13:14:43 UTC
HSQLDB can use java classes and methods as stored procedures and triggers. Why
not store such classes in .odb files and use those files lika JARs?
Comment 4 stlman 2009-10-01 11:35:11 UTC
In bug #103133 I propose including JDBC driver JARs in odb files.
Comment 5 oooforum (fr) 2017-01-23 13:41:54 UTC
*** Issue 103133 has been marked as a duplicate of this issue. ***