Re: SQL0311 error

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

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