📄 lnoci.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 3.2 transitional//en.us"><HTML lang="en.us"><HEAD><META NAME="Generator" CONTENT="Quadralay WebWorks Publisher 5.0.4"><META NAME="Page" CONTENT="DefaultSingle"><META NAME="Title" CONTENT=" Oracle Call Interface Programmer's Guide"><TITLE> Oracle Call Interface Programmer's Guide</TITLE> <LINK REL="home" HREF="../../products.htm" TITLE="Library"><LINK REL="toc" HREF="toc.htm" TITLE="Contents"><LINK REL="index" HREF="index.htm" TITLE="Index"><LINK REL="copyright" HREF="../dcommon/html/cpyr.htm" TITLE="Copyright"><LINK REL="up" HREF="toc.htm" TITLE="Up"><LINK REL="next" HREF="ccref.htm" TITLE="Next"><LINK REL="previous" HREF="preface.htm" TITLE="Previous"></HEAD> <BODY BGCOLOR="#ffffff"><A NAME="top"></A><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR> <TD ALIGN="LEFT" VALIGN="TOP"><FONT COLOR="#330099" FACE="Helvetica, Arial, sans-serif"><B>Oracle9<i>i</i> Database Generic Documentation Addendum<BR>Release 2 (9.2)</B><BR>Part Number A97283-01</FONT></B></TD><td valign="BOTTOM" align="RIGHT" width="144"><table cellspacing="0" cellpadding="0" width="50%"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE><HR><P><A HREF="preface.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A><A HREF="ccref.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A> <DIV CLASS="IND"><!-- End Header --><A NAME="1656"></A><!--TOC=Title-"1656"--><H1 CLASS="Title"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">1<BR> Oracle Call Interface Programmer's Guide</FONT></H1><!--/TOC=Title--><A NAME="1004777"></A><P CLASS="BP">This chapter lists additions and corrections to <EM CLASS="Italic">Oracle Call Interface Programmer's Guide</EM>, Release 2 (9.2).</P><A NAME="1004827"></A><P CLASS="BP">This chapter contains the following topic:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1004772"></A><A HREF="lnoci.htm#1004791">Documentation Corrections</a><P></UL><A NAME="1004791"></A><!--TOC=h1-"1004791"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Documentation Corrections</FONT></H2><!--/TOC=h1--><A NAME="1004802"></A><P CLASS="BP">The following are corrections to the <EM CLASS="Italic">Oracle Call Interface Programmer's Guide</EM> document:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1004799"></A>In Chapter 2, "OCI Programming Basics", in the "Using PL/SQL in an OCI Program" section, the following note will be added:<P><A NAME="1004634"></A><P CLASS="BP1">When binding a PL/SQL <CODE>VARCHAR2</CODE> variable in OCI, the maximum size of the bind variable is 32512, because of the overhead of control structures.</P><LI CLASS="LB1" TYPE="DISC"><A NAME="1004784"></A>In Chapter 6, "Describing Schema Metadata", in the "Character Length Semantics Support in Describing" section, the following sentence will be added:<P><A NAME="1004785"></A><P CLASS="BP1">Calling <CODE>OCIAttrGet()</CODE> with attribute <CODE>OCI_ATTR_CHAR_SIZE</CODE> does not return data on stored procedure parameters because stored procedure parameters are not bounded.</P><LI CLASS="LB1" TYPE="DISC"><A NAME="1004664"></A>Chapter 13, "Object Cache Navigation" will be rewritten to satisfy the following bug report:<P><A NAME="1004667"></A><P CLASS="BP1">The object cache is logically partitioned by "connection", that is, service context. As a result of this the OCI code is written to expect that all object types (TDOs) and table definitions are fetched for each service context that will use them. Unless the cache is low and objects are being aged out, programs that fetch all TDOs and tables on one service context but use them on others, generally work as you would like. However once TDOs and tables are aged out of the cache, unexpected behavior can occur. This can lead to internal errors. </P><A NAME="1004676"></A><P CLASS="BP1">The section "The Object Cache and Memory Management" should explain from the start how the cache is logically partitioned and the importance of the service context. It does briefly mention that you have one copy of an object in the cache per connection; but the rest of the chapter makes no reference to this again. For instance, under the pinning section, it says if the object is already in the cache it will be retrieved. This is true only if it is in your logical partition of the cache, otherwise it will be fetched from the database again.</P><A NAME="1004684"></A><P CLASS="BP1">This has confused a number of customers in the past when they try to share objects between threads but end up with multiple copies.</P><A NAME="1004687"></A><P CLASS="BP1"><CODE>OCITypeByName()</CODE>, <CODE>OCITypeArrayByName()</CODE>, and <CODE>OCIObjectPinTable()</CODE> definitions should be updated to explain that:</P><UL CLASS="LB2"><LI CLASS="LB2" TYPE="DISC"><A NAME="1004689"></A>The service context should correspond to that of the logical partition in which the TDO or table definition will be used. <P><LI CLASS="LB2" TYPE="DISC"><A NAME="1004691"></A>If TDOs or tables are used across logical partitions, then the behavior is not known and may change between releases.<P></UL></UL><!-- Start Footer --></DIV><DIV CLASS="OUTD"><HR><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR><TD VALIGN="BOTTOM" WIDTH="33%"><TABLE CELLSPACING="0" CELLPADDING="0"><TR><TD ALIGN="CENTER"><A HREF="preface.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD><TD ALIGN="CENTER"><A HREF="ccref.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD> </TR></TABLE></TD><TD ALIGN="CENTER" WIDTH="34%"><font size="-2">Copyright © 2002 Oracle Corporation.</font><BR><FONT SIZE="-2">All Rights Reserved.</FONT></TD><TD VALIGN="BOTTOM" ALIGN="RIGHT" WIDTH="33%"> <TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="144"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE> </DIV></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -