Issue 83047 - Cannot use views with Oracle
Summary: Cannot use views with Oracle
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3
Hardware: PC Windows XP
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://
Depends on:
Reported: 2007-10-28 02:35 UTC by cianoz
Modified: 2013-08-07 15:45 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description cianoz 2007-10-28 02:35:13 UTC
I created a connection to an Oracle db with OOo 2.3.0 because I need a form for
data insert and update. I see that everything works fine if I try to insert
records straight to the tables, but I can't do anything if I try to work with views.
This appears as a limit of Base. Can you confirm it? Does it exist any
workaround to use views for data insert instead of tables?
Comment 1 Mechtilde 2007-10-28 08:22:39 UTC
need more information

Which connector do you use?

Does the database management system Oracle support views?

Does the connector support views?

Does the view contain the primary key?
Comment 2 cianoz 2007-10-28 11:31:55 UTC
I used both an ODBC connection with the Merant drivers v.3.70, that is what we
regularly use for our ERP, and a JDBC connection using the ojdbc14.jar driver.
Both drivers seem to works, only, the JDBC driver is much slower than the ODBC.

The DBMS supports views, absolutely!

I didn't check if the JDBC connector support views, in effect... I have to give
a look. Anyway, the Merant ODBC driver has full support for views.

All the views contains the primary key, this is OK.
Comment 3 cianoz 2007-11-05 07:52:43 UTC
Any new about this issue?
At least do some checks to change status to "confirmed"
Comment 4 expuetti 2008-01-08 12:04:54 UTC
i can confirm this issue,too.

Using: oo 2.3.1 on xp, JDBC connection with ojdbc14.jar driver, Oracle XE database.

Testcase: calc-datapilot on registered oracle-xe-database.
Views should be listed under type="query", not under table - but they aren't.
No problems with materialized views. they are listed under type="table"

Yes, connector supports views!
Comment 5 expuetti 2008-01-08 16:06:38 UTC
different behaviour detected:
oracle views can be seen in calc via "datasource" (F4) and in base - here as
tables. ojdbc14.jar driver used for these testcases.

error seems to be in code of program module "calc-datapilot".

Comment 6 oracelix 2008-01-24 15:04:42 UTC
I'm able to confirm this issue. 

OS: openSuse 10.3 and WinXP SP2
OOo: 2.3.1 (on WinXP vanilla-version)
Oracle: 10gR1
jdbc-driver: ojdbc14.jar  

I've created a view with these options

- only one table is attached by this view
- all primary key fields are in it
- all not nullable fields are in it
- based table is able to be edited

In Base the edit button is not active after opening this view. I'm not able to
add new records or modify existing records.

To verify the jdbc-driver is able to modify or add records I've tried to add a
new record by using SQL-Developer with same jdbc-driver. The jdbc-driver works
Comment 7 Mechtilde 2008-03-17 22:47:21 UTC
as discussed with oracelix on IRC
Comment 8 christoph.lukasiak 2008-06-18 13:02:26 UTC
clu->oj:may you have a looh at this

Comment 9 ocke.janssen 2008-12-10 07:49:46 UTC
Set target.