| |
4997 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
…you!!
Just for my understanding. Why did I need to do that?
Here is my thinking.
I dropped the table, and thus the index was dropped.
I also dropped the preference: KJC_TEST_INDEX_2_NETWORK_PREF
and then recreated.
I then …
|
| 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
…have modified the script to include this:
BEGIN
CTX_DDL.CREATE_PREFERENCE('KJC_TEST_INDEX_2_NETWORK_PREF','NETWORK_DATASTORE');
CTX_DDL.SET_ATTRIBUTE('KJC_TEST_INDEX_2_NETWORK_PREF','Timeout','3600');
…
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 01 January 2023 05:01 «»
By: mape
xml error eurofxref-daily.xml
…
I have been reckoning my brains over xml parsing and without any successfull.
Does anybody please know to correct write a sql to work fine ??
The source of xml is from website => https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml
…
|
| 8 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 10:57 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…think I am getting closer. Here is what I have so far, but it is failing. I am getting a certificate error. How do I resolve that? See error message at bottom.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE …
|
| 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
…am trying to index the content of a document using NETWORK_DATASTORE in Oracle Text. The URL that I am providing for the document is valid. I have logged on to the DB server, and using FireFox validated the URL. But the content is not being …
|
| 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
…did not index the document.
Here is the script that I ran:
DELETE FROM KJC_TEST_INDEX_1 WHERE assigned_id = 'MCP-135'
/
INSERT into KJC_TEST_INDEX_1 (assigned_id, text_content_url)
VALUES ('ABC-123', 'http://www.example.com/index.…
|
| 12 |
Forum: Text & interMedia «»
Posted on: Wed, 16 August 2023 17:12 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…am past the Cert error and it is indexing the content of the document. However, it is still incomplete. It is only created 203 tokens off of a 58 page document. It is missing several words, and numbers. It is incomplete. That…
|
| 13 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 19:48 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…I ran the script where you changed the names and removed parallel, I got the same results as you. Hopefully, you left everything intact at that point. Please run the script below. I have posted the output that I got below that. If …
|
| 14 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 03:17 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…is my test with network_datastore and 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##…
|
| 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
…
NOBODY can tune a SQL statement just by looking at it.
Not even Oracle, which is why this is a manual process.
But WE can help! Just follow these easy steps.
Post your SQL
Make sure it's formatted, otherwise we can't (and won't!) read it…
|
| 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
…you change this:
BEGIN
CTX_DDL.CREATE_PREFERENCE('KJC_TEST_INDEX_2_NETWORK_PREF','NETWORK_DATASTORE');
CTX_DDL.SET_ATTRIBUTE('KJC_TEST_INDEX_2_NETWORK_PREF','Timeout','3600');
ctx_ddl.set_attribute
&…
|
| 19 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 08:47 «»
By: kjcook
Re: How to determine last tiime Content was indexed
…is the script that I ran. I had to change a few things in order to get it to run.
commit;
DROP TABLE KJC_TEST_INDEX_2;
CREATE TABLE KJC_TEST_INDEX_2
(assigned_id VARCHAR2(11),
…
|
| 20 |
Forum: Text & interMedia «»
Posted on: Mon, 14 August 2023 15:24 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…following is a simplified demonstration based on your previous post that shows how to check your index creation for errors and how to create a log of the details of the index process from running the index creation statement, then check that log. I …
|
| 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
…should be able to copy and paste the query below and run it.
SELECT TOKEN_TEXT
FROM DR$IMT_MSTR_INDX_URL1$I T
, MASTER_INDEX X
, DR$IMT_MSTR_INDX_URL1$K K
WHERE CONTAINS (X.…
|
| 23 |
Forum: Reports & Discoverer «»
Posted on: Mon, 10 July 2023 02:46 «»
By: shahzaib_4vip@hotmail.com
Hyperlink report to report
…All,
Good Day!
when i run my report with software 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&…
|
| 24 |
Forum: Backup & Recovery «»
Posted on: Fri, 21 April 2023 03:35 «»
By: Michel Cadot
Re: Oracle RMAN Backup API
…
If you can launch a shell script or command then you can do it easily using something like:
rman target / nocatalog log=$LOGFILE append cmdfile=$CMDFILE
where $CMDFILE is a file containing your RMAN commands.
There is an API (DBMS_BACKUP_RESTORE) …
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 01 January 2023 06:40 «»
By: Solomon Yakobson
Re: xml error eurofxref-daily.xml
…
with sample as (
select xmltype('<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</…
|
| 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
…
Before presenting McDP, I will make some reminders about export and import in Oracle.
These programs allows to unload into files part of a database and reload these files into another or the same database, with or without modification on the objects…
|
| 29 |
Forum: Marketplace «»
Posted on: Thu, 18 February 2016 12:02 «»
By: Michel Cadot
McTnsping: a tnsping-like program for Windows
…
I have posted a tnsping-like program in our tnsping wiki page.
This is a Windows stand-alone program which requires no Oracle client.
It implements easy connect strings, tnsnames.ora or ldap resolution method.
The help is the following one:
C:\>…
|
| 30 |
Forum: Server Administration «»
Posted on: Tue, 19 August 2025 11:51 «»
By: John Watson
Re: Can not Log In Using the Webinterface
…use [code] tags to format your posts, I did ask you to do that before.
Your SCOTT user has no privileges, he won't be able to connect. And you can't connect to an http listening port with SQL*Plus, you have to go to a SQL*Net listening port. …
|
| 31 |
Forum: Server Administration «»
Posted on: Fri, 15 August 2025 08:14 «»
By: Fall and Winter
Re: Can not Log In Using the Webinterface
…Hi,
Here is the in/-output
SQL> ALTER SESSION SET CONTAINER = FREEPDB1;
Session altered.
SQL> create user SCOTT identified by tiger;
User created.
SQL>
SQL> exec dbms_xdb_config.sethttpport(8008)
PL/SQL procedure …
|
| 32 |
Forum: Server Administration «»
Posted on: Thu, 14 August 2025 09:49 «»
By: John Watson
Re: Can not Log In Using the Webinterface
…to the forum. Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
You'll need to a bit more than enabling the listening port. This little demo works for me in 19.x, I haven't tested in 23.x
exec …
|
| 33 |
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…
|
| 34 |
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 …
|
| 35 |
Forum: Weblogic & Application Server «»
Posted on: Tue, 16 January 2024 02:51 «»
By: calacausi
Oracle Reports server 12c. "showjobsid" page does not close
…hi,
we have reinstalled Oracle Application server 12c on a Windows 2012 server. Installation process ended successfully, but when we run a report, the showjobid (eg: http://serverURL:7777/reports/rwservlet/showjobid73?server=rep_wls_reports_srv&…
|
| 36 |
Forum: Performance Tuning «»
Posted on: Sun, 31 December 2023 02:46 «»
By: Michel Cadot
Re: query output speed very slow
…
For 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…
|
| 37 |
Forum: Security «»
Posted on: Wed, 18 October 2023 12:58 «»
By: John Watson
Re: Security & Encryption
…there - I don't understand what you mean by "isolation", but a reasonably standard way to encrypt without the EE Advanced Security Option is to cover the tables with views that decrypt on select and use triggers to encrypt on UPDATE and INSERT. …
|
| 38 |
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.…
|
| 39 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 02 September 2023 15:09 «»
By: Barbara Boehmer
Re: Jaro-Winkler similarity for 9i
…is my test, removing the diacritical marks and multiplying your result by 100 and rounding it for comparison. It seems to perfectly match Oracle, so if that was the goal then you succeeded, at least with this original dataset.
C##SCOTT@XE_21.…
|
| 40 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 16:36 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…got it working. The auto_filter and the nopopulate are apparently incompatible with the directory_datastore. If those are important and you need some sort of substitute or workaround let me know and I will see what i can figure out.
…
|
Blog
Search
Help
Members
Register
Login
Home