im sending email with attachment of report output in xml format. file was attached but cant opened.
it show me error at the time of opening that
XML ERROR in Unknown
REASON: Illegal Tag
FILE: C:Documents and SettingsTxisDesktopAR_AGING_DETAILS_1186958_1(3).XML
VALUE: ?B/to{??C
i face this problem when i send mail on yahoo and from outlook. but it opened in gmail, from incredimail
I'm uploading data from excel to our database using forms thru webutil. The problem is when I open the same excel file while the upload process is in progress, the uploading stops, BUT not displaying any error. Not even when I chick Help->Show error.
How could I prevent this error and how to trap and display error message?
I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .
View 1 Replies View RelatedHow can i open a new Excel application from Forms 10g?
View 2 Replies View RelatedI need to generate a single excel file which each department details in seperate sheets of the excel file, each sheet should ne named with department no (ex :Dept_10, Dept_20,Dept_30) and the main excel should be named as Emp_details.
Header row and total row should be in bold.I have created 3 individual excels thru toad and moved them to single excel and renamed the sheets.
Can we programatically do this thru SQL or PL/SQL, does Oracle provide any build packages for excel.As excel files cannot be uploaded,I am unable to upload the excel file I generated manually.
select to_char(empno) empno,ename,job,mgr,hiredate,
nvl(sal,0) sal,nvl(comm,0) comm,nvl(sal,0) + nvl(comm,0) "Total Income" ,deptno
from emp
where deptno = 10
union all
select 'Total',null,null,null,null,sum(nvl(sal,0)),sum(nvl(comm,0)),sum(nvl(sal,0))+sum(nvl(comm,0)),null
from emp
where deptno = 10;
I need to open an excel sheet from PL/SQL program where I will put in the data. How to open an excel sheet from Pl/sql code.I got hold of a code as below Looks like I need to configure DAD PL/SQL
BEGIN
-- Prepare Headers
owa_util.mime_header('application/vnd.ms-excel',FALSE);
--htp.p('Content-Length: '||document_length||NL_CHAR);
--htp.p('Content-Length: '||document_length);
[Code]....
I would like to open a word document /excel sheet /pdf from oracle forms.
View 20 Replies View Relateddoes the path of office on the server or on the client PC?
View 1 Replies View RelatedI m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
I have created the below stored procedure and calling the procedure in when-button-pressed trigger. Problem here is that when I cancel the file selection in file open dialogue box its raising exception.
PROCEDURE TEST
IS
buffer_lines client_text_io.file_type;
v_outputstr VARCHAR2 (32767);
p_delimiter VARCHAR2 (10) := '","';
v_transaction_no VARCHAR2 (10);
BEGIN
[code].......
I am trying to have sqlldr running against a file:
C:oratest20080318
Is it possible I get SQL*Loader-500: Unable to open file and 503 file not found just because the file name does not have an extension?
I can see that any file name I try it looks after whateverFileName.dat! Is there a way to have sqlldr working with files that do not have extensions?
i am trying to open a .pdf file in oracle forms 10g which had stored in oracle 9i.10g database.
so which method shall i use to do this?
how can i open the .fmx file in oracle 10g?
View 12 Replies View RelatedWhen I am trying to open a PLL[5i] through Form5i Builder , Getting Error message like "FRM-10043 Cannot open a File".
View 1 Replies View RelatedI am trying to connect to a remote database (Oracle) using my Windows terminal and I am successfully able to connect. But when I try to open a SQL File is gives the following error:
SQL > @int1.sql
SP2-0310: unable to open file
I found out that this error occurs when the file name or the path is invalid. But since I am having a remote access I really don't know the location. What can be done to remove this error?
I want to use dialog for selecting file in Fomrs 6i.I attached d2kwutill.pll into form, i uploaded d2kwut60.dll into <ORA_HOME>/bin and coded WIN_API_DIALOG.OPEN_FILE to open file. Everything works fine on the machine I'm developing, the open file dialog works and it returns file name. But when i upload form on remote machine where i access through the web it won't work.
I uploaded d2kwutil.plx on remote machine to the directory where forms reside. This is when I attach library without storing full path of it which is in my case c:someFormsDir - note! on remote machine Forms reside on d:Forms, and on local machine I have only c: HDD D: is cdrom and i can't change drive letters.
I also try to upload d2kwutil.plx in c:someFomrsDir on remote machine although forms there reside in d:Forms, but on local machine library(and forms) reside in c:someFormsDir.
None of two above examples work.
I upload d2kwut60.dll in <ORACLE_HOME>in direcotry - doesn't work. I even upload d2kwut60.dll in orahome2in direcory, doesn't work. On my local machine d2kwut60.dll is in ORA_HOMEin where ifsrv60.exe can be found, the same i do on remote.
When I puch button to open dialog for choosing file Internet Explorer freezes.
I've a button on a form and I wrote a trigger when button pressed to open a pdf file and it worked fine this was my
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe Z:BUILTINS.pdf',DDE.APP_MODE_NORMAL);
end;
The thing is this form is used by multiple clients and if a user has a different version of acrobat reader rather than version 8 this will not work how to do it to be uniform?
I am using forms 10.1.2.0.
I am try to open one .fmb file but file is not open in form builder.Its shows message "cannot open file".
I am going to help button its told that fmb in not create in that form builder. but that fmb is made in 10g but now is not open.
i m unable to run the following script in sqlplus
SQL> @D:vasucount.sql
SP2-0310: unable to open file "D:vasucount.sql"
SQL>
When i run the awr report from sqlplus , i get below error message.
Quote:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
[code]////
Also i dont find the awrrpt.sql in the following path.
Quote:
$ pwd
/usr/local/oracle/product/9.2.0/rdbms/admin
$
$ ls -alrt awrrpt.sql
awrrpt.sql: No such file or directory
$
Is it something related to permissions on file ?
We downloaded Arabic Version of workflow from server using WF_LOAD command.We are able to see Arabic names for item type,attribute,message etc if we open the .wft file in customer PC.But if we open it in our PC,Arabic names are coming as junk. We guess that it needs some setups.
setups to open Arabic .wft file in workflow builder in windows 7? The note id 444068.1 is removed by oracle.
Lots of email alerts reporting SQL Loader failures (the data is actually loading) but I want to prevent all these email alerts being fired. We have an SQL Loader script that is failing regularly with this error, however the data does end up in the tables so it must run subsequently succesfully the log files are cleared out quite quickly so it is difficult to track the errors. Why is there no filename just a.day reference in the error log file?
Below is the shell script I do not have much script experience, so I am unable to see how I can alter this...could I add some kind of exclusive lock check to see if I actually have access to the file before SQL Loader tries to Load it?
value used for ROWS parameter changed from 64 to 63 SQL*Loader-500: Unable to open file (/e2e_ms_xfer/cent01/.dat) SQL*Loader-553: file not found SQL*Loader-509: System error: No such file or directory SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
This is the full error log file SQL*Loader: Release 11.2.0.3.0 - Production on Sat Jun 15 12:17:38 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Control File: /tmp/e2e_load_ms_raw_coda.ctl Data File:
/e2e_ms_xfer/cent01/.dat Bad File: /tmp/e2e_load_ms_raw_coda.bad Discard File: /tmp/e2e_load_ms_raw_coda.dsc (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Bind array: 64 rows, maximum of 256000 bytes Continuation: none specified Path used: Conventional Table MS_RAW_CODA, loaded from every logical record. Insert option in effect for this table: APPEND TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype -----------CODA_RECORD FIRST 4000 CHARACTER Terminator string :
[code]....
How to make an item as a mandatory field dynamically with the change of another item in different regions
View 8 Replies View RelatedI am trying to get a readable version of a .trc file generated by Oracle
10.2.0.4.0 with tkprof, but I still have been unable to get this done...and this is what I have already tried:
tkprof /u00/app/oracle/admin/DB/udump/*BITN1234.trc /batch/salidas/student/BITNTRACE.txt
And whether I run this from my PL/SQL process (PRO*C) or from a command line, it returns:
TKPROF: Release 10.2.0.4.0 - Production on Thu Jan 6 11:04:38 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
could not open trace file /u00/app/oracle/admin/DB/udump/BITN1234.trc
I have already (from my PRO*C code and from command line)...
- made sure that the file is in the directory.
- run this from the udump directory, where the .trc file is...didn't work.
- run this from the udump directory, and specifying explicitely the
complete path anyway in the tkprof line (redundant...I know)...didn't work.
- tried to copy the file to another directory in order to run the tkprof,
and it returns:
cp: BITN1234.trc: The file access permissions do not allow the specified
action.
- tried changing privileges with:
chmod a+r BITN1234.trc
and it returns:
chmod: BITN1234.trc: Operation not permitted.
- tried to run tkprof01 instead of tkprof and it returns:
We trust you have received the usual lecture from the local System Administrator. It usually boils down to these two things:
#1) Respect the privacy of others.
#2) Think before you type.
I am using oracle 10g R2. Some how control file is corrupted and database is not open. and there is no backup of control file. Now i need to open the database without recreating the database.
View 5 Replies View RelatedI am recieving errors when trying to load the control file. The errors are as follows:
SQL*Loader-500 Unable to open file (homework.ctl)
SQL*Loader-553 file not found
SQL*Loader-559 SYstem error: The system cannot find the file specified.
My control file is located directly in the C drive (C:homework.ctl). The control file contains the following
LOAD DATA
INFILE 'c:country.dat'
APPEND INTO TABLE homework
fields terminated by ',' optionally encloded by '"'
(country, month, day)
WHEN (month='April')
The command I am entering is:
sqlldr system/password control=homework.ctl
I've tried c:homework.ctl, 'c:homework.ctl', and placing the file in the BIN folder of Oracle.
when i run the script file 1.sqlIt throws me following error
SQL> @/c/temp/1.sql
SP2-0310: unable to open file "/c/temp/1.sql"
I have generate a excel file through oracle developer 2000 6iwith password protect using OLE2 but autofilter,sort and format column options are not working.
PROCEDURE UnProtectCell(r NUMBER,c NUMBER) IS
BEGIN
args:= ole2.create_arglist;
ole2.add_arg(args, NumToRange(r, c));
XLRange:= ole2.get_obj_property worksheet, 'Range', args); ole2.destroy_arglist(args);
[code]...
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 have 3 code files written in ProC. I have precompiled, compiled, tested them in my local environment (Windows) & they work fine. But when I try in real environment, AIX 5.3, I can precompile them. But when I try to compile & link them with the libclntsh library I get errors. I am using a Makefile but just for testing this is the command -
xlc oraProcs oraProcs.c test_curva.c lib_util.c -I $ORACLE_HOME/precomp/public -L $LIBPATH -l libclntsh.a
Error - ld: 0706-006 Cannot find or open library file: -l libclntsh.a
ld: open(): A file or directory in the pathname does not exist
where LIBPATH = $ORACLE_HOME/lib
library libclntsh.a exists in $ORACLE_HOME/lib & has the right permissions
I also tried removing the library libclntsh.a & recreating it using the command - genclntsh When I run this command I get this warning more than once -ld: 0711-783 Warning TOC overflow TOC size: 66888 Max size: 65536 genclntsh creates the library libclntsh.a, just not sure if these warnings damage the library file and are related to my link erros in some way.