Ticket #4161 (closed defect: fixed)
[PATCH] OGR OCI: Error in retrieving table dimension
| Reported by: | nicsim | Owned by: | warmerdam |
|---|---|---|---|
| Priority: | normal | Milestone: | 1.8.1 |
| Component: | OGR_SF | Version: | unspecified |
| Severity: | normal | Keywords: | OGR OCI |
| Cc: |
Description
When doing ogrinfo on an oracle database with tables in a schema different that the user, we get the following error message:
ogrinfo OCI:USER/PWD@DSPTW
ERROR 1: ORA-00942: table or view does not exist
in SELECT a.GEOM.GET_DIMS() DIM FROM SIG_PENTE_SUP10 a WHERE ROWNUM = 1
ERROR 1: ORA-24374: define not done before fetch or execute and fetch
in OCIStmtFetch
This is due by the fact that the table name (SIG_PENTE_SUP10 in my case) is not prefixed with the schema owner.
This could by easily corrected with provided patches
Nicolas Simon
Attachments
-
ogrocitablelayer_branch18.patch
(0.5 KB) - added by nicsim
23 months ago.
- Patch for 1.8 branch
-
ogrocitablelayer_trunk.patch
(0.5 KB) - added by nicsim
23 months ago.
- Patch for trunk
-
ogrocitablelayer_trunk.2.patch
(0.5 KB) - added by nicsim
23 months ago.
- Patch for trunk
Change History
Note: See
TracTickets for help on using
tickets.
