Posted By: Sachin Procedure CLOB input with XML Text - 04/05/13 08:21 PM
If this has been asked and answered before, please let me know the link.
To replicate:

- Create a procedure with a clob input
- Goto Test Procedure
- Enter a valid XML string in the text input for the clob param
- Goto the XML tab - it validates successfully and shows "Load Success"
- Click on OK
- Go back into the clob edit (elipses)
- Only "<" is displayed
- XML tab displays an error:
Error: Whitespace is not allowed at this location.
Line: (1)
Text: <
File:


Of course, when the input never reaches the procedure.

Thanks,

Posted By: Marco Kalter Re: Procedure CLOB input with XML Text - 04/06/13 10:53 AM
I cannot immediately reproduce this. Can you go to Help > Support Info and let me know the information from the "Info" tab page?
Posted By: Sachin Re: Procedure CLOB input with XML Text - 04/16/13 09:38 PM
Marco,

I had emailed you the information that you requested. Any updates on this?
Posted By: Marco Kalter Re: Procedure CLOB input with XML Text - 04/17/13 08:13 AM
I don't think we have received it. Can you resend it and refer to this forum post?
Posted By: Dimitrios Re: Procedure CLOB input with XML Text - 07/26/13 09:53 AM
Hi, I have a procedure that accepts a clob as a parameter. When i am using the test windows with a temporary clob variable to pass the parameter in the procedure PSD exhibits the same behaviour as reported by Sachin. In addition when i try to execute the process i get a lpx-00283(document encoding is UTF-8-based but default input is not) error as well. The xml was retrieved from PSD's large data editor following a call to dbms_xmlgen.getxml on the same database. To complicate thing even further if i insert the xml in a db column and select it then the procedure works fine. Can you please look into this? I will send the PSD support infor on a separate email
Posted By: Sachin Re: Procedure CLOB input with XML Text - 09/24/13 05:07 PM
Marco,

Any updates on this? I believe I have sent you the support info at least 2/3 times.
© Allround Automations forums