版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、OracleSQL*Modulefor AdaProgrammers Guide 10g Release 2 (10.2)A58231-03May 2006Oracle SQL*Module for Ada Programmers Guide, 10g Release 2 (10.2) A58231-03Copyright 2001, 2006, Oracle. All rights reserved. Primary Author:Contributing Author:Contributor:The Programs (which include both the software and
2、 documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Progr
3、ams, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in wri
4、ting. This document is not warranted to be error-free.Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.If the Programs are delivered to
5、the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are commercia
6、l computer software or commercial technical data pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject t
7、o the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software-Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.The Programs ar
8、e not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensees responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used f
9、or such purposes, and we disclaim liability for any damages caused by such use of the Programs.Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.The Programs may provide links to
10、Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a thir
11、d party, the relationship is directly between you and the third party. Oracle is not responsible for:(a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations rela
12、ted to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.ContentsPreface .ixix ix xxIntendedAudience.DocumentationAccessibility.StandardsConformance.Conventions .1Introduction to SQL*ModuleWhatIs SQL*Modu
13、le?.Background .Precompilers .The Module Language Concept.SQL*Module as an InterfaceBuilder .What Is Supported by SQL*Module? .What SQL Statements are Not Supported by SQL*Module? .1-11-11-21-31-51-71-72Module LanguageTheModule .An Example Module.A Short Example Program in Ada.Structure of a Module.
14、Preamble.MODULE Clause.2-12-12-32-62-62-62-62-62-72-82-82-82-82-92-102-112-112-112-13LANGUAGEClause.AUTHORIZATIONClause .CursorDeclarations .ProcedureDefinitions.Procedure Name.ParameterList.SQL92Syntax.SQLDatatypes .SQL Commands.Text in aModule .Comments .IndicatorParameters .Status Parameters .iii
15、ErrorMessages .2-132-132-142-142-152-152-152-162-162-162-16CONNECTStatement.SETCONNECTION Statement.DISCONNECTStatement .Multi-tasking.ENABLETHREADS .SQL_CONTEXTDatatype .CONTEXTALLOCATE .CONTEXT FREE.Multi-taskingMulti-taskingRestrictions.Example.3Accessing Stored ProceduresPL/SQL.Procedures.3-13-2
16、3-23-33-33-43-53-63-73-73-73-83-83-93-93-93-93-103-113-113-123-123-123-143-15Stored Procedures.StoredPackages .Accessing Stored Procedures .Case of Package and Procedure Names .Early and Late Binding .Cursor Variables.CursorVariable Parameters.Allocating a Cursor Variable.Opening a Cursor Variable.O
17、pening in a Stand-alone Stored Procedure.Return Types.Closing a Cursor Variable.Restrictions on Cursor Variables .DynamicSQL .The WITH INTERFACEClause .Examples .SQLDatatypes .DATEDatatype .The Default WITH INTERFACE Clause.Procedures.Functions .Storing Module Language Procedures .Connecting to aDat
18、abase .4Developing the Ada ApplicationProgramStructure .4-14-24-24-24-24-44-4Error Handling.SQLCODE .Obtaining Error Message Text .SQLSTATE .Obtaining the Number of Rows Processed.Handling Nulls .ivIndicatorVariables.4-54-64-64-64-64-7Cursors.Specification Files .Calling a Procedure .Arrays as Procedure Arguments.Globalization Support.5Running SQL*ModuleSQL*Module Input and Output .Input sources.Output Files.Determining the Input Source.Invoking SQL*Mod
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 云南省昭通市永善县2023-2024学年七年级上学期期中考试数学试卷(含解析)
- 2024年便携式振动分析仪项目发展计划
- 2024年冷芯盒树脂合作协议书
- 2024年高纯锑及氧化锑项目建议书
- DB3301-T 65.12-2024 反恐怖防范系统管理规范 第12部分:广电传媒
- 2024年智能压力发生器项目发展计划
- 安全生产法学习要点
- 2024年核能及配套产品项目合作计划书
- 山东省德州市夏津县2025届四年级数学第一学期期末检测试题含解析
- 压裂用柔性软管和软管组合件 规范 编制说明
- 医学院课堂教学质量督导专家评价表
- 协会成立实施方案
- 深圳排名前六的企业培训机构
- 防爆知识简介--ppt课件
- 新视野大学英语读写译4U校园第一单元课后测试答案
- 实验心理学课件(周爱保博士版)
- GMI地应力分析及钻井优化设计
- 医疗器械经营质量管理制度pd
- 票据业务案例分析
- GB∕T 17445-2022 铸造磨球(高清最新版)
- 中国地理经典空白图
评论
0/150
提交评论