Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
encOffice: Protect your Excel file easy and safe
LIT Software Forums › SQL*XL › General Usage and Feature Troubleshooting ‹ Previous topic | Next topic ›
Pages: 1
Using Oracle 11g virtual columns (Read 5611 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Using Oracle 11g virtual columns
19.01.09 at 10:37:12  
Using Oracle 11g virtual columns
 
Oracle virtual columns can be used in SQL*XL without problems. In Oracle 11g virtual columns can be part of tables, computed fields. To read more about virtual colums see:  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1232355973
 
Retrieving data from tables with virtual columns is no problem with SQL*XL. I tested it using the following providers:
ORAOLEDB - Oracle OLE DB
MSDASQL - Microsoft ODBC
OO4O - Oracle Objects for OLE
MSDAORA - Microsoft OLE DB provider for Oracle
Back to top
 
« Last Edit: 19.01.09 at 14:25:40 by Gerrit-Jan Linker »  
Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Updating with an Oracle virtual column
Reply #1 - 19.01.09 at 10:42:02  
Updating with an Oracle virtual column
 
It is possible to update a table with a virtual column, however you cannot update the virtual column itself. Logically. How should Oracle decide which base values to change!
 
In a multiple rows update any column apart from the virtual columns can be changed. If a value of a virtual column is changed the following error is received:
 
ORA-54017: UPDATE operation disallowed on virtual columns
 
The following error message was received using the MSDASQL provider: Microsoft ODBC for Oracle.
ORA-11519: Message 11519 not found; product=RDBMS; facility=ORA
 
I have not been able to find out what ORA-11519 means. I cannot code a friendlier message if I don't know what the error means unfortunately.
Back to top
 
« Last Edit: 19.01.09 at 10:51:15 by Gerrit-Jan Linker »  
Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1
LIT Software Forums › SQL*XL › General Usage and Feature Troubleshooting ‹ Previous topic | Next topic ›

LIT Software Forums » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.
Copyright (C) 1995-2007 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap