Click here to Skip to main content
15,899,679 members
Search within:


Unable to insert the below HTML code in the SQL query, please help me with this to get insert
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
XML
HTML
'"<html xmlns:o="urn:schemas-microsoft-com:office:office"
   xmlns:x="urn:schemas-microsoft-com:office:excel"
   xmlns="http://www.w3.org/TR/REC-html40">

   <head>
   <meta http-equiv=Content-Type content="text/html; charset=windows-1252">
   <meta name=ProgId content=Excel.Sheet>
   <meta name=Generator content="Microsoft Excel 11">
   <link rel=File-List href="Hdr_files/filelist.xml">
   <link rel=Edit-Time-Data href="Hdr_files/editdata.mso">
   <link rel=OLE-Object-Data href="Hdr_files/oledata.mso">
   <!--[if gte mso 9]><xml>
    <o:DocumentProperties>
     <o:Author>Merck</o:Author>
     <o:LastAuthor>Merck</o:LastAuthor>
     <o:Created>2009-04-27T10:55:21Z</o:Created>
     <o:LastSaved>2009-04-27T10:58:51Z</o:LastSaved>
     <o:Company>Merck Co., Inc.</o:Company>
     <o:Version>11.8122</o:Version>
    </o:DocumentProperties>
   </xml><![endif]-->
   <style>
   <!--table
      {mso-displayed-decimal-separator:"\.";
      mso-displayed-thousand-separator:"\,";}
    .xl25
      {mso-style-parent:style21;
      font-weight:700;
      font-family:"Trebuchet MS", sans-serif;
      mso-font-charset:0;
      text-align:center;
      border-top:1.0pt solid windowtext;
      border-right:none;
      border-bottom:1.0pt solid windowtext;
      border-left:1.0pt solid windowtext;
      background:#FFFF99;
      mso-pattern:black none;}
    .xl26
      {mso-style-parent:style21;
      font-weight:700;
      font-family:"Trebuchet MS", sans-serif;
      mso-font-charset:0;
      text-align:center;
      border-top:1.0pt solid windowtext;
      border-right:none;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      background:#FFFF99;
      mso-pattern:black none;}
    .xl27
      {mso-style-parent:style21;
      font-weight:700;
      font-family:"Trebuchet MS", sans-serif;
      mso-font-charset:0;
      text-align:center;
      border-top:1.0pt solid windowtext;
      border-right:1.0pt solid black;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      background:#FFFF99;
      mso-pattern:black none;}
    .xl28
      {mso-style-parent:style21;
      font-weight:700;
      font-family:"Trebuchet MS", sans-serif;
      mso-font-charset:0;
      text-align:center;
      border-top:none;
      border-right:.5pt solid windowtext;
      border-bottom:1.0pt solid windowtext;
      border-left:1.0pt solid windowtext;
      background:silver;
      mso-pattern:black none;}
    .xl29
      {mso-style-parent:style21;
      font-weight:700;
      font-family:"Trebuchet MS", sans-serif;
      mso-font-charset:0;
      text-align:center;
      border-top:none;
      border-right:.5pt solid windowtext;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      background:silver;
      mso-pattern:black none;}
    .xl30
      {mso-style-parent:style21;
      font-weight:700;
      font-family:"Trebuchet MS", sans-serif;
      mso-font-charset:0;
      text-align:center;
      border-top:none;
      border-right:1.0pt solid windowtext;
      border-bottom:1.0pt solid windowtext;
      border-left:none;
      background:silver;
      mso-pattern:black none;}
    .xl31
      {mso-style-parent:style0;
      mso-number-format:"Medium Date";}
   -->
   </style>
   <!--[if gte mso 9]><xml>
    <x:ExcelWorkbook>
     <x:ExcelWorksheets>
      <x:ExcelWorksheet>
       <x:Name>Sheet1</x:Name>
       <x:WorksheetOptions>
        <x:Selected/>
        <x:Panes>
         <x:Pane>
          <x:Number>3</x:Number>
          <x:ActiveRow>5</x:ActiveRow>
          <x:ActiveCol>4</x:ActiveCol>
         </x:Pane>
        </x:Panes>
        <x:ProtectContents>False</x:ProtectContents>
        <x:ProtectObjects>False</x:ProtectObjects>
        <x:ProtectScenarios>False</x:ProtectScenarios>
       </x:WorksheetOptions>
      </x:ExcelWorksheet>
     </x:ExcelWorksheets>
     <x:WindowHeight>9210</x:WindowHeight>
     <x:WindowWidth>11355</x:WindowWidth>
     <x:WindowTopX>480</x:WindowTopX>
     <x:WindowTopY>60</x:WindowTopY>
     <x:ProtectStructure>False</x:ProtectStructure>
     <x:ProtectWindows>False</x:ProtectWindows>
    </x:ExcelWorkbook>
   </xml><![endif]-->
   </head>

   <body link=blue vlink=purple>

   <table x:str border=0 cellpadding=0 cellspacing=0 width=637 style='border-collapse:
    collapse;table-layout:fixed;width:637pt'>
    <col width=105 style='mso-width-source:userset;mso-width-alt:3840;width:40pt'>
    <col width=81 style='mso-width-source:userset;mso-width-alt:2779;width:57pt'>
    <col width=80 style='mso-width-source:userset;mso-width-alt:2194;width:50pt'>
    <col width=96 style='mso-width-source:userset;mso-width-alt:1280;width:70pt'>
    <col width=112 style='mso-width-source:userset;mso-width-alt:3291;width:40pt'>
    <col width=115 style='width:mso-width-source:userset;mso-width-alt:5266;width:57pt'>
    <tr height=18 style='height:13.5pt'>
     <td width=89 style='width:79pt'></td>
     <td width=81 style='width:61pt'></td>
     <td width=80 style='width:60pt'></td>
     <td width=96 style='width:72pt'></td>
     <td width=112 style='width:84pt'></td>
     <td width=115 style='width:86pt'></td>
    </tr>
    <tr height=21 style='height:15.75pt'>
    <td colspan=6 class=xl25 style='border-right:1.0pt solid black'>Exported</td>
    </tr>
    <tr height=21 style='height:15.75pt'>
     <td class=xl28>Study</td>
     <td class=xl29>Vendor</td>
     <td class=xl29>eCRF</td>
     <td class=xl30>Production_Transfer_Fname</td>
     <td class=xl29>Actual_Transfer_Date</td>
     <td class=xl30>Transfer_Status</td>
	 <td class=xl30>Root_Cause</td>
    </tr>"'


What I have tried:

I have tries putting ' and " quotes but still not working, i need to submit this tommorow, please help
Posted
Updated 10-Dec-19 1:26am
v2
Add a Solution
Comments
Richard MacCutchan 10-Dec-19 6:44am    
That is just a lot of css and html that means nothing. Please edit your question and explain exactly what the problem is.
CHill60 10-Dec-19 7:27am    
If you want help then you will need to show us the code you are using to insert this into the database, explain which database and which language you are using and describe the error you are getting when you try to run your code - otherwise your submission is going to be late
ZurdoDev 10-Dec-19 13:50pm    
How can we help? You haven't told us what the error is. I'll bet the error tells you exactly what is wrong.
Member 14684152 11-Dec-19 4:33am    
Hi,

I need to insert above given code in the table support_reports_template in Sql developer,but i am getting the below errors:

SP2-0552: Bind variable "637" not declared.
SP2-0552: Error report -
ORA-06550: line 3, column 22:
PL/SQL: ORA-01704: string literal too long
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
please help me on this
CHill60 17-Dec-19 7:41am    
As I said earlier - you need to show us the code that your are using to insert this into your Oracle database. We can't see your screen, examine your hard disk nor read your mind!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Insert query not inserting records via javascript procedure in snowflake
How to insert html code into table using insert statement in Sql server
Please solve below sql query
Unable to insert contents into the database
Please help me in insert query
Need help in insert query
error with INSERT INTO query
Problem inserting into database
Please help me with the code below
Sql insert query failed

Advertise
Privacy
Cookies
Terms of Use
Last Updated 10 Dec 2019
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-05-14:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900