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  |
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 #306131 is a reply to message #306015] |
Wed, 12 March 2008 23:55  |
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 #306213 is a reply to message #306188] |
Thu, 13 March 2008 05:25 |
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.
|
|
|
|
Goto Forum:
Current Time: Fri Nov 22 00:19:33 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
