Forms :: Find Path In Oracle 6i?
Nov 1, 2011how can i get full path in oracle 6i???
View 2 Replies
ADVERTISEMENT
Forms :: How To Find File Path Dynamically
May 10, 2011how we can find file path dynamically. In paramenter we can give only destination file name like EXCEL.EXE. and its give me full path of EXCEL.EXE file.
View 1 Replies View RelatedForms :: How To Know Operating System Current Path In Oracle 10g Forms
Apr 19, 2011How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View RelatedSQL & PL/SQL :: Find The Longest Path
Mar 25, 2013create table test
(
avarchar2(10),
bvarchar2(10)
)
/
insert into test values ('A', 'B');
[Code]...
We want to get the path from "A" to "E". In other words, if we start with any value of the column "a" we have to reach the "maximum" value of the column "b".
"maximum" in sense that we don't find the value of "b" in "a".
Example :
---------
E is not found in the column a, so E is the maximum of A.
- N is the maximum of K
- Z is the maximum of Q and the maximum of S
select ...
from ...
where a = 'A' should return E.
SQL & PL/SQL :: Find Shortest Path With Visits
Jul 3, 2013I am find about an algorithm of shortest path with visits certain nodes.I have a table of Links with this fields: ID_Link, City1, City2 and distance...You have informations about shortest path with visits?
View 9 Replies View RelatedHow To Find Previous Path Location Of Archive Log
Apr 15, 2013Practicing in VM. My question is, I deleted the physical files of the database on Sunday but I'm having physical files backup on Friday. firstly i done restore, Performing incomplete recovery , I'm getting error like "Cannot open Archive log"
On Saturday, I changed path of archive log but I'm not aware of archive previous path location. How can we find previous path location of archive log?
Backup & Recovery :: Error / (OS 3) The System Cannot Find The Path Specified
Jul 22, 2011when i am running this syntax in rman i got this error so can you suggust me a correct syntax
Quote:
RMAN> run{
2> allocate channel c1 device type disk maxpiecesize 5m;
3> set backup copies = 2;
4> backup datafile 1 format 'E:
ol\%u_%c','E:
ol\%u_%c';
5> }
allocated channel: c1
channel c1: sid=142 devtype=DISK
executing command: SET BACKUP COPIES
Starting backup at 22-JUL-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF
[code]...
Automatic Storage Management :: Where To Find Grid Path In 10g
Mar 6, 2013i am adding luns to the asm diskgroups in 10g where to find the grid path in 10g .
in 11g i can find
/orainfra/11.2.0.3/grid/bin/amdu -diskstring '/dev/oracleasm/disks/DATCSLGGPA*' -dump 'DATCSLGGPA'
but i can't able to find in 10g .
Forms :: How To Set Dynamic Path In 6i
Aug 6, 2008I am using Oracle Form 6i. I have created pdf file from oracle report. On view button, I have written:
host('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe C:dailypending.pdf');
I don't want to set this path on every machine. I want to set its dynamic path so that on which even I machine, I run the applicaiton, it will directly find AcroRd32.exe from any drive either C: or D: or anything else...
It might be Acrobat Reader 9.0 or 8.0 whatever version will be installed on client machine...I want to set path according to that..So that whatever version it would be, it doesnt affect the application..
Forms :: Path To Use DLL - Library Not Available
Oct 18, 2013How to use the DLL? My DLL is loaded on the client host in the C: Documents and Settings USER webutil. When you try turning to the library, I get an error:
WUL-928 [CApiFunctions.set_invokeoncespec ()] EXAMPLE.DLL library is not available or does not contain a function MYFUNCTION
Forms :: How To Set Registry Path Under 6i In CentOS
Dec 26, 2012How set the registery path under forms6i in Centos
View 4 Replies View RelatedForms :: Setting Output Path
Feb 1, 2010Recently i faced with a situation of redirecting a report output to a particular path in my server, and then opening the output by using web.show_document.
I was successful in redirecting it too a path , however i am not able to open the file using URL. We should setup virtual path in orion-web.xml and proceed further.
I pointed the output to an existing virtual path as below in my orion_web.xml file.
D:OraHome_2 oolswebhtml
and tried opening the output through the url
<<<server_name>/forms/html/filename.extn>>>
however i was not able to add new virtual path here .
Forms :: Use Only AcroRD32. Exe Without Using Proper Path?
May 10, 2013i m using oracle d2k i want to open a pdf file given proper path of C:Program FilesAdobeReader 9.0ReaderAcroRd32.exe but i want to use only AcroRD32. exe without using proper path how i use it
View 6 Replies View RelatedForms :: Find Key Pressed And Release Action On Oracle 10g
Dec 14, 2012we need to find the key pressed action and key release action on Oracle form 10g. On key pressed (i.e. key-up, key-down, key-page-up and key- page-down) the event will be fired and as soon as the user release the key, the event will be stop.
As current situation, we have one form which contains the database blocks. As per search condition, all the data populated in Database block, there are 1000 and more records. Now user going use any of key (i.e. key-up, key-down, key-page-up and key-page-down) as he pressed key ( say Key- down) it scrolled down but as soon as he release the key, the event is not stopped. its going on going down then stop.
Is it possible, as user release the key scrolling will stopped at same time ?
Forms :: Call PDF File Without Specifying Reader Path?
Apr 27, 2011I need to call pdf file in oracle form 6i without specify the path of adobe acrobat reader. how to do that?
i.e.:
AppID := DDE.App_Begin(<path where you have winword.exe in your system> <path of the document you wish to open>,DDE.APP_MODE_NORMAL);
i dont need to write ths part
<path where you have winword.exe in your system>
that because in our company we have several virgins of acrobat reader and i really need to call pdf file and make the call statement public
Forms :: PERMISSION DENIED While Setting Value Path
Oct 13, 2012At the time of installing developer 6i am getting the above error,at the stage of selecting the path for forms its throwing the above error saying the permission denied in setting the value path....
does any one come across this type of error before...
Forms :: Oracle 6i For Windows 7 64 Bit / Can't Find Exact Location From Google
Sep 20, 2012i want to download form 6i and report 6i for window 7 64bit. from where i can download it. i can't find exact location from google.
View 6 Replies View RelatedImport Oracle 9.2 Exp To 11.2 - How To Change Path
Dec 10, 2012The source server (9.2) is /oracle/data/xxx the destination will be /u02/oradata/xxx how do I get the imp to change the paths.
I know you can't do db_file_name_convert, as that only works in dataguard with rman, and it looks like you can only set compatible down to 10.2, it's a very small DB, (5Mb) but it's a live license server DB, I need it intact.
I tried a straight import, but that just barfed with "IMP-00015: following statement failed because the object already exists:" on every statement.
EDIT: it's lying, the /oracle path doesn't exist, just FYI.
How To Change Oracle TNS Listener Path
Oct 29, 2010how to change this path:
F:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR
to this path:
d:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR
in the service ?
Forms :: How To Get File Directory Path Dynamically In The Report
Sep 6, 2013I want to get file directory path dynamically with out using directory in database or not hard code like below
the purpose is i need to check image in the path directory if not found i unable to generate report, is there any possible to get dynamically
function CF_URLFormula return Char is
v_handle utl_file.file_type;
v_file_dir VARCHAR2(60) := '/u002/app/applmgr/temp/';
begin
v_handle := utl_file.fopen(v_file_dir, :photo_name, 'R');
utl_file.fclose(v_handle);
RETURN v_file_dir||:photo_name;
exception
when others then
srw.message(100,SQLERRM);
return null;
end;
Oracle 10g With Developer 2000 - Report Path?
Feb 6, 2011I am working on oracle 10g with developer 2000 . I have a problem while running reports. when i run a report it goes to a particular path in which my database are not there and hence gives a error 'cannot find server'. everytime i have to physically change the path of the database to run the report.
THE PATH WHERE MY APPLICATION AND THE IP ADDRESS OF WINDOWS SYSTEM IS THIS
[URL]...
WHERE AS THE REPORT TAKES ME TO THIS PATH
[URL]...
I had a look at the reports conf file , but couldnt find the path of the database which the report shows for me to change it. It looks like some where the report path has been hardcoded but i am not able to locate it.
There might be some link missing while installing the application and the database.
Forms :: How To Call Batch File Existing In Network Path Through 6i
Aug 10, 2011How to call a batch file existing in network path through oracle forms 6i. I am using following code in Forms 6i which is supposed to FTP some .text files to a UNIX box.
Host( '\guww.netdfs.root.Global Shared Data$(LEV)Leven Shared DataLeven Shared DataPublicCOMMONMatsEmpty Bottle ReportsSchedules Preliminaryftp_files_to_ddd.bat');
When I am running this batch file ftp_files_to_ddd.bat from local directory of my PC,it is working properly.
Installation :: Environment Variable Path Failed In Oracle 11g?
Dec 13, 2012i am reinstalling oracel 11g in my window 7 64 bit machine after i uninstalled it. however, i got an issue that is environment variable path failed in the installation process. this didn't happen when i firstly successfully installed oracle.
View 7 Replies View RelatedServer Utilities :: Default Path Of Log File After Import Dump In Oracle 10g
Feb 25, 2011What is the Default Path of Log File after Import Dump in Oracle 10g.
View 1 Replies View RelatedForms :: Image Path Save In Database And Image Name As Design Number?
Jun 3, 2009I create a simple table for image
CREATE TABLE image_table (
Design_no varchar2(10),
filename VARCHAR2(255) PRIMARY KEY,
image LONG RAW);
Then i create simple block of image_table
its show me in this website [URL] My question is i don't want to give my form path always.i want to save my picture path in my database and the name of my picture always same as my design_no column.
For example i want to save a picture in my database i will copy my picture in d:shahzaib1234.jpg now i want the path d:shahzaib save in database and when i copy my picture which path= d:shahzaib and file name = Design no its will automatically save in database.
Forms :: Triggers Regarding Find Query?
Oct 24, 2013I am working on a form, whose one block is query_find, so on clicking find button it will open another block.the find block contain 4 column and second block contain around 10 column.but the column present in find block are associated to standard tables and the column present in block-2 are from custom tables.there is a query which link those column.
I am not sure where to use that query, so that it will take input from the find block and then populate the result into the block-2.
Forms :: Cannot Find Report - Invalid ID
Jan 28, 2013I have a report and save in D:my_app
eport1.rdf
i want call report in a form ;
i write this code in When_button_pressed
declare
v_rep varchar2(100);
rep_id report_object;
begin
rep_id:=find_report_object('D:my_app
[code]...
when i run form in my browser this error Occured;
FRM41219 : can not find report , invalid Id
How To Find When ORACLE Started
Sep 5, 2010I'm connecting from SQL Server to ORACLE (ORACLE is linkedserver) and I'm trying to find out when ORACLE started and how long it has been running. Is there query or command in ORACLE that I can use to check this? Is there more than one option to find this out and is it same for all ORACLE versions or diffferent from version to version?
View 1 Replies View RelatedForms :: Cursor Control In FIND Box When LOV Invoked
Aug 13, 2013When LOV is invoked, i want that my control/cursor should be in FIND text box (as default behavior).
View 1 Replies View RelatedForms :: How To Find Line Number Of Error In 6i
Jun 4, 2012How to find the line number along with package name or procedure name (for ex. in Oracle 10g DBMS_UTILITY.FORMAT_ERROR_BACKTRACE ) where exactly error is coming in forms.There is plsql code written and while executing the code, ORA-01722: invalid number error is coming. For easy tracing the error, any way is there ?
I searched in Google before posting in this forum and found that ON-ERROR trigger if we write DBMS_ERROR_TEXT it will display the ling number along with package or procedure name. But it is not working and this is only giving me error name no line number.