Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Built−in Packages- P163

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

Oracle Built−in Packages- P163: Ah, for the good old days of Version 1.0 of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms 3.0, and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk 17.4.1.3.1 Exceptions The GET_ARG_TYPE function may raise the following exception Name Number Description NO_DATA_FOUND -100 Specified argument does not exist for specified RPC call 17.4.1.3.2 Example This example shows how you use the GET_ARG_TYPE function to determine the datatypes of a queued call 1 DECLARE 2 vDataType NUMBER 3 BEGIN 4 vDataType DBMS_DEFER_QUERY.GET_ARG_TYPE 5 callno 9929966326029 6 deferred_tran_db D7CA.BIGWHEEL.COM 7 arg_no 3 8 deferred_tran_id 3.58.14 9 dbms_output.put_line Datatype for arg 1 is vDataType 10 END SYSTEM@D7CA SQL Datatype for arg 3 is 1 PL SQL procedure successfully completed. Here we see that the third argument passed to ProductMaint.AddProduct is of type VARCHAR2. Now you can use the GET_VARCHAR2_ARG function described in the next section to determine the value passed. 1 DECLARE 2 vArgValue VARCHAR2 80 3 BEGIN 4 vArgValue DBMS_DEFER_QUERY.GET_VARCHAR2_ARG 5 callno 9929966326029 6 deferred_tran_db D7CA.BIGWHEEL.COM 7 arg_no 3 8 deferred_tran_id 3.58.14 9 dbms_output.put_line Argument 3 is vArgValue 10 END SYSTEM@D7CA SQL Argument 3 is Mens 18 Speed Racer PL SQL procedure successfully completed. Here we see that the actual value passed was Mens 18 Speed Racer. 17.4.1.4 The DBMS_DEFER_QUERY.GET_CALL_ARGS procedure The GET_CALL_ARGS procedure allows you to obtain the datatypes and values for all arguments passed to a procedure in a single call. This is the easiest way to obtain information about the datatypes and values of all passed parameters. Here is the specification PROCEDURE DBMS_DEFER_QUERY.GET_CALL_ARGS callno IN NUMBER startarg IN NUMBER 1 argent IN NUMBER argsize IN NUMBER tran_db IN VARCHAR2 tran_id IN VARCHAR2 date_fmt IN VARCHAR2 types OUT TYPE_ARY vals OUT VAL_ARY 17.4.1 Getting Started with DBMS_DEFER_QUERY 801 Appendix A What s on the Companion Disk Parameters are summarized in the following table. Name Description callno The CALLNO of the RPC as stored in the DEFCALL data