Forms :: 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
ADVERTISEMENT
Forms :: Uploading Image Which Is Not Database Item From Operating System?
Sep 13, 2010uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.
I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;
But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.
Clusterware :: Oracle Installation On Windows Operating System?
Jun 14, 2012install oracle clusterware on Windows Operating system
View 4 Replies View RelatedForms :: Get The Current User Login On System?
Jun 19, 2011How can i get the Current user log in on my system using global variable.
View 6 Replies View RelatedHow To Get Free Space On Operating System Drive
Nov 5, 2013is it possible to get information about free space on drive/path for example with some DBMS_*, UTL_* package or with stored function based on Java
(e.g. CREATE OR REPLACE FUNCTION GetFreeSpace(driveLetter IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'DiskSpace.getFreeBytes(java.lang.String) return java.lang.String') but for JDK 1.3
Host Operating System Experiencing Significant Paging
Feb 1, 2013I"Host operating system was experiencing significant paging but no particular root cause could be detected. Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory. Also consider adding more physical memory to the host."
My database run on Windows Server 2008 R2 and have 12GB of physical RAM.
Oracle version is 10.2.0.4.0 and my sga and pga are:
sga_max_size 4000M
sga_target 3904M
pga 1200M
I try to find out something about this issue and read many blogs but unfortunately I didnt find anything which worked. Should this have something to do with the fact that on the server we have oracle database and terminal server with 30-40 users?
Server Administration :: Unable To Claim Space For Operating System?
Sep 15, 2012We are in the process of gaining some space in our database. We identified a tablespace that occupied around 400GB of space. The datas are required for us. Hence, we truncated (with drop storage) the tables, gathered statistics and shrinked the tables. After doing that we found the datafile occupied around 32GB of space. We tried to resize it to 5 GB and we got "ORA-03297: file contains used data beyond requested RESIZE value". We could see that size in dba_free_space against that tablespace. We would like to give back everything to OS.
We also tried exporting the tablespace without rows, dropped the tablespace and re-created and imported again. But the datafile grows to around 32G and we are unable to resize it.
We are sure that the tablespace has only the table definitions without data. But we do not know why is it occupying around 32G of space and we could see that size in dba_free_space. We would like to give back everything to OS. How can we do that?
Server Administration :: Remove Datafile From Operating System After Dropping Its Tablespace
Jul 26, 2012I want to remove a tablespace with it's datafile.
I've ran: DROP TABLESPACE x_tbs INCLUDING CONTENTS;
I've read(should have read it prior to action) [URL]tm
and I understand now that I should have stated "AND DATAFILES", However, too late now. the tablespace is removed, but the datafile x_tbs is still present in a folder of my OS.
Is it safe to manually remove it by deleting it from the operating system?
Forms :: Find Path In Oracle 6i?
Nov 1, 2011how can i get full path in oracle 6i???
View 2 Replies View RelatedForms :: How To Focus On Current Record In Oracle
Jul 4, 2011How to focus on current record in oracle forms.
for ex:- I have 10 records in line level.i want to focus my cursor on particular like (5th record) how to possible in form.
Is there any built-in like current_record?
Forms :: How To Get Current Cursor Position In Oracle 10g Form
Feb 25, 2010I want to get current mouse cursor position dynamically,what should i do.
View 3 Replies View RelatedForms :: Difference Between System.current_item And System.cursor_item?
Apr 1, 2012We have system.current_item and system.cursor_item.....
both represent the same....
like this we have few other system variables also .....
what is the main difference between current_item and cursor_item?
Forms :: Write Trigger To Insert System Clock Time In Oracle?
Jan 4, 2013how can i write a trigger to insert the system clock time in the oracle form?
View 15 Replies View RelatedBackup & 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]...
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 :: 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 :: 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 :: 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 :: 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;
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.
Forms :: Getting Current Hostname
May 9, 2011how can I get the form hostname that it is currently running to? I already tried the form's (forms developer 6i) built in host functionality but it doesn't return the hostname.
Our current approach is to have a shell script that will get and insert the hostname into the table and the form will just query from the table to get the hostname, but that approach has involved too many modules.
Is there an easiest way to get the hostname?
Forms :: How To Display Current Record
Mar 12, 2013I have problem about displaying current records with same table(tbl_pawnitem). I have 2 transactions which are the pawned transaction and for sale transaction. and both transactions save into tbl_pawnitem table..i want to display only in my list the for sale transaction without deleting the records of pawned transaction. what condition i will use?
View 5 Replies View RelatedForms :: Order By Current Month
Jan 30, 2011A form has date of birth column.
Date of birth should be displayed according to current month.
Example:
01-jan-1980
01-feb-1975
01-mar-1970
Required:
Let current month is feb then
01-feb-1975
01-mar-1970
01-jan-1980
What should be done?
Forms :: Current Record Indicator
Aug 25, 2011set the current record indicator for my tabular data block.
View 1 Replies View RelatedForms :: How To Update Current Row Comparing It With Existing Value
Jul 14, 2013I have master-detail form I would like to update the emp1 table on the base of current value of dept table deptno and emp table ename .
update emp1
set ename = :emp.ename
where ename =
(select ename from emp e
where e.ename=:emp.ename
and e.deptno=:dept.deptno);
I try the above query but it did not able to update emp1 table.
Forms :: Cursor (control) On Current Record
Jul 18, 2011In my form line level block contains 100 records.i will check the check box for line number 96 and 97. Then i will press save(I have written some logic here) button it will generate one number for selected check boxes. After generating this number cursor(control) should be on same line number 96 or 97.
View 10 Replies View Related
