I'm planning to do a single-sing-on in one of my applications. To get to my application, the user has to log in to a portal-application befor. From this application i receive 2 headers, to verify this person has authenticated successfully. But how can I read these 2 headers? It doesn't work with the UTL_HTTP package, because i don't do an active request on an url.
View 8 RepliesMy company recently purchased a package that is capable of automatically printing/caching reports generated by Oracle Reports at specified points in workflows, and so I am trying to design some reports that match the output of previous systems.
I'm having particular difficulty making one of them work the way I need it to. I've put a screenshot of how the report should be laid out (and how I've currently laid it out in Oracle Reports Builder) in the attachment. I'm using Oracle Reports Builder 10g against an 11g database.
Here's what I'm trying to accomplish:
The Header Information in Repeating Frame 1 should be visible on every page of the report. Shipments may cover multiple pages, and I want this section (logo, shipment number, date, carrier) on all of them. The Logo is in a BLOB in the database.
The information in Repeating Frame 2 should be visible on the first page for a shipment, but not on any other pages for the same shipment. Multiple shipments may be printed at a time, so this should only appear at the beginning of the group.
The information in Repeating Frame 3 and the nested Repeating Frame 4 should be visible on every page. I've tried multiple methods to make this work.
I've tried setting the main frame (Repeating Frame 1) to print on all pages, as well as Repeating Frames 3 & 4, with Repeating Frame 2 set to print only on the first page. This combination only yields the first page of the first shipment - no more.
I've tried removing frames 2, 3 and 4 from frame 1 and making them all independent of one another. This seems to yield a cartesian product-like result with all shipment lines attached to the first page and only frame 1 showing up on subsequent pages.
I've tried moving the "Header" information into the top margin. When I did, I got a "frequency below the group..." type of error for the fields in the margin. I then tried to create summary columns with breaks on pages that I could reference in the margin, but I couldn't get the image (from the BLOB) to output.
I want added one new column in the below report which will shows only the items purchased on Cash basis but when i am running the query the column not showing any data.
The query is :
Select DISTINCT ou.name||' Spare Parts' ORG, oh.order_number, trx.trx_number, trx.trx_date, p.party_name CUSTOMER, l.ordered_item,
/* ( Select Distinct it.description From MTL_SYSTEM_ITEMS_B it Where it.inventory_item_ID = l.inventory_item_id and it.organization_id = o.organization_id) Item_Desc, */
l.ordered_quantity, l.line_number,
l.inventory_item_id, l.unit_list_price , ----
a.account_number CST_NO ,
oh.Attribute1 MODEL , oh.Attribute2 SERL_NO, oh.attribute3 PAYM_MODE ,
u.user_name Prep_By, oh.CUST_PO_NUMBER PO_NUM,
[code]......
Im trying spooling a file in DB with below mentioned details.
SET SERVEROUTPUT OFF
set heading on
SET PAUSE OFF
SET FEED OFF
SET PAGES 0
[code]........
file .sql has 20 odd columns.
When file is spooled, it shows no columns headers at the top, why is it happening, I don't want to spool column headers separately.
I am using Form graph.jar forms it works properly but in case of bar graphs. i want to display values in the headers of bars.
View 8 Replies View RelatedI can't figure out how to configure the query editor to copy the column headers with the query results on to the clipboard?
View 18 Replies View RelatedIn a classic report, I'm using the Sum functionality and breaks by First Column to get subtotals and report total. I Repeat Headers on Break which works great for the subtotals but I would like for the report to display the column headers above the report total for easier reading. If the last grouping has a lot of data, the user needs to scroll up to read the column headers when looking at the Grand Total.
Is there a way to Repeat Headers prior to report total?
I have a requirement to capture a large number character string which is an output from http request. I created a CLOB datatype to capture it. I see an issue of truncating of the characters after 1998 character's (Block 1, below). If i assign the same ouput put and assign to variable of CLOB type and displaying 3794 Character as required(Block 2) which i am expecting the same in Block 1 too to see entire string ....
For your reference pl copy below link and past in explorer to see th entire output put.
********
http://gissms-stg-05:8399/arcgis/rest/services/ESRI_Route_NA_SA_CF/NAServer/Service%20Area/solveServiceArea?facilities=-95.452487%2C2 9.789048&barriers=&polylineBarriers=&polygonBarriers=&defaultBreaks=1&travelDirection=esriNATravelDirectionFromFa cility&outputGeometryPrecision=&outputGeometryPrecisionUnits=esriDecimalDegrees&f=json
**************************************************************
BLOCK : 1
declare
l_text3 CLOB;
begin
[code]...
We installed new SSL certificate on Oracle HTTP server and getting an error in IE 6,7,8:
res://ieframe.dll/dnserror.htm#https://...
Examining http headers provide following error description:
ERROR_INTERNET_SECURITY_CHANNEL_ERROR.
How was it resolved?
How to check the open http connections in the database as I am getting.
ORA-29270: too many open HTTP requests
We have a requirement like, we will get bulk data (2 GB) data file with different languages(Russian, chinese, Japanese, German) etc. and we need to load these data into our databse also we have to translate the same.
We are using Oracle 11g.
We had used Oracle httpuritype - And the below mentioned procedure PROCEDURE TEST.PRC_TRANS_GERMAN will call the function - trans_jef
Input parameter for PRC_TRANS_GERMAN - > To_language and from Language. and this procedure will store the translated word in the seperate table. Input parameter for the function trans_jef - > Word to be translated , from languae, to_language. And this function will return the translated word.
The issue I am facing is when I am passing the table of around 10000 records, around 4000 rows are not getting translated. So when i try to capture the error in exception- the error is
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1819
ORA-29270: too many open HTTP requests
When I try to re execute the missed words, they were translated. But they are not getting translated in one go because of the too many http open request.
how to resolve this ORA-29270 errror.
Translator
/* Formatted on 07-09-2012 09:19:33 (QP5 v5.215.12089.38647) */
CREATE OR REPLACE FUNCTION trans_jef (v_RawText IN VARCHAR2,
v_SrcLang IN VARCHAR2,
[Code]...
i use netbean 7.2, oracle 10g, when i run a servlet with db connection program i got 404 or 405 error type. if it is not properly to db ? i download a odbc6.jar file and paste it in C:Program FilesJavajre1.6.0lib also add as jar file in library tab of netbean ide. then whats the problem in it?
View 1 Replies View RelatedCurrently I am using Oracle 9i Database and 10g Developer when I connect via login/password successful login but not execute and shows the error
FRM: 10142 The HTTP listener is not running on <computer Name> at port 8889. start the listener and check your runtime preference.
I'm using Report Builder 9.0.4.0.33.
I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.
But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.
function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;
[code]....
But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.
I am using Http URL Connection class to post a data to a URL (which is a web service). The web service accepts data as text / XML.
Following is the code snippet i used:
URL url = new URL("http://xxx.xxx.xx.xx:8080/SampleWebService.svc");
HttpURLConnection conn =(HttpURLConnection) url.openConnection();
conn.setDoOutput(true);
conn.setRequestMethod("POST");
[code].....
But when i execute the code, I am getting following error at the line(InputStream in2 = conn.getInputStream()wink.gif
java.io.IOException: Server returned HTTP response 400 for URL
I have this code when i run this I get credentials error. How to give credentials .The authentication is set to windows in the https page. Means pop up will appear to get the credentials
declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
value varchar2(1024);
p_url varchar2(4000);
OPT varchar2(1000);
BEGIN
dbms_output.put_line('');
[code]....
Apex 4.1.1 or 4.2 -
I do not see an option in web sheets to use HTTP Header values for authentication. Any workaround in order to use OAM for authentication to web sheets?
we have RAC of two nodes and EM is not running on one instance and running on another instance. when i issue emctl start dbconsolecommand it trying to start for 50 minutes but at the end, it failsi have checked the log (emagent.log) which is as follows
2012-02-29 14:18:48,971 Thread-1 Starting Agent 10.2.0.4.2 from /u01/app/oracle/product/11.2.0/dbhome (00701)
2012-02-29 14:18:48,973 Thread-1 <Agent Startup> : Startup of HTTP LISTENER failure (00716)
2012-03-01 10:25:43,414 Thread-1 Starting Agent 10.2.0.4.2 from /u01/app/oracle/product/11.2.0/dbhome (00701)
2012-03-01 10:25:43,525 Thread-1 <Agent Startup> : Startup of HTTP LISTENER failure (00716)
[code]...
and output of tail -100 emagent.trc is
2012-02-29 09:24:39,821 Thread-1 ERROR http: nmehl_startHttpListener: failed to listen to HTTP(s) port for https://db1:2928/emd/main
2012-02-29 09:24:39,821 Thread-1 ERROR main: nmehl_startHttpListener failed starting http listener.
2012-02-29 09:43:29,057 Thread-1 ERROR http: snmehl_allocateListenerPort: failed to listen on all sockets for hostname
[code]....
I am still facing the following error even though i have started the OC4j instance,
"FRM-10142: The HTTP Listener is not running on <computernam> at port 8888.start the listener or check your runtime preferences."
I'm having some difficulty securing my Oracle APEX + Oracle HTTP Server environment.
There are currently around 20 Applications running on the APEX Server, and I'd like to publish 2 of them Externally for users.
I have added a certificate to Oracle Wallet Manager to secure the OHS, but I can access all the Applications on the APEX Server by just changing the Application ID suffix.
How can allow only two applications to be accessible via the internet?
SQL*Plus: Release 11.2.0.3.0Solaris 10 SPARC I get the following error when trying to make an HTTP request. Below is the snippet of code I run. I get the error after exactly 60 seconds(default timeout?). The problem does not exist in the rest of our environments, only our test environment.
DECLARE
p_mid_tier VARCHAR2 (500);
responsestr VARCHAR2 (500);
BEGIN
[code]...
We are getting the following error when trying to access a RESTful web service coming from Apex workspace 4.2.1 and Apex listener 2.1:
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-29024: Certificate validation failure
In the Debug report, besides the above I also see:
error_backtrace: ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 543 ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 1164 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 396
We get that error whether we use https or http in the URI pointing to the web service. When I test the Web Service in Workspace RESTful service GUI, I get the data back. When I go build an application with a report calling the RESTful Web Service I get that error. Both the Application and the Workspace RESTful services are on the same Apex environment and even the same workspace.
What is odd is that I can actually put the URL of the web service into a browser and I get the data: (using the demo hr data in sample RESTful services.)IN browser-- [URL]
yields:
7839,KING,PRESIDENT,,1981-11-17T05:00:00Z,5000,,10 7698,BLAKE,MANAGER,7839,1981-05-01T04:00:00Z,2850,,30 7782,CLARK,MANAGER,7839,1981-06-09T04:00:00Z,2450,,10 7566,JONES,MANAGER,7839,1981-04-02T05:00:00Z,2975,,20 7788,SCOTT,ANALYST,7566,1982-12-09T05:00:00Z,3000,,20 7902,FORD,ANALYST,7566,1981-12-03T05:00:00Z,3000,,20 7369,SMITH,CLERK,7902,1980-12-17T05:00:00Z,800,,20 7499,ALLEN,SALESMAN,7698,1981-02-20T05:00:00Z,1600,300,30 7521,WARD,SALESMAN,7698,1981-02-22T05:00:00Z,1250,500,30 7654,MARTIN,SALESMAN,7698,1981-09-28T04:00:00Z,1250,1400,30 7844,TURNER,SALESMAN,7698,1981-09-08T04:00:00Z,1500,0,30 7876,ADAMS,CLERK,7788,1983-01-12T05:00:00Z,1100,,20 7900,JAMES,CLERK,7698,1981-12-03T05:00:00Z,950,,30 7934,MILLER,CLERK,7782,1982-01-23T05:00:00Z,1300,,10
what would be causing the Error above in our application?
In reviewing the above error, I think we are realizing that we have to have the Weblogic layer SSL cert (actually the CERT from our BigIP load balancer which also does our SSL termination) imported into the Oracle server wallet where Apex is installed. Am I correct?
When I call a classic report that is exported throuh restful webservice, result depends on whether I also send cookie or not. In the first case, access is enabled, in the latter case, HTTP 404 is returned.
Restful access is enabled in the instance. Having an app with ID=101, page 9901 that is public, a classic report called MYREPORT on the restful side, the following call is issued:
/apex/apex_rest.getReport?app=101&page=9901&reportid=MYREPORT_ID&parmvalues=123445&output=json
If my browser send the cookie below with the request, I get back the result. If I delete the cookie from my browser, the result for the exact same apex_rest call is HTTP 404: Not found.
Cookie: ORA_WWV_USER_64731425336707=04893186A373057F5F1E1FCCD33113FA; PUBLIC_ORA_WWV_USER_64731425336707=-1; ORA_WWV_REMEMBER_UN=MYNAME:myworkspace
Details on my configuration is as follows:
Database: Oracle XE 11g, 11.2.0.2.0
Apex version: 4.1.1.00.23_en
Platform: Linux x64
HTTP is handles by XEXDB as folows from lsnrctl status:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kivi.omikk.bme.hu)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
I have installed Oracle 11g XE . After this , i have upgraded to Apex 4.2 All it's working fine, but..... by default XE installs and configure apex to use embebed pl/sql gateway.
In this scenario, the images are stored directly in the database within the oracle XML DB repository. This may be a problem because XE have a 11GB limit and my apex aplication is simple, but it may upload pictures for customers, etc, and in this schenma the pictures will consume space in the database instead consuming in the linux filesystem.Can i install HTTP server in a 11g XE and reconfigure apexr?, or can i change to apache+listener? or more easy....can i upload images outside the XML DB in my apex application easily?
We are facing the problem of slow performance in the production system and lots of complaints from the clients for resource busy or system hang related issue. We are finding the locked object in the system which are mostly inactive in nature so we kill them manually and the problem gets resolve.
We have some observation in AWR reports which are as below :
1)
Instance Efficiency Percentages (Target 100%)
Execute to Parse %: -26.96
Parse CPU to Parse Elapsd %: 4.83
===============================================================
2) Total time in database user-calls (DB Time): 55700.6s
=================================================================
3)
TCP_RECEIVE_SIZE_DEFAULT 16,384
TCP_RECEIVE_SIZE_MAX 9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN 4,096
TCP_SEND_SIZE_DEFAULT 16,384
TCP_SEND_SIZE_MAX 9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN 4,096
=================================================================
4)
Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %DB time
Network 45,423,119 0 2,122 0 3.81
=================================================================
5)
Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn % DB time
SQL*Net message to client 45,030,511 0 55 0 127.77 0.10
=====================================================================
The Top Five events are :
db file sequenctial Read
enq TX -row lock contention
DB CPU
Virtual circuit wait
Read by other session
Is there a any oracle doc id or any other document ,which can be referred to get better understanding of AWR Reports and gives the steps of resolution to be taken for various top timed events
I am looking for a code/script to read values from excel file and perform PLSQL script.
Now i have the PLSQL script to generate report which takes two value which i have to change all the time to generate new report .All i wanna do create a script to read from a excel file and perform the other script.
I have been searching from a long time and only found UTL_file Package which use CREATE OR REPLACE FUNCTION and create some virtual table.
The problem is i don't have create authorization in database so i m not able to use UTL_File command . Is there any simple way to read value from excel file?
I am not able to parse this XML message.
with t as (select xmltype('sku_list xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<sku vk_unit="213-13085" model="M14573" />
<sku vk_unit="227-10036" model="M14573" />
<sku vk_unit="227-10037" model="M14573" />
<sku vk_unit="213-13086" model="M14573" />
[code].....
I'm trying to utilize the utl file to read a txt file and import the data into a table in Oracle. I've read in various forums and have researched a lot on oracle documentation site and on the internet but can not find the answer to the problem.
The source follows:
Set serveroutput on
DECLARE
arquivo_ler UTL_File.File_Type;
Linha Varchar2 (1000);
BEGIN
arquivo_ler: UTL_FILE.FOPEN = ('INTRANET_LOAD', 'carga_intranet.txt', 'R', 32767);
Loop
UTL_File.Get_Line (arquivo_ler, Linha);
dbms_output.put_line (Linha);
End Loop;
UTL_File.Fclose (arquivo_ler);
DBMS_OUTPUT.PUT_LINE ('File processed with sucesso.');
END;
/
The errors:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 633
ORA-29283: invalid file operation
ORA-06512: at line 5
What has been done:
Created DIRECTORY (INTRANET_LOAD) and given the GRANT read, write to the user
On Linux where Oracle is installed, was given full access to the Oracle user folder: / u01/app/oracle/product/11.2.0/db_1/adp
When writing the query;
SELECT *
FROM ALL_TAB_PRIVS
WHERE table_name = 'INTRANET_LOAD';
The data are returned.
1 FOLLOW INTRANET INTRANET_LOAD SYS READ NO NO
2 FOLLOW INTRANET IN NO WRITE SYS INTRANET_LOAD
oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"
I have a .xls file, which has few columns with Korean data. I have problem converting it into .csv. I converted it to UNICODE TEXT, which was TAB separated. I replaced tabs with commas. but still saved it as .txt file. Now I am using utl_file package to open and read.
utl_file.fopen_nchar(l_dir, l_filename , 'R',8000);
I outputted the first header line, and instead of Korean fieldnames, it displayed some different characters.. cannot even copy-paste..
I am uploading the converted .txt as I cannot upload original .xls file here...
A doc file stored in a database having data type blob. To read this file I have written Following procedure
create or replace procedure XX_read_blobfile1 as
b blob;
c clob;
n number;
begin
SELECT file_data INTO b FROM fnd_lobs WHERE file_id = 322420;
if (b is null) then
[code]......
With the data displaying some boxes before and after data