Sitemap

Amicuk Programming Answers

PL/SQL Web service error

2015-10-11   Views:0

Advertisement

Hi I am trying to create a PL/SQL Webservice based on an Oracle package. It fails with "An expected error was encounted. Generation aborted." The exception stack trace is pasted below. Any help is appreciated. java.io.FileNotFoundException: D:\O

Hi
I am trying to create a PL/SQL Webservice based on an Oracle package. It fails with "An expected error was encounted. Generation aborted."
The exception stack trace is pasted below. Any help is appreciated.
java.io.FileNotFoundException: D:\OraBPELPM_1\integration\jdev\jdev\mywork\BPEL_Synch_Asynch\BPEL_Asynch_hlqk\src\__temp_java_wrappers\dbconnection_mesd\MyWebService1Base.java (The system cannot find the file specified)
     at java.io.FileInputStream.open(Native Method)
     at java.io.FileInputStream.<init>(FileInputStream.java:106)
     at java.io.FileInputStream.<init>(FileInputStream.java:66)
     at oracle.ide.net.FileURLFileSystemHelper.openInputStream(FileURLFileSystemHelper.java:481)
     at oracle.ide.net.URLFileSystemHelperDecorator.openInputStream(URLFileSystemHelperDecorator.java:242)
     at oracle.ide.net.URLFileSystem.openInputStream(URLFileSystem.java:1028)
     at oracle.jdevimpl.webservices.generator.WrapperClassGenerator$1.run(WrapperClassGenerator.java:304)
     at oracle.jdevimpl.webservices.util.ThreadUtil$NonThrowingRunnable.run(ThreadUtil.java:106)
     at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:171)
     at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
     at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
     at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
     at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141)
     at java.awt.Dialog$1.run(Dialog.java:540)
     at java.awt.Dialog.show(Dialog.java:561)
     at java.awt.Component.show(Component.java:1133)
     at java.awt.Component.setVisible(Component.java:1088)
     at oracle.bali.ewt.dialog.JEWTDialog.runDialog(Unknown Source)
     at oracle.ide.dialogs.ProgressBar.start(ProgressBar.java:288)
     at oracle.jdevimpl.webservices.generator.SPWebServiceGenerator.generateImpl(SPWebServiceGenerator.java:296)
     at oracle.jdevimpl.webservices.generator.SPWebServiceGenerator.generate(SPWebServiceGenerator.java:170)
     at oracle.jdevimpl.webservices.generator.JAXRPCGenerator.generateNonJAXPlsqlService(JAXRPCGenerator.java:1920)
     at oracle.jdevimpl.webservices.generator.JAXRPCGenerator.generateNonJAXService(JAXRPCGenerator.java:1548)
     at oracle.jdevimpl.webservices.generator.JAXRPCGenerator.generateService(JAXRPCGenerator.java:223)
     at oracle.jdeveloper.webservices.JAXRPCSvcModel.saveEdit(JAXRPCSvcModel.java:1613)
     at oracle.jdevimpl.webservices.wizard.SPWebServicePublishWizard.runWizard(SPWebServicePublishWizard.java:362)
     at oracle.jdevimpl.webservices.wizard.SPWebServicePublish.invoke(SPWebServicePublish.java:99)
     at oracle.ide.WizardManager.invokeWizard(WizardManager.java:484)
     at oracle.ide.WizardManager$1.run(WizardManager.java:538)
     at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
     at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
     at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
     at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
     at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

The replay answer
Advertisement
I was trying to create a webservice based on a function in the package and that's when I got this error. I tried the same with a procedure in the same package and it works.
Am I not supposed to used functions for creating webservices then?

Go to See the other 2 answers

PL/SQL Web Service Error: IllegalArgumentException : No Deserializer found

Category:DefaultRelease time:2015-10-11Views:130

I deployed a pl/sql web service on a stand-alone OC4J, when I test this I am getting error "IllegalArgumentException : No Deserializer found to deserialize". Find below the detailed response: <?xml version="1.0" encoding="UTF-8[More]

PL/sql web service error !!!!!!! Help

Category:DefaultRelease time:2015-10-11Views:130

I was trying out the PL/SQL webservice example on OTN [http://otn.oracle.com/pub/articles/price_10gws.html] My environment is Oracle10G database, which comes with standalone version of oc4j, and I followed all the steps per the article but I still ge[More]

PL/SQL Web service error

Category:DefaultRelease time:2015-10-11Views:130

Hi I am trying to create a PL/SQL Webservice based on an Oracle package. It fails with "An expected error was encounted. Generation aborted." The exception stack trace is pasted below. Any help is appreciated. java.io.FileNotFoundException: D:\O[More]

Error when invoking pl/sql web service from bpel

Category:DefaultRelease time:2015-10-11Views:130

Hi! I have a simple 'Hello World' pl/sql web service. When i invoke it in asynchronous BPEL process, a local WSDL file is automatically generated for the parterlink used. The process even gets successfully deployed without any warning or error. But i[More]

Error while running PL/SQL Web Service in JDeveloper

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to run a PL/SQL Webservice example available on OTN site. Below mentioned error is occurring when running the program: *************** Error Stack Begin ********************** D:\DevSuiteHome_1\jdk\bin\javaw.exe -ojvm -classpath D:\De[More]

Creating PL/SQL web services from PL/SQL records

Category:DefaultRelease time:2015-10-11Views:130

Hello Jdeveloper does not allow to create web services from pl/sql packages that use PL/SQL records.to do this,we have to use the jpublisher ?without using the jpublisher,if we create a webservice then the following error is displayed in the web serv[More]

Creating PL/SQL web services from object types

Category:DefaultRelease time:2015-10-11Views:130

Hello Jdeveloper, pl/sql web-services working successfully with object types.If we want to send the web-services to the client, do we need to send the entire folder that is created in the web-services folder of the external oc4j..? Creating the clien[More]

PL/SQL Web Service: Broken Pipe

Category:DefaultRelease time:2015-10-11Views:130

We have successfully deployed PL/SQL Web Services on the Oracle Application Server 10g with about 6 containers. The web services are being consumed by a .NET application. All seems to be working well but we continually are having intermittent (every[More]

PL SQL Web Service Authentication through LDAP

Category:DefaultRelease time:2015-10-11Views:130

I have created one PL SQL Web Service and I would like to provide token security through LDAP. I have configured LDAP for deployed webservice in oracle IAS 10.1.3 Service. Problem Description: <?xml version="1.0" encoding="UTF-8"?&g[More]

Hot
Dear Oracle Certification addicts Please consult the following blog http://blogs.oracle.com/certification/ I did really appreciate the To Certify or Not to Certify topic is it quite good. Especially that Note to Hiring Managers: Just as candidate sho [More]
Hi ALL, Probable he wrong forum, but I have iPhoto 2 an is NOT opening in Leopard. Is there a link where i Can download a iPhoto version that runs in Leopard? Or can I extract it from a original install CD from a OSX version that I own. Like Jaguar - [More]
Hi I have a page with a richtexteditor component on an OA page.. i would like to add a Print button that will take the content from that box and print it.. any idea's???Hope This will help you. l_no_of_copies := fnd_profile.VALUE ('XXTMG_AN_PRIORITY_ [More]
Need values for below as an output for below xml file so help me with the script: Under Criteria Tag- TimeStamp Display Value OID corresponding to display value for nodes "Criterion" Under Report Body Tag-- name in Report Section and OID value & [More]
Whenever I launch Firefox, multiple tabs also start to open along with the Mozilla Firefox Start Page, which is very irritating. How can I stop this to happen each time I launch the browser?See these articles for some suggestions: * https://support.m [More]
I am interested in iTunes Match. I am a DJ and I use a Macbook pro for my my primary computer  and a Macbook for a back up. I do not like having to  constantly update my back up computer.  I do not have Lion yet either, so I know I will have to upgra [More]
Hello Everyone: I've got a situation where I'm banging my head trying to figure out and could use some ideas.... I have a UITableView where I made my own custom class for the tablecells. This table is populated by a sqlite table. Along with some othe [More]
The screen splits in two and scrambles.  If I'm able to close the game, the screen goes back to normal.  Is it the video card?  Motherboard?1. This comment applies to malicious software ("malware") that's installed unwittingly by the victim of a [More]
I was told by a customer service rep that we must turn OFF data while on WiFi otherwise you are charged for data usage. What?? I thought that was the point if automatically connecting to WiFi, now my one line is almost at capacity and the service rep [More]
Hi everybody. I've been trying to install Mac OS X 10.4 on this G4 Quicksilver, but it seems that it's impossible. When I boot from the CD, it tells me "Mac OS X 10.4 cannot be installed on this computer" and promptly tells me to restart. It doe [More]