tag:blogger.com,1999:blog-4677316190423110840.post9041658468008666509..comments2023-08-25T13:49:41.382+02:00Comments on Software Engineer Thoughts: ORA-30625 and XMLTypePaweł Baruthttp://www.blogger.com/profile/16867021334037413869noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-4677316190423110840.post-87218551971279776782012-08-27T20:58:46.536+02:002012-08-27T20:58:46.536+02:00Thank you very much for posting parts of your expe...Thank you very much for posting parts of your experience. It is very helpful to us the begginers.Wilson Blancohttps://www.blogger.com/profile/15494060834976647028noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-23684713168460633522012-03-21T18:29:27.980+01:002012-03-21T18:29:27.980+01:00Thank you Pawel. This was really help me to iorn o...Thank you Pawel. This was really help me to iorn out the NULL error and saved me ton of timeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-74686095581313686152012-03-09T14:07:15.578+01:002012-03-09T14:07:15.578+01:00Thanks for your helpful note and clear explanation...Thanks for your helpful note and clear explanations.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-38793981039618578252011-04-04T14:02:27.000+02:002011-04-04T14:02:27.000+02:00thanks for this! - it saved me a lot of timethanks for this! - it saved me a lot of timeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-4745633337770530592010-07-21T15:25:36.574+02:002010-07-21T15:25:36.574+02:00Thank you Paweł for your kind and clear notes on O...Thank you Paweł for your kind and clear notes on Oracle. I find great help in them.<br /><br />Dzięki Paweł!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-26764851007008772882007-11-29T15:42:00.000+01:002007-11-29T15:42:00.000+01:00hi,i have tried all the combinations with namespac...hi,<BR/><BR/>i have tried all the combinations with namespace and without namespaces and i cant get the existsnode function working. i m getting a valid soap response. but its the RESP.EXTRACT bit with the xpath xpression which is not working at all, and i have exhausted my resources...<BR/><BR/>unable to post my soap response here as it says html tag cannot be accepted. <BR/><BR/>any help appreciated...<BR/>SriSShttps://www.blogger.com/profile/09299608740210130960noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-18006000466407310882007-11-29T15:08:00.000+01:002007-11-29T15:08:00.000+01:00Hi,Might by you need to provide proper namespace./...Hi,<BR/><BR/>Might by you need to provide proper namespace.<BR/><BR/>/PawełPaweł Baruthttps://www.blogger.com/profile/16867021334037413869noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-69428437962723055812007-11-29T13:16:00.000+01:002007-11-29T13:16:00.000+01:00Hi,I m trying to use XPath expression to check for...Hi,<BR/><BR/>I m trying to use XPath expression to check for a node exists or not and the response is a soap response.<BR/><BR/>If RESP.EXISTSNODE('//ProcessOperationsResult/Response/OperationResponse/NewEnquiryResponse/Enquiry/EnquiryNumber') = 1 then<BR/><BR/>IF RESP.extract('//ProcessOperationsResult/Response/OperationResponse/NewEnquiryResponse/Enquiry/ExternalSystemReference/text()','xmlns=""') IS NULL THEN<BR/><BR/>the above 2 commands are not working for me at all and goes into exception raising ora-30625.<BR/><BR/>Can you let me know what i m doing wrong here. <BR/><BR/>btw, i have a valid soap response coming back and i can post the soap response here.<BR/><BR/>Thanks<BR/><BR/>SSShttps://www.blogger.com/profile/09299608740210130960noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-6276005397861980682007-09-28T17:13:00.000+02:002007-09-28T17:13:00.000+02:00Hi Pawel,You can also just test if the node is nul...Hi Pawel,<BR/>You can also just test if the node is null, before applying getStringVal.<BR/>IF xmlobject.existsNode('/croinfo') = 1 THEN<BR/> IF xmlobject.extract('/croinfo/text()') IS NULL THEN<BR/> address1 := NULL;<BR/> ELSE<BR/> address1 := xmlobject.extract('/croinfo/text()').getstringval();<BR/> END IF;<BR/>END IF;Unknownhttps://www.blogger.com/profile/05132285835912791620noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-76480374351453863092007-09-12T09:33:00.000+02:002007-09-12T09:33:00.000+02:00Thanks Paweł. I was getting Oracle error ORA-3062...Thanks Paweł. I was getting Oracle error ORA-30625: method dispatch on NULL SELF disallowed. and you gave me the solution. It isn't possible to call the method and see if it returns null, the correct way is to test first, then call the method if it isn't null.Ronald Weetabixhttps://www.blogger.com/profile/05454313054561794279noreply@blogger.com