Home » Developer & Programmer » JDeveloper, Java & XML » CLOB isn't accepting more than 32767 char (Oracle 9i, Windows XP)
CLOB isn't accepting more than 32767 char [message #306009] Wed, 12 March 2008 09:56 Go to next message
ps51517
Messages: 3
Registered: March 2008
Junior Member
Hi,
I've a procedure wherein I'm taking XML string as an i/p to a procedure. The i/p parameter has a clob datatype. The SP throws the following error whenever i pass an XML string, to the I/p clob parameter, whose length is more than 32767 char.

ORA-06502: PL/SQL: numeric or value error string

The thing that baffles me most is, when i try to execute the same query in an anonymous pl/sql block, it runs absolutely fine, but fails when i try the same using SP. I'm using pl/sql developer 6.0.6.947.

Can anyone please help me?

Thanks in advance.

Anonymous Pl/Sql Block (Which runs successfully)
DECLARE 
  lcl	  CLOB;
BEGIN

  lcl:= '<ROWSET><ROW><PK>7751</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>5</CONTACT_TYPE_ID><CONTACT_TYPE>Tech</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>s</MI><LAST_NAME>2</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>dthdgh</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>382424</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>TL</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7753</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>s</MI><LAST_NAME>4</LAST_NAME><PHONE>98887</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>hhh</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>101</COUNTRY_ID><ZIP_CODE>457666</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>CFO</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7754</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>s</MI><LAST_NAME>5</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>hhhhh</ADDRESS><CITY>Pune</CITY><STATE>maharashtra</STATE><COUNTRY_ID>101</COUNTRY_ID><ZIP_CODE>382424</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>PM</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7755</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>6</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7756</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>7</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7757</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>8</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7758</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>9</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>amby_prateek@abc.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7759</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>10</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7760</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>11</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7761</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>12</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7762</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>13</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7763</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>14</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7764</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>15</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7765</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>16</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7766</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>17</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7767</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>18</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7768</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>19</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7769</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>20</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7770</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>21</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7771</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>22</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7772</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>23</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7773</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>24</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7774</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>25</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7775</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>26</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7776</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>27</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7777</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>28</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7778</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>29</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7779</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>30</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7780</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>31</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7781</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>32</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7782</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>33</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7783</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>34</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7784</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>35</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7785</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>36</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7786</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>37</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7787</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>38</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7788</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>39</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7789</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>40</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7790</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>41</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7791</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>42</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7792</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>43</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7793</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>44</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7794</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>45</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7795</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>46</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7796</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>47</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7797</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>48</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7798</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>49</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7799</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>50</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7800</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>51</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7801</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>52</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7802</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>53</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7803</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>54</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7804</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>55</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7805</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>56</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7806</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>57</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7807</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>58</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7808</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>59</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7809</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>60</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7810</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>61</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7811</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>62</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7812</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>63</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7813</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>64</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7814</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>65</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7815</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>66</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7816</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>67</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7817</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>68</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7818</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>69</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7819</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>70</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7820</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>71</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7821</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>72</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7822</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>7</CONTACT_TYPE_ID><CONTACT_TYPE>HR</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>73</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>Clerk</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW><ROW><PK>7823</PK><SESSION_ID>8C10BE21A693456080572C217BC6BD46</SESSION_ID><CONTACT_ID>null</CONTACT_ID><SUPPLIER_ID>4</SUPPLIER_ID><CONTACT_TYPE_ID>6</CONTACT_TYPE_ID><CONTACT_TYPE>Sales</CONTACT_TYPE><FIRST_NAME>Floyd</FIRST_NAME><MI>P</MI><LAST_NAME>74</LAST_NAME><PHONE>1234</PHONE><EMAIL_ID>sunil@satyam.com</EMAIL_ID><FAX>3333</FAX><ADDRESS>abc</ADDRESS><CITY>Mumbai</CITY><STATE>maharashtra</STATE><COUNTRY_ID>109</COUNTRY_ID><ZIP_CODE>333333</ZIP_CODE><SUP_CONT_DESC>this is my note</SUP_CONT_DESC><DESIGNATION_TITLE>AVP</DESIGNATION_TITLE><STATUS>A</STATUS><CREATED_BY>1047</CREATED_BY><CREATED_DATE>03/12/2008</CREATED_DATE></ROW></ROWSET>';

    BEGIN
      UPDATE MIS_CARD_READER_TEMP MCRT 
         SET (contact_type, contact_type_id, first_name, mi, last_name, phone, 
              email_id, fax, address, city, state, country_id, zip_code, 
              sup_cont_desc, designation_title, status, created_by, created_date) = 
         (
          SELECT extractvalue(value(xml_table),'ROW/CONTACT_TYPE')     
                                              AS CONTACT_TYPE,
            		 extractvalue(value(xml_table),'ROW/CONTACT_TYPE_ID')  
                                              AS CONTACT_TYPE_ID,
            		 extractvalue(value(xml_table),'ROW/FIRST_NAME')       
                                              AS FIRST_NAME,
            		 extractvalue(value(xml_table),'ROW/MI')               
                                              AS MI,
            		 extractvalue(value(xml_table),'ROW/LAST_NAME')        
                                              AS LAST_NAME,
            		 extractvalue(value(xml_table),'ROW/PHONE')            
                                              AS PHONE,
            		 extractvalue(value(xml_table),'ROW/EMAIL_ID')         
                                              AS EMAIL_ID,
            		 extractvalue(value(xml_table),'ROW/FAX')              
                                              AS FAX,
            		 extractvalue(value(xml_table),'ROW/ADDRESS')          
                                              AS ADDRESS,
            		 extractvalue(value(xml_table),'ROW/CITY')             
                                              AS CITY,
            		 extractvalue(value(xml_table),'ROW/STATE')
                                              AS STATE,
            		 extractvalue(value(xml_table),'ROW/COUNTRY_ID')
                                              AS COUNTRY_ID,
            		 extractvalue(value(xml_table),'ROW/ZIP_CODE')         
                                              AS ZIP_CODE,
            		 extractvalue(value(xml_table),'ROW/SUP_CONT_DESC')      
                                              AS SUP_CONT_DESC,
            		 extractvalue(value(xml_table),'ROW/DESIGNATION_TITLE') 
                                              AS DESIGNATION_TITLE, 
            		 extractvalue(value(xml_table),'ROW/STATUS')      
                                              AS STATUS,
                 extractvalue(value(xml_table),'ROW/CREATED_BY')      
                                              AS CREATED_BY,
            		 to_date(extractvalue(value(xml_table),'ROW/CREATED_DATE'), 'MM/DD/YYYY') 
                                              AS CREATED_DATE
            FROM TABLE (CAST (xmlsequence(
                                          extract(XMLTYPE(lcl),
                                          '/ROWSET/ROW')
                                         ) 
                        AS xmlsequencetype)
                       ) xml_table
           WHERE extractvalue(value(xml_table),'ROW/PK')= MCRT.card_reader_id
         ) 
       WHERE MCRT.card_reader_id IN
               (
                SELECT extractvalue(value(xml_table_where),'ROW/PK')
                 FROM TABLE (
                             CAST (xmlsequence(
                                                extract(XMLTYPE(lcl),
                                                '/ROWSET/ROW')
                                               )
                             AS xmlsequencetype) 
                            ) xml_table_where
               );

    --for testing purpose...start...
    INSERT INTO DYNA_TEST VALUES ('success', 1);
	 --for testing purpose...end...

    EXCEPTION
      WHEN OTHERS THEN
        --Error encountered while updating records
        --for testing purpose...start...
        INSERT INTO DYNA_TEST VALUES ('failure', 1);
        --for testing purpose...end...
        --Terminate SP execution on error, without saving.
        RETURN;
    END;

	 COMMIT;
	 
END;


SP Code (Which fails)

PROCEDURE MIS_DATA_TRANSFER_SP
    (
     p_xml_data   IN  CLOB,
     p_login_user IN  NUMBER,
     p_error_no   OUT NUMBER,
     p_error_set  OUT MIS_GLOBAL_PKG.RC
    ) IS
  
  /****************************************************************************
  -- Procedure      : MIS_DATA_TRANSFER_SP
  -- Author         : Prateek Singh(PS51517)
  -- Created date   : 08-Dec-2007
****************************************************************************/
  -- Local Variable Declaration
  ll_xml_data              CLOB;
  ln_login_user            MIS_CARD_READER_TEMP.created_by%TYPE;
  
  BEGIN
    -- Local Variable Initialization
    p_error_no      := 1; --Return 1 on successful operation of the SP.
    ll_xml_data     := p_xml_data;
    ln_login_user   := p_login_user;

    --Update the MIS_CARD_READER_TEMP table 
    BEGIN
      UPDATE MIS_CARD_READER_TEMP MCRT 
         SET (contact_type, contact_type_id, first_name, mi, last_name, phone, 
              email_id, fax, address, city, state, country_id, zip_code, 
              sup_cont_desc, designation_title, status, created_by, created_date) = 
         (
          SELECT extractvalue(value(xml_table),'ROW/CONTACT_TYPE')     
                                              AS CONTACT_TYPE,
            		 extractvalue(value(xml_table),'ROW/CONTACT_TYPE_ID')  
                                              AS CONTACT_TYPE_ID,
            		 extractvalue(value(xml_table),'ROW/FIRST_NAME')       
                                              AS FIRST_NAME,
            		 extractvalue(value(xml_table),'ROW/MI')               
                                              AS MI,
            		 extractvalue(value(xml_table),'ROW/LAST_NAME')        
                                              AS LAST_NAME,
            		 extractvalue(value(xml_table),'ROW/PHONE')            
                                              AS PHONE,
            		 extractvalue(value(xml_table),'ROW/EMAIL_ID')         
                                              AS EMAIL_ID,
            		 extractvalue(value(xml_table),'ROW/FAX')              
                                              AS FAX,
            		 extractvalue(value(xml_table),'ROW/ADDRESS')          
                                              AS ADDRESS,
            		 extractvalue(value(xml_table),'ROW/CITY')             
                                              AS CITY,
            		 extractvalue(value(xml_table),'ROW/STATE')
                                              AS STATE,
            		 extractvalue(value(xml_table),'ROW/COUNTRY_ID')
                                              AS COUNTRY_ID,
            		 extractvalue(value(xml_table),'ROW/ZIP_CODE')         
                                              AS ZIP_CODE,
            		 extractvalue(value(xml_table),'ROW/SUP_CONT_DESC')      
                                              AS SUP_CONT_DESC,
            		 extractvalue(value(xml_table),'ROW/DESIGNATION_TITLE') 
                                              AS DESIGNATION_TITLE, 
            		 extractvalue(value(xml_table),'ROW/STATUS')      
                                              AS STATUS,
                 extractvalue(value(xml_table),'ROW/CREATED_BY')      
                                              AS CREATED_BY,
            		 to_date(extractvalue(value(xml_table),'ROW/CREATED_DATE'), 'MM/DD/YYYY') 
                                              AS CREATED_DATE
            FROM TABLE (CAST (xmlsequence(
                                          extract(XMLTYPE(ll_xml_data),
                                          '/ROWSET/ROW')
                                         ) 
                        AS xmlsequencetype)
                       ) xml_table
           WHERE extractvalue(value(xml_table),'ROW/PK')= MCRT.card_reader_id
         ) 
       WHERE MCRT.card_reader_id IN
               (
                SELECT extractvalue(value(xml_table_where),'ROW/PK')
                 FROM TABLE (
                             CAST (xmlsequence(
                                                extract(XMLTYPE(ll_xml_data),
                                                '/ROWSET/ROW')
                                               )
                             AS xmlsequencetype) 
                            ) xml_table_where
               );
    
    EXCEPTION
      WHEN OTHERS THEN
        --Error encountered while updating records
        p_error_no := 21000;
        --Terminate SP execution on error, without saving.
        RETURN;
    END;

Re: CLOB isn't accepting more than 32767 char [message #306015 is a reply to message #306009] Wed, 12 March 2008 10:05 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
This has to do with the limitations of the environment that you are passing the string from. Within a PL/SQL block, there is no problem. But when passing from SQL*Plus or some other environment, you are limited by the size that string can have in that environment. You might try passing the values as concatenated smaller strings and see if that works.
Re: CLOB isn't accepting more than 32767 char [message #306131 is a reply to message #306015] Wed, 12 March 2008 23:55 Go to previous messageGo to next message
ps51517
Messages: 3
Registered: March 2008
Junior Member
Hi Barbara,
I'm using the same environment for both anonymous pl/sql block and SP.

Yes, it works perfectly fine if the string length is smaller than 32767 char but i have a requirement wherein my XML string will def. cross 50000 char and that's why i opted for CLOB.

I'm pretty much sure it has to do with my SP or the way am handling the parameter because I have Java as UI and they can easily pass an XML string whose length is more than 32767 char. Also, if i move this piece of code, anonymous one, to Java it works fine. But due to some limitations, imposed by client, i can't have SQL Queries in UI. Hence the only option left is SP.

Coming back to environment part, do i have to set some variables or parameters in DB or is my way handling CLOB correct?

Re: CLOB isn't accepting more than 32767 char [message #306188 is a reply to message #306131] Thu, 13 March 2008 03:37 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I agree with Barbara, that the problem is most likely the way you PASS the CLOB from Java to Oracle.

When you send the anonymous procedure, you most likely just send the PL/SQL, and it's interpreted on the database side, so Java perhaps doesn't even know that a CLOB is involved.

When you call the procedure, do you use bind variables? And of what type is the bind variable for the CLOB?

Here is an example on how to handle CLOBs form JAVA, do you do it this way ?

http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/clob10g/handlingclobsinoraclejdbc10g.html

Re: CLOB isn't accepting more than 32767 char [message #306213 is a reply to message #306188] Thu, 13 March 2008 05:25 Go to previous message
ps51517
Messages: 3
Registered: March 2008
Junior Member
Hi Thomas,
Thanks a lot. It's working now. My UI counterpart fixed the Java problem. He's not calling it properly. Now he created one Clob variable in Java to call it instead of string buffer. (At least that's what i understood. He went through the link you posted.)

It's Working now.

Hi Barbara,
Thanks a lot. The error was with the environment.
Previous Topic: JSP communication with form
Next Topic: Compatible JDBC driver for Oracle 10.1.0.4
Goto Forum:
  


Current Time: Fri Mar 29 06:43:17 CDT 2024