| |
4862 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 30 June 2022 04:36 «»
By: thiyagarajancs
Re: SENDGRID | Curl
…Dears,
I am facing an issue while configuring the email via sendgrid. Kindly help me to resolve the issue.
###########################################Sample Procedure…
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 03 February 2024 00:25 «»
By: aabunarr
oracle10g and utl_http
…hi..
i hope this message finds you well...
i am using oracle 10g r2
and facing the problem connecting to web service
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 22 June 2022 03:47 «»
By: fixxxer
orapki: add crt and key to wallet
…Hi,
I am trying to configure an API call from our Oracle DB to the application server. I have:
1. Opened Firewall from DB Server to application server on the correct ports.
2. Added the application p12 file to an Oracle wallet. The application …
|
| 4 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 13:16 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…store: unknown HTTP error 3823243664 getting http://acedmvaultprd.inl.gov/edm23m/10881/10880871.docx
DRG-50857: oracle error in read_into_lobLocator
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDML", line 2183…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 24 October 2022 04:57 «»
By: fixxxer
ORA-29005: The certificate is invalid
…Hi,
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0
I am trying to make a UTL_HTTP request to an application server. I have assigned the ACL to the user in question, with connect and resolve permissions. …
|
| 6 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 11:52 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html, http://acedmvaultprd.inl.gov, acedmvaultprd, acedmvaultprd.inl.gov');
END;
/
and changed the URL to the document to be this:http://acedmvaultprd.inl.gov/…
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 01 January 2023 05:01 «»
By: mape
xml error eurofxref-daily.xml
… 'xmlns = "http://www.ecb.int/vocabulary/2002-08-01/eurofxref') currency,
EXTRACTVALUE ( value ( tab ), '/ Cube / @ rate',
'xmlns = "http://www.ecb.int/vocabulary/2002-08-01…
|
| 8 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 10:57 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html');
END;
/
INSERT into KJC_TEST_INDEX_2 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://acedmvaultprd.inl.gov/edm22h…
|
| 9 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 10:00 «»
By: kjcook
How to access URL's from your database that are accessible from your browser
…store: unknown HTTP error 2447200152 getting http://myHost/10880871.docx
DRG-50857: oracle error in read_into_lobLocator
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDML", line 2183
ORA-29273: HTTP request …
|
| 10 |
Forum: Forms «»
Posted on: Wed, 13 July 2022 02:27 «»
By: Michel Cadot
Re: .fmb to .txt
…
Your 6 latest topics:
http://www.orafaq.com/forum/m/685879/#msg_685879 ==> no feedback
http://www.orafaq.com/forum/m/685703/#msg_685703 ==> no feedback
http://www.orafaq.com/forum/m/685426/#msg_685426 ==> no feedback (you didn't get help …
|
| 11 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 20:50 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…ext_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.html')
/
COMMIT
/
BEGIN
ctx_ddl.set_attribute('KJC_TEST_INDEX_1_URL_DATASTORE',
&…
|
| 12 |
Forum: Text & interMedia «»
Posted on: Wed, 16 August 2023 17:12 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html, http://acedmvaultprd.inl.gov, acedmvaultprd, acedmvaultprd.inl.gov');
END;
/
-- INSERT into KJC_TEST_INDEX_2 (assigned_id, text_content_url)
-- &…
|
| 13 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 19:48 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…ext_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.html')
/
COMMIT
/
BEGIN
ctx_ddl.set_attribute('KJC_TEST_INDEX_1_URL_DATASTORE',
&…
|
| 14 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 03:17 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…timeout of 3600 seconds and no_proxy and 'http://www.example.com/index.html'. The error on the dropping of the url_datastore is only because it had been previously dropped, so that can be ignored.
C##SCOTT@XE_21.3.0.0.0> commit;
…
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 08 September 2022 06:40 «»
By: skfaheem024
Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized
…Hi,
I am new to this forum and consuming Rest API's using PL/SQL. I am trying to consume a rest service from pl/sql, but the server is not able to identify the request. The same request works from postman.. so no problem in the service, something with …
|
| 16 |
Forum: Performance Tuning «»
Posted on: Fri, 04 December 2009 19:18 «»
By: BlackSwan
SQL statement tuning
….
Samples
.....
http://www.orafaq.com/forum/t/205234/
.....
Post the EXPLAIN PLAN that Oracle uses to execute your SQL.
Run the following in SQL*Plus
If PLAN_TABLE does not …
|
| 17 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 17:43 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…all of the files are accessible via the internet and some are not accessible localy, then yes, I believe that brings you back to the network_datastore.
Before I switched to the directory_datastore, I was trying to adapt something like this, as …
|
| 18 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 12:58 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…'NO_PROXY',
'http://www.example.com/index.html,
http://acedmvaultprd.inl.gov,
acedmvaultprd,
acedmvaultprd…
|
| 19 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 08:47 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…('KJC_TEST_INDEX_2_NETWORK_PREF','NO_PROXY','http://www.example.com/index.html');
END;
/
INSERT into KJC_TEST_INDEX_2 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.html…
|
| 20 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:24 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…ctx_ddl.set_attribute('URL_PREF','NO_PROXY','http://www.example.com/index.html');
4 ctx_ddl.set_attribute('URL_PREF','Timeout','10');
5 END;
6 /
PL/SQL procedure successfully completed.
C##SCOTT@…
|
| 21 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:03 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…have two separate sets of issues.
The first is just creating a valid index to begin with.
The second, which requires that the first is already done right, is checking your index rebuild progress and errors.
I will address them separately in two …
|
| 22 |
Forum: Text & interMedia «»
Posted on: Thu, 10 August 2023 23:55 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…bsp;2 VALUES ('MCP-135', ' http://www.example.com/index.html')
3 /
1 row created.
SCOTT@orcl_12.1.0.2.0> BEGIN
2 ctx_ddl.create_preference('URL_PREF','URL_DATASTORE');
3 &…
|
| 23 |
Forum: Reports & Discoverer «»
Posted on: Mon, 10 July 2023 02:46 «»
By: shahzaib_4vip@hotmail.com
Hyperlink report to report
…with its working fine the query is
http://192.168.0.113:8889/reports/rwservlet?userid=faizan/a@xe&server=rep60server&report=c:\farazoracle\10gReports\Ledger.rep &destype=CACHE&desformat=PDF¶mform=no&date_from=10-JUL-23&…
|
| 24 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 April 2023 03:35 «»
By: Michel Cadot
Re: Oracle RMAN Backup API
…is not documented.
A description can be found in Morgan's Library
You can find examples of using it on the web, for instance:
http://www.orafaq.com/forum/mv/msg/57760/156152/#msg_156152
http://www.orafaq.com/maillist/oracle-l/2006/08/10/0447.htm…
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 01 January 2023 06:40 «»
By: Solomon Yakobson
Re: xml error eurofxref-daily.xml
…type('<gesmes:Envelope xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01" xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref">
<gesmes:subject>Reference rates</gesmes:subject>
<gesmes:Sender>
<…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 08 September 2022 09:07 «»
By: John Watson
Re: Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized
…to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Can you work up to the problem slowly, one bit at a time? Rather than trying to write the whole procedure in one shot? For example, …
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 10 June 2022 08:16 «»
By: jesuisantony
Sporadic Certification Validation Error While accessing the external portal
…are running jobs by accessing an external portal through the Oracle DB. We have a wallet created using "orapki" utility. And the certificates shared by the app team have been added to the wallet.
We see that the jobs are getting executed …
|
| 28 |
Forum: Marketplace «»
Posted on: Wed, 17 August 2016 09:46 «»
By: Michel Cadot
McDP: like expdp/impdp Data Pump programs and much more
… permission of the author you can contact on http://www.orafaq.com
You can post your comments, ask for improvements, report bugs... on the program at
http://www.orafaq.com/forum/t/201760/
This link also contains detailed explaination and many examples …
|
| 29 |
Forum: Marketplace «»
Posted on: Thu, 18 February 2016 12:02 «»
By: Michel Cadot
McTnsping: a tnsping-like program for Windows
… permission of the author you can contact on http://www.orafaq.com
You can post your comments, ask for improvements, report bugs... on the program at
http://www.orafaq.com/forum/t/200058/
I encourage you to subscribe to this topic (link at top of the …
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 17 September 2024 03:51 «»
By: fixxxer
Re: ORA-29005: The certificate is invalid
…Pavel,
I am going to do my best to recollect this lol. So we were trying to make a UTL_HTTP request to an API endpoint. There were already a set of certificates stored in the wallet on Oracle server. I added another certificate for the API application…
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 04 February 2024 09:25 «»
By: Frank Naude
Re: oracle10g and utl_http
…assume it's an HTTPS and not a plain HTTP request that's failing.
The request is probably using a newer protocol that's not supported by your older 10g database.
$ oerr ora 28750
28750, 00000, "unknown error"
// *Cause: An …
|
| 32 |
Forum: Weblogic & Application Server «»
Posted on: Tue, 16 January 2024 02:51 «»
By: calacausi
Oracle Reports server 12c. "showjobsid" page does not close
…when we run a report, the showjobid (eg: http://serverURL:7777/reports/rwservlet/showjobid73?server=rep_wls_reports_srv&EnvId=DEFAULT&statusonly=true&autorefresh= 1&closewindow=yes) page does not close. after installation, we copied the …
|
| 33 |
Forum: Performance Tuning «»
Posted on: Sun, 31 December 2023 02:46 «»
By: Michel Cadot
Re: query output speed very slow
…any SQL performances question, please read http://www.orafaq.com/forum/index.php/mv/msg/206002/433888/#msg_433888 and post the required information.
You can also read:
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL …
|
| 34 |
Forum: Security «»
Posted on: Wed, 18 October 2023 12:58 «»
By: John Watson
Re: Security & Encryption
…be transparent to your application. I've configured this for customers a few times, drop my boss a note if you'ld like any assistance.
--
John Watson
Oracle Certified Master DBA
Oracle Certified Professional OCI Architect
http://skillbuilders.com…
|
| 35 |
Forum: Networking and Gateways «»
Posted on: Wed, 27 September 2023 05:42 «»
By: muthukrish104
TNS-03505: Failed to resolve name from 12c client to 19c DB
…All,
I am not able to connect from 12c client to 19c db in windows platform.
but able to do tnsping within the server.
Client Setutp:
Lstener Status:
C:\Users\****>lsnrctl status listener1
LSNRCTL for 64-bit Windows: Version 19.0.…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 September 2023 15:09 «»
By: Barbara Boehmer
Re: Jaro-Winkler similarity for 9i
…bsp; -- from OraFAQ thread: http://www.orafaq.com/forum/mv/msg/164224/689059/#msg_689059
4 return number
5 authid definer
6 deterministic
7 as
&…
|
| 37 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 16:36 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…mple.dat file that contains the same data as http://www.example.com/index.html that I was previously accessing and put it in my c:\my_oracle_files operating system directory.
There are 2 scripts that need to be run. The first as sysdba to create…
|
| 38 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 18:28 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…changed the names, and removed the "parallel 5" and it seemed to have worked. Here is the script that I ran:
commit;
--DROP TABLE KJC_TEST_INDEX_1;
CREATE TABLE KJC_TEST_INDEX_1
&…
|
| 39 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 16:35 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…removed the Drop index. So now instead of taking 20 minutes to drop the index it is taking 20 minutes to drop the table. In all it still takes 31 minutes to run the script and I am still getting the same error message.
Here is the script…
|
| 40 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 13:37 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…is a little better picture of what I am running.
BEGIN
commit;
BEGIN
EXECUTE IMMEDIATE 'DROP INDEX MI.kjc_test_index_url1 FORCE';
&…
|
Blog
Search
Help
Members
Register
Login
Home