Procedure CLOB input with XML Text

[Sachin]

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 "

 

[Marco Kalter]

I cannot immediately reproduce this. Can you go to Help > Support Info and let me know the information from the "Info" tab page?

 

[Sachin]

Marco,

I had emailed you the information that you requested. Any updates on this?

 

[Marco Kalter]

I don't think we have received it. Can you resend it and refer to this forum post?

 

[Dimitrios]

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

 

[Sachin]

Marco,

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