SQL Server

CSR Get Extension Request

See more CSR Examples

If a CSR contains a 1.2.840.113549.1.9.14 extensionRequest, then this method will return the extension request in XML format.

Note: This example requires Chilkat v9.5.0.91 or greater.

SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- This requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @csr int
    EXEC @hr = sp_OACreate 'Chilkat.Csr', @csr OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Load a CSR PEM file.  The file should contain content that looks like this:
    -- 
    -- 	-----BEGIN CERTIFICATE REQUEST-----
    -- 	MII...
    -- 	....
    -- 	....
    -- 	....
    -- 	-----END CERTIFICATE REQUEST-----

    DECLARE @fac int
    EXEC @hr = sp_OACreate 'Chilkat.FileAccess', @fac OUT

    DECLARE @csrPem nvarchar(4000)
    EXEC sp_OAMethod @fac, 'ReadEntireTextFile', @csrPem OUT, 'qa_data/csr/sample.pem', 'utf-8'

    EXEC sp_OAMethod @csr, 'LoadCsrPem', @success OUT, @csrPem
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @csr, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @csr
        EXEC @hr = sp_OADestroy @fac
        RETURN
      END

    DECLARE @xml int
    EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT

    EXEC sp_OAMethod @csr, 'GetExtensionRequest', @success OUT, @xml
    IF @success <> 1
      BEGIN

        PRINT 'CSR has no extensionRequest.'
        EXEC @hr = sp_OADestroy @csr
        EXEC @hr = sp_OADestroy @fac
        EXEC @hr = sp_OADestroy @xml
        RETURN
      END

    DECLARE @xmlStr nvarchar(4000)
    EXEC sp_OAMethod @xml, 'GetXml', @xmlStr OUT

    PRINT @xmlStr

    -- Sample output:

    -- <?xml version="1.0" encoding="utf-8"?>
    -- <set>
    --     <sequence>
    --         <sequence>
    --             <oid>1.3.6.1.4.1.311.20.2</oid>
    --             <asnOctets>
    --                 <printable>ZATCA-Code-Signing</printable>
    --             </asnOctets>
    --         </sequence>
    --         <sequence>
    --             <oid>2.5.29.17</oid>
    --             <asnOctets>
    --                 <sequence>
    --                     <contextSpecific tag="4" constructed="1">
    --                         <sequence>
    --                             <set>
    --                                 <sequence>
    --                                     <oid>2.5.4.4</oid>
    --                                     <utf8>334623324234325</utf8>
    --                                 </sequence>
    --                             </set>
    --                             <set>
    --                                 <sequence>
    --                                     <oid>0.9.2342.19200300.100.1.1</oid>
    --                                     <utf8>310122393500003</utf8>
    --                                 </sequence>
    --                             </set>
    --                             <set>
    --                                 <sequence>
    --                                     <oid>2.5.4.12</oid>
    --                                     <utf8>0000</utf8>
    --                                 </sequence>
    --                             </set>
    --                             <set>
    --                                 <sequence>
    --                                     <oid>2.5.4.26</oid>
    --                                     <utf8>Sample E</utf8>
    --                                 </sequence>
    --                             </set>
    --                             <set>
    --                                 <sequence>
    --                                     <oid>2.5.4.15</oid>
    --                                     <utf8>Sample Business</utf8>
    --                                 </sequence>
    --                             </set>
    --                         </sequence>
    --                     </contextSpecific>
    --                 </sequence>
    --             </asnOctets>
    --         </sequence>
    --     </sequence>
    -- </set>

    -- Use this online tool to generate parsing code from sample XML: 
    -- Generate Parsing Code from XML

    EXEC @hr = sp_OADestroy @csr
    EXEC @hr = sp_OADestroy @fac
    EXEC @hr = sp_OADestroy @xml


END
GO