关于DBMS_CRYPTO.HASH计算BLOB字段MD5的问题

本帖最后由 tiger_hs 于 2015-01-10 09:30:09 编辑

解决方案 »

  1.   

    给点数据，format 是你的列名吗？
      

  2.   

    1. FORMAT是表 FAST_REPORT的列明，字段类型 BLOB，保存的是报表文件。
    2. 关于数据：
    3.关于FORMAT的内容。 是fr3格式。
    <?xml version="1.0" encoding="utf-8"?>
    <TfrxReport Version="4.3" DotMatrixReport="false" EngineOptions.SilentMode="true" EngineOptions.NewSilentMode="simSilent" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="27801" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41969.5144373148" ReportOptions.Description.Text="" ReportOptions.LastChange="41969.5171071412" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." ShowProgress="false" PropData="044C656674026803546F70025008446174617365747301010C4B00000020446174615365743D22466F726D4853466173745265706F7274566965775F312E667278444244617461736574312220446174615365744E616D653D2266727844424461746173657431220000095661726961626C65730100055374796C650100">
      <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000"/>
      <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" Columns="2" ColumnWidth="95" ColumnPositions.Text="0&#13;&#10;95" HGuides.Text="" VGuides.Text="">
        <TfrxReportTitle Name="ReportTitle1" Height="56.69295" Left="0" Top="18.89765" Width="718.1107">
          <TfrxMemoView Name="Memo2" Left="166.29932" Top="7.55906" Width="332.59864" Height="18.89765" DisplayFormat.DecimalSeparator="." Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="false" Text="浣忛櫌鎮ｈ€呮瑺璐瑰簱瀛樿〃"/>
          <TfrxMemoView Name="Memo5" Left="18.89765" Top="37.7953" Width="75.5906" Height="18.89765" DisplayFormat.DecimalSeparator="." Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="false" Text="濮撳悕"/>
          <TfrxMemoView Name="Memo6" Left="109.60637" Top="37.7953" Width="75.5906" Height="18.89765" DisplayFormat.DecimalSeparator="." Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="false" Text="浣忛櫌鍙?/>
          <TfrxMemoView Name="Memo7" Left="204.09462" Top="37.7953" Width="75.5906" Height="18.89765" DisplayFormat.DecimalSeparator="." Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="false" Text="浣欓"/>
        </TfrxReportTitle>
        <TfrxMasterData Name="MasterData1" Height="30.23624" Left="0" Top="136.06308" Width="359.05535" Columns="1" ColumnWidth="0" ColumnGap="0" DataSet="FormHSFastReportView_1.frxDBDataset1" DataSetName="frxDBDataset1" RowCount="0">
          <TfrxMemoView Name="Memo1" Left="18.89765" Top="3.77953" Width="75.59055118" Height="18.89765" DataField="姓名" DataSet="FormHSFastReportView_1.frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="false" Text="[frxDBDataset1.&#34;濮撳悕&#34;]"/>
          <TfrxMemoView Name="Memo3" Left="109.60637" Top="3.77953" Width="79.37013" Height="18.89765" DataField="住院号" DataSet="FormHSFastReportView_1.frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="false" Text="[frxDBDataset1.&#34;浣忛櫌鍙?#34;]"/>
          <TfrxMemoView Name="Memo4" Left="204.09462" Top="3.77953" Width="79.37013" Height="18.89765" DataField="余额" DataSet="FormHSFastReportView_1.frxDBDataset1" DataSetName="frxDBDataset1" Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="false" Text="[frxDBDataset1.&#34;浣欓&#34;]"/>
        </TfrxMasterData>
      </TfrxReportPage>
    </TfrxReport>
    alse" Text="濮撳悕"/>
          <TfrxMemoView Name="Memo6" Left="109.60637" Top="37.7953" Width="75.5906" Height="18.89765" DisplayFormat.DecimalSeparator="." Font.Charset="1" Font.Color="-2147483640" Font.Height=
      

  3.   

    关于数据：第三方计算结果：fbb806b68e083c1cbf83deb2303169