Oracle UTL_HTTP.SET_WALLET应用

最新推荐文章于 2023-12-04 08:00:00 发布

跳跃生命线

最新推荐文章于 2023-12-04 08:00:00 发布

阅读量570

点赞数

分类专栏：技术类 #Oracle 文章标签： Oracle UTL_HTTP SET_WALLET

本文链接：https://blog.csdn.net/AlexLiu_2019/article/details/125121483

版权

技术类同时被 2 个专栏收录

148 篇文章 2 订阅

订阅专栏

#Oracle

50 篇文章 1 订阅

订阅专栏

Oracle UTL_HTTP.SET_WALLET应用

UTL_HTTP.SET_WALLET

SET_WALLET Procedure

This procedure sets the Oracle wallet used for all HTTP requests over Secured Socket Layer (SSL), namely HTTPS. When the UTL_HTTP package communicates with an HTTP server over SSL, the HTTP server presents its digital certificate, which is signed by a certificate authority, to the UTL_HTTP package for identification purpose. The Oracle wallet contains the list of certificate authorities that are trusted by the user of the UTL_HTTP package. An Oracle wallet is required to make an HTTPS request.

Syntax

UTL_HTTP.SET_WALLET ( path IN VARCHAR2, password IN VARCHAR2 DEFAULT NULL);

Parameters

Table 169-52 SET_WALLET Procedure Parameters

Parameter Description

Parameter	Description
`path`	The directory path that contains the Oracle wallet. The format is `file:`. The format of wallet_path on a PC is, for example, `file:c:\WINNT\Profiles\\WALLETS`, and in Unix is, for example, `file:/home//wallets`. When the `UTL_HTTP` package is executed in the Oracle database server, the wallet is accessed from the database server. Therefore, the wallet path must be accessible from the database server.
`password`	The password needed to open the wallet. A second copy of a wallet in a wallet directory that may be opened without a password. That second copy of the wallet is read-only. If the `password` is `NULL`, the `UTL_HTTP` package will open the second, read-only copy of the wallet instead.

path

The directory path that contains the Oracle wallet. The format is file:.

The format of wallet_path on a PC is, for example, file:c:\WINNT\Profiles\\WALLETS, and in Unix is, for example, file:/home//wallets. When the UTL_HTTP package is executed in the Oracle database server, the wallet is accessed from the database server. Therefore, the wallet path must be accessible from the database server.

password

The password needed to open the wallet. A second copy of a wallet in a wallet directory that may be opened without a password. That second copy of the wallet is read-only. If the password is NULL, the UTL_HTTP package will open the second, read-only copy of the wallet instead.

Usage Notes

To set up an Oracle wallet, use the Oracle Wallet Manager to create a wallet. In order for the HTTPS request to succeed, the certificate authority that signs the certificate of the remote HTTPS Web server must be a trust point set in the wallet.

When a wallet is created, it is populated with a set of well-known certificate authorities as trust points. If the certificate authority that signs the certificate of the remote HTTPS Web server is not among the trust points, or the certificate authority has new root certificates, you should obtain the root certificate of that certificate authority and install it as a trust point in the wallet using Oracle Wallet Manager