CAN CSA-ISO IEC 9075-13-2009 Information technology - Database languages - SQL - Part 13 SQL Routines and Types Using the Java Programming Language (SQL JRT) (Incorporates Corrigen.pdf

1、Information technology Database languages SQL Part 13: SQL Routines and Types Using the JavaTMProgramming Language (SQL/JRT)CAN/CSA-ISO/IEC 9075-13-09National Standard of Canada(ISO/IEC 9075-13:2008, IDT)NOT FOR RESALE.PUBLICATION NON DESTINE LA REVENTE.Legal Notice for StandardsCanadian Standards A

2、ssociation (CSA) standards are developed through a consensus standards development process approved by the Standards Council of Canada. This process brings together volunteers representing varied viewpoints and interests to achieve consensus and develop a standard. Although CSA administers the proce

3、ss and establishes rules to promote fairness in achieving consensus, it does not independently test, evaluate, or verify the content of standards.Disclaimer and exclusion of liabilityThis document is provided without any representations, warranties, or conditions of any kind, express or implied, inc

4、luding, without limitation, implied warranties or conditions concerning this documents fitness for a particular purpose or use, its merchantability, or its non-infringement of any third partys intellectual property rights. CSA does not warrant the accuracy, completeness, or currency of any of the in

5、formation published in this document. CSA makes no representations or warranties regarding this documents compliance with any applicable statute, rule, or regulation. IN NO EVENT SHALL CSA, ITS VOLUNTEERS, MEMBERS, SUBSIDIARIES, OR AFFILIATED COMPANIES, OR THEIR EMPLOYEES, DIRECTORS, OR OFFICERS, BE

6、 LIABLE FOR ANY DIRECT, INDIRECT, OR INCIDENTAL DAMAGES, INJURY, LOSS, COSTS, OR EXPENSES, HOWSOEVER CAUSED, INCLUDING BUT NOT LIMITED TO SPECIAL OR CONSEQUENTIAL DAMAGES, LOST REVENUE, BUSINESS INTERRUPTION, LOST OR DAMAGED DATA, OR ANY OTHER COMMERCIAL OR ECONOMIC LOSS, WHETHER BASED IN CONTRACT,

7、TORT (INCLUDING NEGLIGENCE), OR ANY OTHER THEORY OF LIABILITY, ARISING OUT OF OR RESULTING FROM ACCESS TO OR POSSESSION OR USE OF THIS DOCUMENT, EVEN IF CSA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, INJURY, LOSS, COSTS, OR EXPENSES.In publishing and making this document available, CSA is

8、not undertaking to render professional or other services for or on behalf of any person or entity or to perform any duty owed by any person or entity to another person or entity. The information in this document is directed to those who have the appropriate degree of experience to use and apply its

9、contents, and CSA accepts no responsibility whatsoever arising in any way from any and all use of or reliance on the information contained in this document. CSA is a private not-for-profit company that publishes voluntary standards and related documents. CSA has no power, nor does it undertake, to e

10、nforce compliance with the contents of the standards or other documents it publishes. Intellectual property rights and ownershipAs between CSA and the users of this document (whether it be in printed or electronic form), CSA is the owner, or the authorized licensee, of all works contained herein tha

11、t are protected by copyright, all trade-marks (except as otherwise noted to the contrary), and all inventions and trade secrets that may be contained in this document, whether or not such inventions and trade secrets are protected by patents and applications for patents. Without limitation, the unau

12、thorized use, modification, copying, or disclosure of this document may violate laws that protect CSAs and/or others intellectual property and may give rise to a right in CSA and/or others to seek legal redress for such use, modification, copying, or disclosure. To the extent permitted by licence or

13、 by law, CSA reserves all intellectual property rights in this document.Patent rightsAttention is drawn to the possibility that some of the elements of this standard may be the subject of patent rights. CSA shall not be held responsible for identifying any or all such patent rights. Users of this st

14、andard are expressly advised that determination of the validity of any such patent rights is entirely their own responsibility.Authorized use of this documentThis document is being provided by CSA for informational and non-commercial use only. The user of this document is authorized to do only the f

15、ollowing:If this document is in electronic form:.load this document onto a computer for the sole purpose of reviewing it;.search and browse this document; and.print this document if it is in PDF format. Limited copies of this document in print or paper form may be distributed only to persons who are

16、 authorized by CSA to have such copies, and only if this Legal Notice appears on each such copy.In addition, users may not and may not permit others to.alter this document in any way or remove this Legal Notice from the attached standard;.sell this document without authorization from CSA; or.make an

17、 electronic copy of this document.If you do not agree with any of the terms and conditions contained in this Legal Notice, you may not load or use this document or make any copies of the contents hereof, and if you do make such copies, you are required to destroy them immediately. Use of this docume

18、nt constitutes your acceptance of the terms and conditions of this Legal Notice.Information technology Database languages SQL Part 13: SQL Routines and Types Using the JavaTMProgramming Language (SQL/JRT)TECHNICAL CORRIGENDUM 1Technical Corrigendum 1:2012 (IDT) toNational Standard of CanadaCAN/CSA-I

19、SO/IEC 9075-13:09(ISO/IEC 9075-13:2008, IDT)NOT FOR RESALE.PUBLICATION NON DESTINE LA REVENTE.CSA Standards Update ServiceTechnical Corrigendum 1:2012 toCAN/CSA-ISO/IEC 9075-13:09March 2012Title:Information technology Dat abase languages SQL Par t 13: SQL Routines and Types Using the JavaTMProgrammi

20、ng Language (SQL/JRT)Pagination: 3 pagesTo register for e-mail notification about any updates to this publication go on-line to shop.csa.caclick on E-mail Services under MY ACCOUNTclick on CSA Standards Update ServiceThe List ID that you will need to register for updates to this publication is 24199

21、03.If you require assistance, please e-mail techsupportcsa.ca or call 416-747-2233.Visit CSAs policy on privacy at csagroup.org/legal to find out how we protect your personal information.ICS 35.060 Ref. No. ISO/IEC 9075-13:2008/Cor.1:2010(E) ISO/IEC 2010 All rights reserved INTERNATIONAL STANDARD IS

22、O/IEC 9075-13:2008 TECHNICAL CORRIGENDUM 1 Published 2010-06-01 INTERNATIONAL ORGANIZATION FOR STANDARDIZATION ORGANISATION INTERNATIONALE DE NORMALISATIONINTERNATIONAL ELECTROTECHNICAL COMMISSION COMMISSION LECTROTECHNIQUE INTERNATIONALEInformation technology Database languages SQL Part 13: SQL Rou

23、tines and Types Using the Java Programming Language (SQL/JRT) TECHNICAL CORRIGENDUM 1 Technologies de linformation Langages de base de donnes SQL Partie 13: Routines et types de SQL utilisant le langage de programmation Java (SQL/JRT) RECTIFICATIF TECHNIQUE 1 Technical Corrigendum 1 to ISO/IEC 9075-

24、13:2008 was prepared by Joint Technical Committee ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange. Statement of purpose for rationale A statement indicating the rationale for each change to ISO/IEC 9075-13:2008 is included. This is to inform the users of IS

25、O/IEC 9075-13:2008 why it was judged necessary to change the original wording. In many cases, the reason is editorial or to clarify the wording; in some cases, it is to correct an error or an omission in the original wording. Notes on numbering Where this Technical Corrigendum introduces new Syntax,

26、 Access, General, and Conformance Rules, the new rules have been numbered as follows: Rules inserted between, for example, Rules 7) and 8) are numbered 7.1), 7.2), etc. or 7)a.1), 7)a.2), etc. Those inserted before Rule 1) are numbered 0.1), 0.2), etc. Where this Technical Corrigendum introduces new

27、 subclauses, the new subclauses have been numbered as follows: Subclauses inserted between, for example, 4.3.2 and 4.3.3 are numbered 4.3.2a, 4.3.2b, etc. Those inserted before, for example, 4.3.1 are numbered 4.3.0, 4.3.0a, etc. Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-13:09Contents Pag

28、e2 Normative references. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12.2 Other international standards. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

29、 . . . . . . . . . . . 1ii ISO/IEC 2010 All rights reservedISO/IEC 9075-13:2008/Cor.1:2010(E) Technical Corrigendum 1:2012 to CAN/CSA-ISO/IEC 9075-13:09Information technology Database languages SQL Part 13:SQL Routines this remains the continuing responsibility ofthe SDO. An NSC reflects a consensus

30、 of a number ofcapable individuals whose collective interests provide,to the greatest practicable extent, a balance ofrepresentation of general interests, producers,regulators, users (including consumers), and otherswith relevant interests, as may be appropriate to thesubject in hand. It normally is

31、 a standard which iscapable of making a significant and timely contributionto the national interest.Those who have a need to apply standards areencouraged to use NSCs. These standards are subjectto periodic review. Users of NSCs are cautionedto obtain the latest edition from the SDO whichpublishes t

32、he standard.The responsibility for approving standards asNational Standards of Canada rests with theStandards Council of Canada270 Albert Street, Suite 200Ottawa, Ontario, K1P 6N7CanadaAlthough the intended primary application of this Standard is stated in its Scope, it is importantto note that it r

33、emains the responsibility of the users to judge its suitability for their particular purpose.Registered trade-mark of Canadian Standards AssociationCette norme est offerte en anglais seulement pour le moment. La CSA publiera la version enfranais ds quelle sera produite par lorganisme rdacteur.Review

34、ed byNational Standard of CanadaPublished in October 2009 by Canadian Standards AssociationA not-for-profit private sector organization5060 Spectrum Way, Suite 100, Mississauga, Ontario, Canada L4W 5N61-800-463-6727 416-747-4044Visit our Online Store at www.ShopCSA.caApproved byStandards Council of

35、CanadaCAN/CSA-ISO/IEC 9075-13-09Information technology Database languages SQL Part 13: SQL Routines and Types Using the JavaTMProgramming Language (SQL/JRT)Prepared by International Organization for Standardization/ International Electrotechnical CommissionCAN/CSA-ISO/IEC 9075-13-09Information techn

36、ology Database languages SQL Part 13: SQLRoutines and Types Using the JavaTMProgramming Language (SQL/JRT)CSA/4 Canadian Standards Association October 2009CAN/CSA-ISO/IEC 9075-13-09Information technology Database languages SQL Part 13: SQL Routines and Types Using the JavaTMProgramming Language (SQL

37、/JRT)CSA PrefaceStandards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the Canadian Advisory Committee (CAC) on ISO/IEC Joint Technical Committee 1

38、 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and

39、Telephone Consultative Committee (ITU-T).This Standard supersedes CAN/CSA-ISO/IEC 9075-13-05 (adoption of ISO/IEC 9075-13:2003). At the time of publication, ISO/IEC 9075-13:2008 is available from ISO and IEC in English only. CSA will publish the French version when it becomes available from ISO and

40、IEC.This International Standard was reviewed by the CSA TCIT under the jurisdiction of the Strategic Steering Committee on Information Technology and deemed acceptable for use in Canada. From time to time, ISO/IEC may publish addenda, corrigenda, etc. The CSA TCIT will review these documents for app

41、roval and publication. For a listing, refer to the CSA Information Products catalogue or CSA Info Update or contact a CSA Sales representative. This Standard has been formally approved, without modification, by the Technical Committee and has been approved as a National Standard of Canada by the Sta

42、ndards Council of Canada.October 2009 Canadian Standards Association 2009All rights reserved. No part of this publication may be reproduced in any form whatsoever without the prior permission of the publisher. ISO/IEC material is reprinted with permission. Where the words “this International Standar

43、d” appear in the text, they should be interpreted as “this National Standard of Canada”.Inquiries regarding this National Standard of Canada should be addressed toCanadian Standards Association5060 Spectrum Way, Suite 100, Mississauga, Ontario, Canada L4W 5N61-800-463-6727 416-747-4000www.csa.caTo p

44、urchase CSA Standards and related publications, visit CSAs Online Store at www.ShopCSA.ca or call toll-free 1-800-463-6727 or 416-747-4044.CAN/CSA-ISO/IEC 9075-13-09Information technology Database languages SQL Part 13: SQLRoutines and Types Using the JavaTMProgramming Language (SQL/JRT)October 2009

45、 Canadian Standards Association CSA/5CSA Standards are subject to periodic review, and suggestions for their improvement will be referred to the appropriate committee. To submit a proposal for change to CSA Standards, please send the following information to inquiriescsa.ca and include “Proposal for

46、 change” in the subject line:(a) Standard designation (number);(b) relevant clause, table, and/or figure number;(c) wording of the proposed change; and(d) rationale for the change.Reference numberISO/IEC 9075-13:2008(E)ISO/IEC 2008INTERNATIONAL STANDARD ISO/IEC9075-13Third edition2008-07-15Informati

47、on technology Database languages SQL Part 13: SQL Routines and Types Using the Java Programming Language (SQL/JRT) Technologies de linformation Langages de base de donnes SQL Partie 13: Routines et types de SQL utilisant le langage de programmation Java (SQL/JRT) ISO/IEC 9075-13:2008(E) PDF disclaim

48、er This PDF file may contain embedded typefaces. In accordance with Adobes licensing policy, this file may be printed or viewed but shall not be edited unless the typefaces which are embedded are licensed to and installed on the computer performing the editing. In downloading this file, parties acce

49、pt therein the responsibility of not infringing Adobes licensing policy. The ISO Central Secretariat accepts no liability in this area. Adobe is a trademark of Adobe Systems Incorporated. Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation parameters were optimized for printing. Every care has been ta