Print Thread
Procedure CLOB input with XML Text
#46730 04/05/13 08:21 PM
Joined: Mar 2007
Posts: 131
California, USA
Sachin Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 131
California, USA
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,



~Sachin.
Re: Procedure CLOB input with XML Text
Sachin #46731 04/06/13 10:53 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
I cannot immediately reproduce this. Can you go to Help > Support Info and let me know the information from the "Info" tab page?


Marco Kalter
Allround Automations
Re: Procedure CLOB input with XML Text
Marco Kalter #46851 04/16/13 09:38 PM
Joined: Mar 2007
Posts: 131
California, USA
Sachin Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 131
California, USA
Marco,

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


~Sachin.
Re: Procedure CLOB input with XML Text
Sachin #46855 04/17/13 08:13 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
I don't think we have received it. Can you resend it and refer to this forum post?


Marco Kalter
Allround Automations
Re: Procedure CLOB input with XML Text
Marco Kalter #47538 07/26/13 09:53 AM
Joined: Jul 2013
Posts: 3
D
Member
Offline
Member
D
Joined: Jul 2013
Posts: 3
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

Re: Procedure CLOB input with XML Text
Dimitrios #47894 09/24/13 05:07 PM
Joined: Mar 2007
Posts: 131
California, USA
Sachin Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 131
California, USA
Marco,

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


~Sachin.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.124s Queries: 14 (0.048s) Memory: 2.5168 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-04 04:03:28 UTC
Valid HTML 5 and Valid CSS