Oracle Database Gateway for Sybase 用户指南

需积分: 5 132 浏览量更新于2024-06-25 收藏 1.58MB PDF 举报

"Oracle Database Gateway for Sybase User's Guide 11g Release 2 (11.2) E12067-03" Oracle Database Gateway for Sybase 是一款连接Oracle数据库与Sybase数据库系统的软件，它使得用户能够通过Oracle环境访问和管理Sybase数据源。这份用户指南详细介绍了如何在11g Release 2（11.2）版本中使用该工具。一、Oracle Database Gateway for Sybase 的主要功能： 1. 数据库互操作性：该网关提供了一个桥梁，允许Oracle数据库系统与Sybase数据库进行通信，实现了跨平台的数据交换。 2. 数据访问：用户可以通过SQL*Plus、PL/SQL以及Oracle应用程序无缝地访问和操作Sybase数据库中的数据。 3. 应用程序兼容性：网关允许现有的Oracle应用程序无需修改即可访问Sybase数据库，减少了迁移成本和复杂性。 4. 数据迁移：支持将数据从Sybase迁移到Oracle，或者反之，为数据整合和备份恢复提供便利。二、安装与配置：在安装Oracle Database Gateway for Sybase时，需要遵循特定的步骤，包括安装软件、创建网关实例、配置网络服务名以及设置必要的安全参数。这些步骤通常涉及设置环境变量、安装所需的数据库组件，并配置Oracle Net Services以连接到Sybase服务器。三、性能优化：为了确保高效的数据传输，用户指南会提供关于性能调整的建议，如调整内存分配、设置正确的并发连接数以及优化网络通信。四、故障排查与维护：文档包含了故障排除技巧和诊断工具的使用，帮助用户解决在使用过程中可能遇到的问题。此外，还提供了日常维护任务的指导，如监控网关性能、日志管理和备份恢复。五、安全与权限管理： Oracle Database Gateway for Sybase 支持多种安全特性，如身份验证、授权和审计。用户需要了解如何设置和管理这些安全机制，以确保数据的安全性和合规性。六、编程接口与API：指南涵盖了使用PL/SQL或Java等编程语言与Sybase数据库交互的接口和API，帮助开发人员构建和扩展应用程序。七、许可证与法律条款：文档强调了软件的使用受到许可证协议的限制，包括使用、披露和复制等方面的限制，并提醒用户尊重知识产权。任何反授权行为，如反向工程、拆解或编译软件，除非法律允许或许可证明确允许，否则都是禁止的。八、反馈与错误报告：如果用户在使用过程中发现错误，应书面报告给Oracle公司，以便他们能够及时修复并提高产品的质量。 Oracle Database Gateway for Sybase 用户指南提供了全面的指导，涵盖了从安装、配置、使用到维护的全过程，旨在帮助用户充分利用这个工具来实现Oracle与Sybase数据库之间的有效连接和数据管理。

Sybase Gateway Features and Restrictions 2-1

2 Sybase Gateway Features and Restrictions

After the gateway is installed and configured, you can use the gateway to access

Sybase data, pass Sybase commands from applications to the Sybase database,

perform distributed queries, and copy data.

This chapter contains the following sections:

■ Using the Pass-Through Feature

■ Executing Stored Procedures and Functions

■ CHAR Semantics

■ Multi-byte Character Sets Ratio Suppression

■ IPv6 Support

■ Gateway Session IDLE Timeout

■ Database Compatibility Issues for Sybase

■ Known Restrictions

■ Known Problems

Using the Pass-Through Feature

The gateway can pass Sybase commands or statements from the application to the

Sybase database using the DBMS_HS_PASSTHROUGH package.

Use the DBMS_HS_PASSTHROUGH package in a PL/SQL block to specify the statement

to be passed to the Sybase database, as follows:

DECLARE

num_rows INTEGER;

BEGIN

num_rows := DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@SYBS('command');

END;

Where command cannot be one of the following:

■ BEGIN TRANSACTION

■ COMMIT

■ ROLLBACK

■ SAVE

■ SHUTDOWN

Executing Stored Procedures and Functions

2-2 Oracle Database Gateway for Sybase User's Guide

■ Sybase tool commands

The DBMS_HS_PASSTHROUGH package supports passing bind values and executing

SELECT statements.

Executing Stored Procedures and Functions

Using the procedural feature, the gateway can execute stored procedures that are

defined in the Sybase database. It is not necessary to relink the gateway or define the

procedure to the gateway, but the procedure's access privileges must permit access by

the gateway.

Standard PL/SQL statements are used to execute a stored procedure.

The gateway supports stored procedures in three mutually exclusive modes:

■ Normal mode: Have access to IN/OUT arguments only

■ Return value mode: Have a return value for all stored procedures

■ Resultset mode: Out values are available as last result set

Return Values and Stored Procedures

By default, all stored procedures and functions do not return a return value to the user.

To enable return values, set the HS_FDS_PROC_IS_FUNC parameter in the

initialization parameter file.

In the following example, the employee name JOHN SMYTHE is passed to the Sybase

stored procedure REVISE_SALARY. The stored procedure retrieves the salary value

from the Sybase database to calculate a new yearly salary for JOHN SMYTHE. The

revised salary returned in RESULT is used to update EMP in a table of an Oracle

database:

DECLARE

INPUT VARCHAR2(15);

RESULT NUMBER(8,2);

Note: TRUNCATE cannot be used in a pass-through statement.

See Also: Oracle Database PL/SQL Packages and Types Reference and

Chapter 3, Features of Oracle Database Gateways, of Oracle

Database Heterogeneous Connectivity User's Guide for more

information about the DBMS_HS_PASSTHROUGH package.

See Also: Oracle Database Heterogeneous Connectivity User's Guide

for more information about executing stored procedures.

See Also: Appendix D, "Initialization Parameters" for information

about both editing the initialization parameter file and the HS_

FDS_PROC_IS_FUNC parameter.

Note: If you set the HS_FDS_PROC_IS_FUNC gateway

initialization parameter, you must change the syntax of the

procedure execute statement for all existing stored procedures.

Executing Stored Procedures and Functions

Sybase Gateway Features and Restrictions 2-3

BEGIN

INPUT := 'JOHN SMYTHE';

RESULT := REVISE_SALARY@SYBS(INPUT);

UPDATE EMP SET SAL = RESULT WHERE ENAME =: INPUT;

END;

The procedural feature automatically converts non-Oracle data types to and from

PL/SQL data types.

Result Sets and Stored Procedures

The Oracle Database Gateway for Sybase provides support for stored procedures

which return result sets.

By default, all stored procedures and functions do not return a result set to the user. To

enable result sets, set the HS_FDS_RESULTSET_SUPPORT parameter in the

initialization parameter file.

When accessing stored procedures with result sets through the Oracle Database

Gateway for Sybase, you will be in the sequential mode of Heterogeneous Services.

The Oracle Database Gateway for Sybase returns the following information to

Heterogeneous Services during procedure description:

■ All the input arguments of the remote stored procedure

■ None of the output arguments

■ One out argument of type ref cursor (corresponding to the first result set returned

by the stored procedure)

Client programs have to use the virtual package function dbms_hs_result_

set.get_next_result_set to get the ref cursor for subsequent result sets. The last

result set returned is the out argument from the procedure.

The limitations of accessing result sets are the following:

■ Result sets returned by a remote stored procedure have to be retrieved in the order

in which they were placed on the wire

■ On execution of a stored procedure, all result sets returned by a previously

executed stored procedure will be closed (regardless of whether the data has been

completely

In the following example, the Sybase stored procedure is executed to fetch the contents

of the emp and dept tables from Sybase:

create procedure REFCURPROC (@arg1 varchar(255), @arg2 varchar(255) output)

See Also: Appendix D, "Initialization Parameters" for information

about both editing the initialization parameter file and the HS_

FDS_RESULTSET_SUPPORT parameter. For further information

about Oracle support for result sets in non-Oracle databases see

Oracle Database Heterogeneous Connectivity User's Guide.

Note: If you set the HS_FDS_RESULTSET_SUPPORT gateway

initialization parameter, you must change the syntax of the

procedure execute statement for all existing stored procedures or

errors will occur.

剩余77页未读，继续阅读

weixin_40191861_zj

粉丝: 84
资源: 1万+

Oracle Database Gateway for Sybase 用户指南

Sybase到Oracle数据迁移.pdf

Oracle 11g2 GateWay for sybase 配置图解

Transparent Gateway for Sybase

Oracle Database 19c (LINUX.X64-193000-gateways.zip)

Oracle Database Gateways 19c (19.3) for Linux x86-64

Oracle11gR2透明网关for sybase

oracle v-11.2.0.4.0 Oracle 11.2.0.4 For Windows 64bit+32bit 数据库

Oracle Database Gateways 19c (19.3) for Microsoft Windows x64

oracle 同步sybase

Oracle访问sybase

最新资源