• Oracle ODBC driver now supports executing a stored procedure, which can return
implicit results without using
RefCursor
. This support eases any third party ODBC
application, which migrated to Oracle and wants to use this same functionality that
was provided by their previous vendors.
See Oracle Database SQL Translation and Migration Guide for more information
about implicit results support by Oracle Database.
• Extended support of
SQLColAttribute()
field identifiers to support Oracle
Database auto increment feature. You can use this feature by including Oracle
ODBC driver specific header file
sqora.h
in the application. See Oracle Call
Interface Programmer's Guide for more information about auto increment:
–
SQL_COLUMN_AUTO_INCREMENT
Starting from Oracle Database Release 12c Release 1 (12.1), Oracle supports
auto increment columns so the Oracle ODBC Driver has extended the same
support through the existing
SQLColAttribute()
identifier
SQL_COLUMN_AUTO_INCREMENT
. This property is read only and returns
SQL_TRUE
if the column is auto increment; otherwise, it returns
SQL_FALSE
.
–
SQL_ORCLATTR_COLUMN_PROP
Starting from Oracle Database Release 12c Release 1 (12.1), Oracle ODBC
Driver supports a new driver specific field identifier
SQL_ORCLATTR_COLUMN_PROP
, which returns the attributes of the column. This
identifier returns
SQLULEN
value, which has all the column properties, shown as
follows:
+-----------------------------------------+
| 32 |...| 10 | 9 | 8 |......| 3 | 2 | 1 |
+-----------------------------------------+
| | |
| | |-> Column is auto-increment?
| |-> Auto value is always generated?
|-> If generated by default when null?
ODBC 11.2.0.1.0
Describes new features for release 11.2.0.1.0.
• Oracle ODBC driver has been enhanced to prefetch
LONG
and
LONG RAW
data to
improve performance of ODBC applications. To do this, the maximum size of
LONG
data (
MaxLargeData
) has to be set in registry on Windows (also need to add the
registry key
MaxLargeData=
in the DSN), and in
odbc.ini
file on UNIX platforms
manually. This enhancement has improved the performance of Oracle ODBC
driver up to 10 times, depending on the
MaxLargeData
size set by the user. The
default value of
MaxLargeData
is 0. The maximum value for
MaxLargeData
that can
be set by the user is 64 KB (65536 bytes). Even if the value of
MaxLargeData
is set
to some value greater than 65536, the data fetched will be 65536 bytes only. If a
user has
LONG
and
LONG RAW
data in database, which is greater that 65536 bytes,
MaxLargeData
should be set to 0 (the default value), which will result in single row
fetch and the complete
LONG
data can be fetched. In case the user has passed the
buffer less than
MaxLargeData
size in non-polling mode, the data truncation error
4
剩余18页未读，继续阅读
沧海一笑-dj
- 粉丝: 4w+
- 资源: 353
我的内容管理
展开
最新资源
- JDK 17 Linux版本压缩包解压与安装指南
- C++/Qt飞行模拟器教员控制台系统源码发布
- TensorFlow深度学习实践：CNN在MNIST数据集上的应用
- 鸿蒙驱动HCIA资料整理-培训教材与开发者指南
- 凯撒Java版SaaS OA协同办公软件v2.0特性解析
- AutoCAD二次开发中文指南下载 - C#编程深入解析
- C语言冒泡排序算法实现详解
- Pointofix截屏：轻松实现高效截图体验
- Matlab实现SVM数据分类与预测教程
- 基于JSP+SQL的网站流量统计管理系统设计与实现
- C语言实现删除字符中重复项的方法与技巧
- e-sqlcipher.dll动态链接库的作用与应用
- 浙江工业大学自考网站开发与继续教育官网模板设计
- STM32 103C8T6 OLED 显示程序实现指南
- 高效压缩技术：删除重复字符压缩包
- JSP+SQL智能交通管理系统：违章处理与交通效率提升
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
