Opened 13 years ago
Closed 12 years ago
#4161 closed defect (fixed)
[PATCH] OGR OCI: Error in retrieving table dimension
Reported by: | Nicolas Simon | 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 (3)
Change History (5)
by , 13 years ago
Attachment: | ogrocitablelayer_branch18.patch added |
---|
comment:1 by , 13 years ago
Component: | default → OGR_SF |
---|---|
Summary: | OGR OCI: Error in retrieving table dimension → [PATCH] OGR OCI: Error in retrieving table dimension |
comment:2 by , 12 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
Patch for 1.8 branch