Here are the values
EVAL peReqs
PEREQS =
....5...10...15...20...25...30...35...40...45...50...55...60
1 '<soapenv:Envelope xmlns:soapenv=Ü
http://schemas.xmlsoap.org/'
61 'soap/envelope/Ü xmlns:ws=Ü
http://ws.police.zsmm.htm.org/Ü;><s'
121 'oapenv:Header><wsse:Security xmlns:wsse=Ü
http://docs.oasis-o'
181 'pen.org/wss/2004/01/oasis-200401-wsswssecurity-secext-1.0.xs'
241 'dÜ><wsse:UsernameToken xmlns:wsu=Ü
http://docs.oasis-open.org'
301 '/wss/2004/01/oasis-200401-wsswssecurity-utility-1.0.xsdÜ xml'
361 'ns:wsse=Ü
http://docs.oasis-open.org/wss/2004/01/oasis-200401'
421 '-wsswssecurity-secext-1.0.xsdÜ><wsse:Username xmlns:wsse=Üht'
481 'tp://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecu'
541 'rity-secext-1.0.xsdÜ>anadolu</wsse:Username><wsse:KurumKod x'
601 'mlns:wsse=Ü
http://docs.oasis-open.org/wss/2004/01/oasis-2004'
661 '01-wss-wssecurity-secext-1.0.xsdÜ>007</wsse:KurumKod></wsse:'
721 'UsernameToken></wsse:Security></soapenv:Header><soapenv:Body'
781 '><ws:policeGunlukMutabakat><policeHareketSorgu><mutabakatTar'
841 'ihi>2020-07-20T00:00:00.000+03:00</mutabakatTarihi></policeH'
901 'areketSorgu></ws:policeGunlukMutabakat></soapenv:Body></soap'
961 'env:Envelope> '
1021 ' '
EVAL l
L_LEN OF L = 1077952576
L_DATA OF L =
....5...10...15...20...25...30...35...40...45...50...55...60
1 '<soapenv:Envelope xmlns:soapenv="
http://schemas.xmlsoap.org/'
61 'soap/envelope/" xmlns:ws="
http://ws.police.zsmm.htm.org/";><s'
121 'oapenv:Header><wsse:Security xmlns:wsse="
http://docs.oasis-o'
181 'pen.org/wss/2004/01/oasis-200401-wsswssecurity-secext-1.0.xs'
241 'd"><wsse:UsernameToken xmlns:wsu="
http://docs.oasis-open.org'
301 '/wss/2004/01/oasis-200401-wsswssecurity-utility-1.0.xsd" xml'
361 'ns:wsse="
http://docs.oasis-open.org/wss/2004/01/oasis-200401'
421 '-wsswssecurity-secext-1.0.xsd"><wsse:Username xmlns:wsse="ht'
481 'tp://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecu'
541 'rity-secext-1.0.xsd">anadolu</wsse:Username><wsse:KurumKod x'
601 'mlns:wsse="
http://docs.oasis-open.org/wss/2004/01/oasis-2004'
661 '01-wss-wssecurity-secext-1.0.xsd">007</wsse:KurumKod></wsse:'
721 'UsernameToken></wsse:Security></soapenv:Header><soapenv:Body'
781 '><ws:policeGunlukMutabakat><policeHareketSorgu><mutabakatTar'
841 'ihi>2020-07-20T00:00:00.000+03:00</mutabakatTarihi></policeH'
901 'areketSorgu></ws:policeGunlukMutabakat></soapenv:Body></soap'
961 'env:Envelope> '
1021 ' '
--
Thank you,
Nihat
-----Özgün İleti-----
Kimden: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> Yerine Jon Paris
Tarih: Tuesday, August 18, 2020 7:40 PM
Kime: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Konu: Re: SQL0311 error
DİKKAT: Bu e-posta kurum dışından gönderilmiştir. Zararlı dosya veya bağlantılar (link) içerebilir. Kaynağından emin olmadığınız dosyaları/bağlantıları (link) açarken veya e-postayı cevaplarken dikkatli olunuz.
________________________________
Have you checked to see if the values you are inserting have a valid length? Debug is your friend.
On Aug 18, 2020, at 12:14 PM, Nihat Ezer via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
Greetings,
create table log_table (
fwsad varchar(50),
freqs xml,
facklm varchar(120),
fhtkod varchar(20),
);
I have a scenario, which sends xml request and receives response then
invokes the following procedure within service program that writes the
log_table above
peReqs is the xml request itself in character, after assigning it to
the pre-compiler expanded field (l_data) successfully, i receive the
sql0311 (Length in varying-length, LOB, or XML host variable not
valid) while inserting
dcl-pi log_table_insert ind;
pedsLog_table likeds(dstLog_table) const;
peReqs varchar(1200) const;
peHataMesaji varchar(100);
end-pi;
dcl-s l sqltype(clob:9999)
// here we go
l_data = peReqs;
exec SQL
insert into fgLog_table
values (
:pedsLog_table.fwsad,
:l,
:pedsLog_table.facklm,
:pedsLog_table.fhtkod)
with nc;
Seen the following link as well, which did not help much as i did not
understand https://archive.midrange.com/rpg400-l/201407/msg00159.html
--
Thank you,
Nihat
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
