Pro*PL/I 1.8 Oracle预编译器指南补充：最新版

需积分: 1 71 浏览量更新于2024-06-26 收藏 927KB PDF 举报

Oracle Pro*PL/I补充指南（Release 1.8）是2001年发布的重要文档，由Oracle Corporation官方编撰，版权归属于Oracle。该补充指南针对的是Oracle预编译器，它是专为增强Pro*PL/I编程语言与Oracle数据库集成而设计的。Pro*PL/I是Oracle为PL/I提供的一种高级接口，旨在优化性能并简化应用程序开发，特别是在处理大规模数据管理和复杂查询时。该版本的文档详细介绍了如何使用Pro*PL/I与Oracle数据库进行高效交互，包括但不限于创建存储过程、触发器、包装程序和使用Oracle的特定数据类型和功能。主要内容涵盖了预编译器工具的使用方法，如Oracle预编译SQL语句的创建、优化和执行，以及如何处理PL/I代码中的异常处理和错误处理。参与编写这份补充指南的主要作者是Tim Smith和Tom Portfolio，而Brian Quigley也是贡献者之一。其他如David Beech、Peter Clare、Ziyad Dahbour、Steve Faris、Ken Jacobs、Phil Locke、Kevin MacDowell、Jeff Richey、Ken Rudin、Rakesh Shukla、Gael Turk和Scott Urman等也做出了不同程度的贡献。文档强调了这些程序（包括软件和文档）包含Oracle的专有信息，受版权、专利和工业产权保护，禁止对其进行逆向工程、拆解或反编译。用户在使用这份文档时，应遵守许可证协议中的使用和披露限制，同时Oracle Corporation并不保证文档无误，建议在发现任何问题时以书面形式向Oracle报告。此文档可能随时更新，因此保持对最新版的了解至关重要。 Oracle Pro*PL/I补充指南（Release 1.8）为PL/I开发者提供了深入理解如何利用Oracle数据库优势的宝贵资源，是优化PL/I应用性能和实现高效数据库操作的重要参考资料。

Programming Guidelines

1-2 Pro*PL/I Supplement to the Oracle Precompilers Guide

Programming Guidelines

The following sections (arranged alphabetically for quick reference) deal with

coding conventions, embedded SQL syntax, and other features that are speciﬁc to

host PL/I programs.

Comments

You can place PL/I comments (/* ... */) in a SQL statement wherever blanks can be

placed (except between the keywords EXEC SQL and within quoted literals). You

can also place ANSI SQL-style comments (-- ...) in SQL statements at the end of a

line if the statement continues over multiple lines. However, you cannot place an

ANSI SQL-style comment at the end of the last line, following the semicolon that

terminates the SQL statement. The following example shows both comment styles:

EXEC SQL SELECT ENAME, SAL /* name and salary */

INTO :EMP_NAME, :SALARY -- output host variables

FROM EMP

WHERE DEPTNO = :DEPT_NUMBER;

You cannot nest comments.

Continuation Lines

You can continue SQL statements from one line to the next, even in the middle of a

quoted string literal. For example, the following statement inserts the string value

’PURCHASING’ into the DNAME column:

EXEC SQL INSERT INTO dept (deptno, dname) VALUES (50, ’PURCHASING’);

Embedded SQL Syntax

When using SQL commands in your host program, you precede the SQL command

with the EXEC SQL clause. Embedded SQL syntax is described in the Oracle7 Server

SQL Language Reference Manual. The precompiler translates all EXEC SQL

statements into calls to the runtime library SQLLIB.

Host Variable Names

Host variable names must consist only of letters and digits, and must begin with a

letter. They can be any length, but only the ﬁrst 31 characters are signiﬁcant. The

PL/I compiler normally converts variable names to upper case. Check your

compiler documentation for the rules for forming PL/I identiﬁers on your system.

剩余161页未读，继续阅读

rocazj

粉丝: 9
资源: 725

Pro*PL/I 1.8 Oracle预编译器指南补充：最新版

Programmer’s Guide to the Oracle Precompilers Release 1.8

Pro*FORTRAN Supplement to the Oracle Precompilers Guide Release

ProFORTRAN Supplement to the Oracle Precompilers Guide 11g-124

Oracle WebDB Tutorial Guide Release 2.2

Oracle Exchange Installation / Upgrade Guide Release 6.2.0

Oracle SNMP Support Reference Guide Release 9.2.0

Oracle Universal Installer Concepts Guide Release 2.2

Oracle Quoting API Reference Guide Release 11i

Oracle Risk Manager Reference Guide Release 4.5

Oracle Performance Analyzer Reference Guide Release 4.5

最新资源