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]

Testing PL/SQL Web Service Error

Category:DefaultRelease time:-0001-11-30Views:130

I've generated a web service using JDev 10.1.2, ran it in the embedded OC4J Server. I then generated a stub to test it with, browsed to the web service wsdl file in the original project, and ran the stub. The stub project returns the error: SOAPExcep[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]

Web Service Error: java.sql.SQLException: Io exception: Broken pipe

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am using JDeveloper PL/SQL web service generator. After some time we start receiving the "java.sql.SQLException: Io exception: Broken pipe" exception when we invoke the web service. I've noticed that the error starts occuring once all the[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
Hi All, I have following requirement. I am executing a Report. At end of report I am executing an event. On the bases of event a background job runs. Problem is that, I want to pass one field data from report to background job. I already tested SET P [More]
Whenever I have tried to do anything that involves video with iTunes, regardless of whether my new video iPod is connected, my machine grinds to a complete halt after several seconds. It starts with iTunes not responding, then explorer stops respondi [More]
I have been locked out of my pc. I purchased a new hp laptop yesterday, set up a local password. hooked it up to the internet downloaded a free trial version of microsoft office. then when i turned my computer off and went to log in again it had chan [More]
I cant find out how to do it on certain parts in the middle of a song I am mixing. Can anyone help?You may want to head over to http://labs.adobe.com/ and download the public beta release of Soundbooth CS4. It offers multitrack, volume keyframing, an [More]
Hi All, I am using a DB poller to read records from the table. The problem is the DB poller picks the records randomly but I want it to process records by creation_date. Here is my configuration. <endpoint-activation portType="XX_ptt" operati [More]
Hi, I have a table where I'm saving xslt programs using XMLType and I want to use the xslt document(); function to refere to xml data stored in an other table using XMLType Exemple : CREATE TABLE STYLSHEETTABLE ID INTEGER, XSLT SYS.XMLTYPE CREATE TAB [More]
Hi, how to execute external command and external program in background. please provide me some tips on the same. while creating external command, what is the significance of "operating system command" and "parameters for operating system co [More]
Is there a way to copy my messages and/or texts to my computer, other than one at a time?Google your question... there are 100s of 3rd party apps that can do it, amongst them TouchCopy, iBackupBot, etc.Read other 2 answers [More]
Hello All, I have three tables namely: 1. User - userid,username 2. Directory - Dirid, Dirname 3. User_dir_map - Userid,dirid Now i want a procedure or function which returns all the directoy name and the corresponding users for each directory. Can a [More]
Last played and number of plays are not being set.  Suggestions?Yup, this. Judging from the number of tracks that iTunes 11 tells me it's played, versus last.fm's scrobbles over the last two days, iTunes is actually updating the play date/time and co [More]