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

SQL>
SQL> declare
2 v_debug_mode boolean := false;
3 v_req utl_http.req;

[Code]....

PL/SQL procedure successfully completed

SQL>

And this is the code(Is the same, the only difference is the path of the wallet) and the error resultant:

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as gpacheco@acseld

SQL>
SQL> declare
2 v_debug_mode boolean := false;
3 v_req utl_http.req;

[Code].....

View 4 Replies


ADVERTISEMENT

Server Administration :: ORA-29702 / Error Occurred In Cluster Group Service Operation

Aug 12, 2010

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

View 11 Replies View Related

PL/SQL :: UTL_HTTP For Web Service To Send A SMS

Dec 11, 2012

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;

and am getting the result as shown below

UTL_HTTP.REQUEST('HTTP://80.227.146.106/RECEIVER/SMS99.ASPX?USR=JOE123&PASS=JOE321&MSISDN=97155
<HTML><HEAD>
<TITLE>Request Error</TITLE>
</HEAD>
<BODY>
[code]......

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

Request Error (unsupported_protocol)

View 0 Replies View Related

Calling Web Service From A Procedure Using SOAP API

Mar 5, 2013

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?

View 1 Replies View Related

FRM-40734 / Internal - PL/SQL Error Occurred

Mar 27, 2004

I'm trying to call an help file with the following

BEGIN
Win_API_Shell.WinHelp
('C:eindwerkorainfo.hlp' ,
null ,
WIN_API.HELP_INDEX ,
TRUE );
END;

DK2KWUTIL.pll is attached to the form, info.hlp is an existing file in the path C:eindwerkora.

But it keeps giving me the following error:

FRM-40734: Internal error: PL/SQL error occurred.

View 3 Replies View Related

Enterprise Manager :: IO Error Occurred?

Jan 12, 2010

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.

View 2 Replies View Related

PL/SQL :: ORA-20001 / Unhandled Error Occurred

Aug 31, 2012

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.

View 8 Replies View Related

SQL & PL/SQL :: ORA-00604 - Error Occurred At Recursive Level

Mar 14, 2011

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.

View 7 Replies View Related

Windows :: Oracle 11g Installation Error Occurred?

Jun 1, 2012

I have facing a error message(attached) while creating or installing database in my system.

find attached error snap for the your reference only.

View 11 Replies View Related

SQL & PL/SQL :: Materialized View Refresh - Error Occurred?

Feb 7, 2012

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

View 10 Replies View Related

Networking And Gateways :: FRM-92102 / A Network Error Has Occurred

Sep 28, 2011

when i try to open a our application i got this error

"FRM-92102: A network error has occurred. The Forms Client has attempted to reestablish its connection to the Server 5 time(s) without success."

View 1 Replies View Related

Security :: ORA-00604 / Error Occurred At Recursive SQL Level 1

Nov 3, 2010

I'm trying to drop a user but it gives me below error message-

SQL> drop user <username> cascade;

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

However when i check from dba_queue_tables or user_queue_tables it doest show any queue tables.

View 6 Replies View Related

PL/SQL :: ORA-00604 - Error Occurred At Recursive SQL Level String

Jun 22, 2013

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. 

View 0 Replies View Related

Server Utilities :: SQL Loader - Error Occurred On Good Insert?

Apr 7, 2010

We are getting below error while loading a data in Oracle 10g database using sqlloader.

Error

SQL*Loader-704: Internal error: ulnain: error occurred on good insert [-1]

View 8 Replies View Related

Server Administration :: ORA-00604 / Error Occurred At Recursive SQL Level 1

Oct 7, 2010

When trying deploy an mapping, the database link get this error:

ORA-06550: PACKAGE BODY, line 0, column 0:
ORA-04052: error occurred when looking up remote object db1.someC@db1@LOC_db
ORA-00604: error occurred at recursive SQL level 1
ORA-12170: TNS:Connect timeout occurred

I can use tnsping towards the db. I can use

elect * from v$instance@db1@loc_db

View 1 Replies View Related

SQL & PL/SQL :: Error Occurred During Execution Of Simple JDBC Program In Eclipse

Jun 27, 2013

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)

View 7 Replies View Related

Reports & Discoverer :: REP-1401 / Afterpform / Fatal PL/SQL Error Occurred

Mar 6, 2013

i am getting below error while running Aging report.

Enter Password:

MSG-01001: inside beforepform
MSG-00100: p_reporting_level = p_reporting_entity_id =
MSG-00100: Get_Predicate calls complete
REP-1401: 'afterpform': Fatal PL/SQL error occurred.

this is my code in After parameter.

srw.message('100','Get_Predicate calls complete');
:p_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
srw.message('100','p_reporting_entity_name'||:p_reporting_entity_name);
:p_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
srw.message('100','p_reporting_entity_name'||:p_reporting_level_name);

[code]....

View 3 Replies View Related

OUI-10150 / A Runtime Execution Error Occurred While Setting S_digcfgnaminglabel

Mar 27, 2013

Environment is CentOS 6.3, 64-bit OS

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.

View 2 Replies View Related

Data Guard :: Error Occurred During Initial DB Duplicate To Standby Server?

Mar 20, 2008

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

View 2 Replies View Related

Reports & Discoverer :: Set Path - Error Occurred While Opening Or Saving Document

Jun 29, 2010

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."

View 2 Replies View Related

Server Utilities :: Error - An Unhandled Win32 Exception Occurred In Ctxhx.exe

Mar 15, 2011

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.

View 4 Replies View Related

Server Administration :: ORA-00607 / Internal Error Occurred While Making A Change To A Data Block

Mar 12, 2010

Error is occurred during the transaction...i.e.

ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [89], [83], [], [], [], [], []

View 7 Replies View Related

SQL & PL/SQL :: Converting Utl_http Read_text To PDF File

Oct 25, 2012

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.

View 10 Replies View Related

SQL & PL/SQL :: How To Send SMS Through Oracle - Service Not Available Error

Jul 2, 2010

I am learning How to send sms thru PLSQL gateway?

I have searched for it on internet & got 1 procedure on OTN. I also tried it. But it is giving me the Errors .

The procedure is as below :

create or replace procedure SEND_SMS(p_sender in varchar2,
p_recipient in varchar2,
p_message in varchar2) as
mailcon utl_smtp.connection;
begin

[code]....

I also tried to Execute the same Procedure. The execute statement is below :

EXECUTE send_sms('myemail@server.com', '9822553277@smsserver.com', 'My Subject', 'My Message');

But i got the errors as :

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

View 2 Replies View Related

SQL & PL/SQL :: Error In Calling Collection Procedure

Jun 4, 2013

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]....

View 19 Replies View Related

Usage Of UTL_HTTP - Sending Email With External Mail ID?

Apr 22, 2013

What is the usage of UTL_HTTP?

Will I be able to send e-mail with UTL_HTTP to an external mail id?

View 5 Replies View Related

Error While Calling External C Function From Oracle?

Apr 7, 2011

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

listener.ora
=======
callout_listener =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP) (HOST = ip_address)(PORT = 1521)

[code]...

View 4 Replies View Related

Forms :: Getting Error Frm 21011 While Calling From Menu

Jun 5, 2012

getting error frm 21011 , ora -65020 , while calling forms from menu , the forms are also passing parameters between forms 1 and forms 2 .

The following code is in menu item .

declare
uname varchar2(30);
cname varchar2(40);

[code]....

View 1 Replies View Related

SQL & PL/SQL :: ORA-29278 - SMTP Transient Error - 421 Service Not Available?

May 6, 2008

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

[code]...

View 13 Replies View Related

SQL & PL/SQL :: ORA-29278 / SMTP Transient Error - 421 Service Not Available

Dec 6, 2010

how to test utl_mail.send?

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.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved