| |
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
…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: 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
…ated.
Then I opened using a web browser
http://SCOTT:tiger@127.0.0.1:8008/scott/hello_world
Afterwards I am prompt to enter the user name and password but it doesn't work.
I mean by "web interface" the pages mentioned above wich …
|
| 32 |
Forum: Server Administration «»
Posted on: Thu, 14 August 2025 09:49 «»
By: John Watson
Re: Can not Log In Using the Webinterface
…user anonymous account unlock; --in both PDB and root
create or replace procedure scott.hello_world as begin
htp.print('Hello world at '||to_char(systimestamp));
end;
/
http://SCOTT:tiger@127.0.0.1:8008/scott/hello_world…
|
| 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
…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 …
|
| 36 |
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 …
|
| 37 |
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…
|
| 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
…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
&…
|
| 40 |
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…
|
Blog
Search
Help
Members
Register
Login
Home