Forms :: Installed Forms6i On Windows7 But Ifbld60.exe File Unable To Execute?
Oct 26, 2010I had installed forms6i on windows7 but ifbld60.exe file unable to execute so i want to know is this os problem or need patch to run it.
View 1 Replies
ADVERTISEMENT
Forms :: Unable To Open FMB File In Builder?
Jan 30, 2012I 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.
Forms :: Unable To Read Excel File?
Nov 1, 2011I am trying to create excel file thru form....in form i create button Excel
WHEN -BUTTON - PRESSED :
Quote:
DECLARE
CURSOR C1 IS
SELECT DEPTNO,DNAME,LOC FROM DEPT;
filename varchAr2(256);
[Code].....
My excel file opened but it shows unable to read file
My excel version is 2003..
Forms :: FRM-30087 - Unable To Create File (Developer 9i)
Jun 5, 2003i have successfully compuled and run my Developer9i form on the web but when i make a slight change in the form (add any control or do anything with form) and then recompile it it gave me error: FRM-30087: Unable to create form file why forms show this error and how it can be solved?
View 5 Replies View RelatedForms :: Read / Write In Unix From Oracle Forms Installed In Windows
Nov 24, 2011I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
XML DB :: Unable To Execute Sql Queries Using XDB Service
Aug 3, 2012I am not able to execute sql queries using XDB service
My wsdl is
[URL]......
My manually written call is
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:oraw="http://xmlns.oracle.com/orawsv">
<soapenv:Header/>
<soapenv:Body>
<oraw:query>
<oraw:query_text type="SQL">select 1 from dual</oraw:query_text>
</oraw:query>
</soapenv:Body>
</soapenv:Envelope>
I have tried a few more flavors of soap envelope but I always get the below response instead of the actual response
The response is
<definitions name="orawsv" targetNamespace="http://xmlns.oracle.com/orawsv"
xmlns="http://schemas.xmlsoap.org/wsdl/"
xmlns:tns="http://xmlns.oracle.com/orawsv"
xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
[code].........
Forms :: Installed 10g - Not Able To Run Form?
Jan 6, 2011I installed forms and built a simple form using EMP table.I was able to compile the form successfully but when I run the form it opens IE and says IE has stopped working and closes the program.I have Windows Vista OS and IE7.
View 6 Replies View RelatedForms :: Modifying Form On UNIX Server Using Builder Installed On Windows Desktop
May 20, 2010We are using Oracle Applications hosed on UNIX servers. There is a custom form in XXX_TOP/forms/US folder that I need to modify.
My Windows desktop has Forms Builder 10g installed. I ft pied fmb file over from UNIX server to my Windows desktop and tried opening it. I get an error FRM-18108:
Failed to load the following objects: APPSTAND, etc etc.
Obviously I am not doing it right. What is the correct way of modifying a form file sitting on UNIX server, using Forms Builder installed on Windows desktop? Do I need to copy all dependent objects to Windows desktop along with fmb file?
Execute Sql File From Pl / Sql?
Aug 18, 2010Need to execute @/sql file after checking an output of below sql.
SELECT COUNT(*) FROM all_directories WHERE DIRECTORY_NAME='RMANDUMP';
If directory exist then oonly we require to run sql file.
If there a way we can execute sql files depending on sql output.
Server Utilities :: Unable To Open File And 503 File Not Found
Mar 30, 2008I 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?
SQL & PL/SQL :: Execute KSH File From Oracle 8i?
Jul 4, 2011calling .ksh file from Oracle8i Pl/Sql code.We have Unix and Oracle on same server.
View 39 Replies View RelatedReports & Discoverer :: Execute RDF File Automatically
Jan 17, 2012I have an rdf file of version 6i. I need to execute this rdf daily midnight , generate the output as a pdf and send as Mail attachment.
View 1 Replies View RelatedSQL & PL/SQL :: Execute File In Oracle Stored Procedure
May 16, 2012I need to execute a .sql file in an oracle stored procedure.
View 9 Replies View RelatedClient Tools :: Execute Multiple SQL Files In BAT File
Nov 27, 2012Is it possible to execute multiple sql files in one .bat file?for single sql file it is working properly.
.bat file
-------------------------------
sqlplus /nolog @ c: est01.sql
Backup & Recovery :: Execute A BATCH File Through PLSQL?
May 30, 2012execute a BATCH File through PLSQL.
BEGIN
dbms_scheduler.Create_schedule(schedule_name => 'RMAN_TICKER_STARTING',
repeat_interval => 'FREQ=DAILY;BYHOUR=9; BYMINUTE=15,30,45,59',
comments
=> 'schedule to run daily');
dbms_scheduler.Create_program (program_name => 'TICKER_PROGRAME',
[code]....
It was created successfully, but when I execute, it shows the error message.
BEGIN
dbms_scheduler.Run_job ('RMAN_TICKER_JOB', TRUE);
END;
begin
dbms_scheduler.run_job (
'RMAN_TICKER_JOB',TRUE);
end;
Error at line 1
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with status: 2
[code]....
But I have the CMD file in the location - "F:FEEDLGRTOOLSfeedlgr.cmd".
SQL & PL/SQL :: BFILENAME / Unable To Get The File Using The Command?
Oct 16, 2012i am using a SQL statement as below but unable to get the file using the command :
SELECT bfilename('$APPLCSF/out','XXMSPOSTD_3798178_1.pdf') FROM dual;
ORA-09968 :: Unable To Lock File?
Feb 6, 2013I am using Oracle 11g in my Windows machine. I wrote a multithreaded program that will be inserting into Oracle database so I was getting this exception before-
ORA-12519: TNS:no appropriate service handler found
So after going through various article on the internet. I found that the solution for above exception is to increase the number of processes- So I followed the below thing and it works fine for me after that.
cmd>sqlplus / as sysdba
sqlplus>alter system set processes=300 scope=spfile;
sqlplus>shut immediate;
sqlplus>startup
Now after some more time, I increased the processes to something like below
alter system set processes=1000000 scope=spfile;
And since then whenever I am starting up my Oracle database, it is giving me this exception below and it is happening since one day.
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
Server Utilities :: How To Execute SQLLDR / Where Data File Reside In Another Server
Mar 24, 2010How to execute the SQLLDR, where Data File Reside in another Server?
View 1 Replies View RelatedUnable To Create Audit Trail File?
Jun 29, 2012problem with oracle 10 g . i started service through server i got some error
ora-09925 unable to create audit trail file.
3 files are missing in admin folder these are three files adump, dpdump, pfile was missing i have not taken any backup also.
in admin file also the database folder name was missing.
Unable To Load Data In Oracle 11g From XLS File?
Sep 6, 2011CASE 1:
when i tried to load the data i got the below error,
Error starting at line 2 in command:
INSERT INTO RECON_MATCHED_DETAILS (RECON_MATCHED_DETAIL_OID, RECON_ID, STATEMENT_DATE, EXECUTION_DATE, TRANSACTION_NUMBER, TRANSACTION_DATE, TRADE_ID, TRANSACTION_TYPE, LINK_ID, ITEM_TYPE, ASSET_CODE, ISIN, BUYSELL_INDICATOR, SETTLEMENT_DATE, CURRENCY, QUANTITY, VALUE,
[code]...
CASE 2:
i tried to load the data in oracle 11g but i'm unable to load the data,and for testing i tried with a single row of data.but surprisingly the table filled with (null)s
Server Utilities :: Unable To Do Import Of DMP File?
May 7, 2013I'm unable to do an import of a *.dmp file.
[oracle@oracledbserver ASG1]$ cd /media/volume-01/u01/app/oracle/product/
[oracle@oracledbserver product]$ ls
11.2.0 20-04-2013full_backup.dmp full01-03-2013_backup.dmp new.dmp today.dmp
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$ impdp full=Y directory=agge_dir dumpfile=/media/volume-01/u01/app/oracle/product/new.dmp NOLOGFILE=y;
Import: Release 11.2.0.1.0 - Production on Tue May 7 16:51:47 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39088: file name cannot contain a path specification
[oracle@oracledbserver product]$
This is Oracle 11g hosted on an eucalyptus cloud instance.
Server Administration :: Unable To Run Setup EXE File?
Mar 14, 2012when i try to install Oracle 10g (10.1.0.2) 64- bits on windows server 2003 enterprise edition 64 bits service pack1 and i try for windows server 2003 standard edition 64 bits on a pc,i am getting the below error.
the image file E: is valid, but it is for a machine type other than current machine
i need to install it as soon as possible .
Windows :: Unable To Find DLL Library File
Nov 21, 2012We are getting below error....Our one package called orawpcom.dll library file.
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library
'/oracle9i/app/product/11.1.0.7.0inorawpcom.dll'.
ORA-06512: at "GFSAM.OAINVOKEDOUBLE", line 1
ORA-06512: at "GFSAM.ORDCOM", line 229
ORA-06512: at "GFSAM.ORDEXCELSB", line 450
ORA-06512: at line 43
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library
Attach this orawpcom.dll file?
SQL & PL/SQL :: Using Dbms_sql.execute To Build / Execute Dynamic Sql?
Oct 23, 2013I'm working with old code that uses dbms_sql.execute to build/execute dynamic sql. In our case, the user can select varying columns(I think up to 20) with different where conditions as needed.
After building the sql, here's an example
WITH ph AS
(SELECT ph.* FROM po_header ph WHERE 1 = 2),
pf AS
(SELECT DISTINCT pf.order_id, pf.fund
FROM po_fau pf, ph
WHERE 1 = 1
AND ph.order_id = pf.order_id
[code]....
Where table records for
po_header = ~567746
po_fau = ~2153570
and PK "order_id" is a NUMBER(10) not null and a snippet of the code looks like
nDDL_Cursor := dbms_sql.open_cursor;
dbms_sql.parse(nDDL_Cursor, sSQLStr, 2);
FOR x IN 1 .. nCols LOOP
sCols(x) := '';
dbms_sql.define_column(nDDL_Cursor, x, sCols(x), 100);
END LOOP;
nError := dbms_sql.execute(nDDL_cursor);
why when the "execute" statement is fired off the elapsed time takes ~4.5 seconds but If I change "1 = 1" above to "1 = 2" it takes ~.2 seconds. If I run the above query interactively it takes ~.2 seconds. Shouldn't the above query when joining
ph.order_id = pf.order_id
return zero rows back instantly or does the "dbms_sql_execute" do some other type of parsing internally that takes cpu time.
Forms :: Execute Procedure Using Personalization
Aug 24, 2010I have written a package in that package i have written a procedure. That procedure has two i/p and two o/p variables. I am calling the procedure using the below syntax.
in built in type : Execute a Procedure
='Declare
v_customer_name varchar2(100);
v_id number;
v_out1 number;
v_out2 NUMBER;
begin
v_id := 1041;
XXFBI_OM_UTILITIES.XXFBI_CUSTOMER_CREDIT_DETAILS1(''' || ${item.order.SOLD_TO.value} || ''', v_id, v_out1, v_out2);
end'
Its working fine.
My question is how can i capture the value of out put variables v_out1 and v_out2 and assign to a DFF.
Forms :: Can't Execute Query Button
Jan 6, 2012I currently have a form and when I am logged in as the owner the execute query button can be performed. But when I try and do this with another user the query cannot be executed. I have granted the users with the correct privileges. I am now trying to re-create the data block but with using the synonym but the synonyms cannot be found.
View 8 Replies View RelatedForms :: Windows Won't Allow To Execute SQL Statement
Oct 25, 2011reconciliation logic using Oracle
Version
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
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Current written logic for reconciliation:
1. Load data from source_a in a staging table using date filter
2. Load data from a file (Source_B) in temp table
3. Algo for reconciliation:
fetch value from source_B and if an entry exists in source_a then match say 10 columns if they match update reconciliation_oke = TRUE
there is an and written for testing all the 10 columns There is report generated out this which shows non matched columns and the entries which are missing....Now the requirement is to modify the logic in a way which shows which all columns are mismatched on the report in case present.
Since there are around 10 thousand records which would be reconciled on a daily basis, performance also needs to be taken care of...I guess i would be required to use PL/SQl tables...
Forms :: EXECUTE QUERY Using A Where Condition?
Jun 27, 2013how can i execute query using a where condition?
View 9 Replies View RelatedUnable To Deleted Archive Log File On Windows Server?
Sep 20, 2010version: 10.2.0.4
OS: windows server 2003
I am not able to delete one month old archive log file manually on windows which doesn't having info about the standby on v$archived_log view of primary database. the sequence were already applied to the standby database. It shows the status as deleted in v$archived_log. while deleting the file manually. it showing an error like another program or person is using it.
ORA-27047 / Unable To Read Header Block Of File
Apr 26, 2011I am trying to create standby with oracle 10g R2 from Solaris 5.10 (sun ultrasparc X86-64 bit) to Solaris 5.10(Intel Xeon 64 bit). All the mount points are the same as primary server. All the data files are at location as specified in control file. I created standby control file from primary. All the control files are at location specified in pfile.
When I am trying to mount database I am getting following error.
ORA-00202: control file: '/oracle/BP1/ctl1.dbf'
ORA-27047: unable to read the header block of file
ORA-205 signalled during: alter database mount...
I try to open database with trace file also but got following error..
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file
'/oracle/BP1/sapdata1/system_1/system.data1'
ORA-27047: unable to read the header block of file