SQL & PL/SQL :: Error Occurred Calling A Web Service Using UTL_HTTP
Jun 27, 2013
I'm calling a web service with HTTPS protocol from a pl/sql program and i'm using the UTL_HTTP package for do this.
I have a Oracle DB installation 11g Enterprise Edition Release 11.2.0.1.0 on my personal computer with a Windows XP OS, and when i run the code it works fine and returns the result I expect. But, when i run the same code on the Oracle DB of my work (Oracle 10g Enterprise Edition Release 10.2.0.4.0 and OS HP-UX) it fails and give me an error, i think that the error has to do with the configuration of the wallet and the certificates in it, because i consume the WS from Os prompt using the command WGET and works fine and i test consuming a WS with HTTP no secure and works fine too.
This is the code and the result in the Oracle DB 11g on my computer:
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as oe@oRCL
I have deinstalled Oracle database, ASM and oracle software. I installed the oracle software, ASM and database. I have seen the error in the ASM trace called
Errors in file /opt/oracle/admin/+ASM/bdump/+asm_gmon_10518.trc:
ORA-29702: error occurred in Cluster Group Service operation ORA-29702: error occurred in Cluster Group Service operation
I am trying to send SMS through a web service, and before doing it on a form, I tried to check this with UTL_HTTP from sql plus
below given is the code i tried
SQL> SET DEFINE OFF SQL> SELECT UTL_HTTP.REQUEST('http://80.227.146.106/Receiver/sms99.aspx?usr=JOE123&pass=JOE321& msisdn=971556221690&msg=test msg through ibuzz&mt=0') FROM DUAL;
Your request used a protocol that is not currently supported.
</TD></TR> UTL_HTTP.REQUEST('HTTP://80.227.146.106/RECEIVER/SMS99.ASPX?USR=JOE123&PASS=JOE321&MSISDN=97155 <TR><TD> </TD></TR> <TR><TD> </TD></TR> </TABLE> </BODY></HTML> **********-----------------------------------------------------------------------------------------------------------------------------------------------------------******** protocol used for the web service is HTTP. they have given an IP with port number . and the method is GET
[URL]........
parameters are msisdn, msg, mt their response would be either true or false. I tried this on Oracle9i Enterprise Edition Release 9.2.0.1.0 and the message is Your request used a protocol that is not currently supported. when i tried the same on Oracle Database 11g Release 11.2.0.1.0 i got
I am trying to call a Web service using the SOAP API and I get the following error.
ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side ORA-06512: at "SYS.XMLTYPE", line 48 ORA-06512: at "MyConnection.SOAP_API", line 121 ORA-06512: at "MyConnection.MyFunction", line 28 31020. 00000 - "The operation is not allowed, Reason: %s" *Cause: The operation attempted is not allowed *Action: See reason and change to a valid operation.
However we do have another procedure that is able to make an HTTP call successfully within the same domain. Hence the ACLs that are required are for making an HTTP call are in place. Is there any other security setting to be tweaked to make the to enable me to make a Webservice call using the SOAP package?
The last week or so, the job has not ran. I finally got some time today to take a look and when I try to manually export the schemas, i get the following message after the first screen (where you choose Schemas and your credentials are entered)
Validation Error - Examine and correct the following errors, then retry the operation: Error - IO error occured.
A few weeks ago i changed the password for sysman and dbsnmp because the backups were not running and after i did that, they ran for a few nights. The only other thing is our system admin for the server changed some user access for the C:Oracle folder, but I still have full control.
I am in the ORA_DBA group and i have "Logon as batch job" selected for my account.
I read at one place to go to Preferences - Preferred Credentials and test the host username and password. When i do this i get the message : "Connection to server as user XXXXXXX failed" so I am thinking it has something to do with my user account, but not sure what i need to change.
I've a procedure and a trigger. The problem is when I call the proc from inside the trigger I get an error message saying that
Error: ORA-00604: error occurred at recursive SQL level 1 ORA-20001: Unhandled error occured! ORA-06512: at "ITEX.REFRESH_XSD", line 23 ORA-06512: at line 21
Here're these two problematic parts:
PROCEDURE: create or replace PROCEDURE Refresh_XSD(TableName IN varchar2) IS -- Variable declarations. XML_Schema xmltype; BEGIN
[code]....
So we have an xsd for a table only once. However that XSD needs to be refreshed when the table is altered, or created when the table is created. That's the reason I'm trying to use that trigger. If I comment out the procedure call from the trigger, everything works correctly except it does not do what needs to be done.
As far as I know only can't execute DDL statements from system triggers. But there's not a single DDL statement in there.
I am using Oracle 10g Database as back end and Developer 6i as front end.I have a procedure which is called upon SAVE. Means before COMMIT;This procedure holds few updates and delete statments.
This prcedure is throughing sql error as follows: ORA-00604: error occurred at recursive SQL level
The error occur when an delete statment is issued which as follows: DELETE FROM DUMMY_TAB001;
I issue the same statement from SQL it is running fine. But when my from runs on this delete statment encounter it through the above oracle error ORA-00604.
I have created a Table with one column in user 'Test' Database 'Test'. Then i have created a Materialized view based on the Table in 'TestMV' in same database 'Test'.working fine. But after adding one column in the table, if i go to refresh the Materialized view the following Error has occured.
ERROR at line 1: ORA-12008: error in materialized view refresh path ORA-00913: too many values ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2431 ORA-06512: at line 2
Oracle Version :- 11.2.0.2 I found a error in a trigger(Statement Level) ORA-00604:error occurred at recursive SQL level string. Before Finding this issue,Once the DB Response was slow . Will this be the issue Of DB Slow response. The Above trigger fires for each entry in an transaction table. The code is Patched and was executed . The above issue was found during another issue and not the DB Slow response. My Doubt is Whether DB response slow issue would be because of this. Now after fixing this Slow response was not reported.
java.sql.SQLException: ORA-04054: database link GMAIL.COM does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169) at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1615) at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1580) at com.jdbc.pack.Lab1.main(Lab1.java:31)
I get the following error when I use the universal installer (runInstaller.sh)
OUI-10150: Error: A runtime execution error occured while setting s_digcfgnaminglabel isidnull in compnent oracle database 11g 11.2.0.1.0. Installation cannot continue for this component.
I have check my /etc/hosts entries and I believe my jre paths are correct since I get the JAVA windows.
i have setup the OEM-Dataguard in order to duplicate the DB instance from the primary to the standby DB in the standby server.At first I installed oracle server in Server A (Primary) created DB instance of SCT, in archivelog mode and then I install the oracle binary in Server B (standby) and made 2 servers ORACLE_HOME the same and also I installed OEM agents on the 2 servers and registered successfully to the OEM server.
I then used the dataguard to do the initial backup of the DB in server A and but when I specify the standby DB location, it prompt me the following error.
Error
Examine and correct the following error(s), then retry the operation. Remote Operation Error - Internal error occured
Add Standby Database: Database Location
Primary Database SCT Primary Host Ent Step 3 of 6
Standby Database
* Instance Name The instance name (also referred to as the SID) must be unique on the standby host. Database Storage File SystemRaw Devices Choose whether the database files will be put on a conventional file system or on raw devices.
Standby Host Credentials
Enter the credentials of the user who owns the Oracle installation in the Oracle Home selected below. * Username * Password
Standby Database Location
The standby database can be created in any Oracle Home that has been discovered by Enterprise Manager. Only Oracle Homes on hosts that match the operating system of the primary host are shown. Select the Oracle Home in which to create the standby database.
Search For Host Select Host Oracle Home Oracle Server Version Operating System Operating System Version Ent /u01/app/oracle/product/10.2.0/db_1 10.2.0.1.0 SunOS 5.10 Ent_standby /u01/app/oracle/product/10.2.0/db_1 10.2.0.1.0 SunOS 5.10
When I give the report Full path like 'C:FolderNameCurrency2.rdf. Successfully report run.
after changing the registry path like Reports_Path='C:FolderName'
When I click a button to run the report,I received the following errors.
declare v_report_nameVARCHAR2(100) := 'Currency2.rdf'; begin Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?usr'||'&report='||v_report_name,'_blank'); end ; " REP-110: File Currency2.rdf cannot be opened. REP-1070: An error occurred while opening or saving a document. REP-0110: File Currency2.rdf cannot be opened."
I have importing a dump file which is of size upto 6GB, its working fine. At the last step after the import of all the tables when it enables constraints , indexed and everything a pop-up window with the above mentioned error in the subject pops-up.
I am not able to mention the error exactly so find the screen shot as attachment.
ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4194], [89], [83], [], [], [], [], []
I was tinkering around with utl_http api in pl/sql. Essentially I wanted to connect to our report server and retrieve an oracle report from the database(not forms). I got the report successful but by using the utl_http.read_text the pdf is essentially a clob now and how to convert the clob to pdf and save it on my local pc. I've looped through the clob converting it to raw and tried the utl_file.put_raw and put_line but it didn't work.
begin send_sms('myemail@server.com', '9822553277@smsserver.com', 'My Subject', 'My Message'); end;
ORA-29278: SMTP transient error: 421 Service not available ORA-06512: at "SYS.UTL_SMTP", line 21 ORA-06512: at "SYS.UTL_SMTP", line 97 ORA-06512: at "SYS.UTL_SMTP", line 139 ORA-06512: at "ADMIN.SEND_SMS", line 13 ORA-06512: at line 2
In a package I have one procedure "setscores_ram_bulk" with collection varaiavles.And other two procedures are
"UpdateRelatedOrders" and "SetGeoFraudScore"
with out collections.I am calling collection procedure "setscores_ram_bulk" in non collection procedures
"UpdateRelatedOrders" and "SetGeoFraudScore".
I am getting the below error.PLS-00306:wrong number or types of arguments in call to 'SETSCORES_RAM_BULK' .I am sending my code.
CREATE OR REPLACE PACKAGE GAFT_PROG_DIT.INTERNAL_SCORING_setscore_Bulk IS TYPE rec_setscores IS RECORD ( pBUID score.buid%TYPE, OrderNum score.order_num%TYPE, ScoreType VARCHAR2(100), p_Score score.velocity_score%TYPE ); [code]....
I tried to use external C procedure from the database and i did all required steps as below. 1. create a C program 2. compile and link the C program 3. copy it to the Oracle_home/bin directory 4. configure listener.ora and tnsnames.ora files
i am trying to send mail using utl_smtp.but this error occurs. even smtp is installed on server.
ERROR at line 1: ORA-29278: SMTP transient error: 421 Service not available ORA-06512: at "SYS.UTL_SMTP", line 21 ORA-06512: at "SYS.UTL_SMTP", line 97
Does this work with [URL] on port 465. What about the authentication of the user who sent it? I have done the following steps, but its giving me some error.
1. sqlplus 2. Login with 'sys as sysdba' 3. Created package by executing 'utlmail.sql' and package body by executing 'prvtmail.plb' 4. ALTER SYSTEM SET smtp_out_server = 'smpt.gmail.com:465' SCOPE=SPFILE 5. shutdown immediate 6. startup
[code]....
It is giving me the following error:
ORA-29278: SMTP transient error: 421 Service not available.
And I read a lot, but there was nothing like authentication. It means if its working with any SMTP server, then any user can send mail from 'bilgates@microsoft.com' to any receiver on the same smtp.