Forms :: How To Read Regedit Using Oracle 6i
Mar 12, 2012How to read regedit using oracle forms6i ?
View 6 RepliesHow to read regedit using oracle forms6i ?
View 6 RepliesI 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.
in my case both are not working as i am using oracle forms 11g with oracle weblogic application server and attached the required .pll libraries in the form but no success yet.
find below the details;
case-1:
V_adobe_key := WIN_API_ENVIRONMENT.READ_REGISTRY('HKEY_CLASSES_ROOT'||'.PDF', '',TRUE);
when i click on the button then i does not show anything.
case-2:
V_adobe_key := CLIENT_WIN_API_ENVIRONMENT.READ_REGISTRY('HKEY_CLASSES_ROOT' || '.PDF', chr(0),TRUE);
when i click on the button form is hanged and on the server machie the following message appears " Close this form". when i close this it close the form applet session completely.
I have a file studnet.txt in following order
JAMs|1231|PHYSICS
SAM|1232|PHYSICS
ALI|1233|CHEMISTRY
I want to read and write data from a file in | seprated mode. file READ and WRITE using Oracle Forms6i. I have a knowledge of file handling in C++ but not use it in Oracel Form before this.
We have recently shifted our database from 10G to 11G and after the intial hickups most of the thinghs have stablised. We had changed system by Alter System command so that database does not have case sensevity problem and with that all the reports from the forams have also stabilied However some of the forms are failing with the above error ORACLE ERROR Unable to read list of values
These form are running fine with users having DBA privelege. However other users this is failing.
We have also checked that with users not having DBA privelege we are able to read the data in the table within the form also. The query in the record group is very simple
"SELECT CODE,SHORTDESC FROM GENCODES WHERE CODETYPE='BS' AND CODE <> '00'"
All these forms were fine previously when database was on 10g.
Moreover there are many other fields where list of values are there and allthose are ruing fine.
I have also checked datatype and length in query as well as fields on the form
I Want Read Image Through URL..Image Is Placed In Another Server Which Is Not in Local Network.
View 1 Replies View Relatedmy question is how to read ocr in oracle rac?
View 2 Replies View RelatedAm creating a form for some processing text files available in a local users system. Now I would like to get the directory name from the user using dialog box and read the files
[ I am already reading the file, but I allow the user to select the specific file name using get_file_name ]
I want to know can Oracle Forms 6i read data throught a BarCode scanner device.
And is there any website that provides different Oracle Data Link Libraries (DLL files) that can be attached to Forms or Reports to provide different utilities to Forms?
created a form which is calling 3 different forms based on the radio button. The main form say 'MAIN.fmb' has the code " execute_query " in when-radio-changed trigger and the following:
if :BLOCK.RADIOGRPNAME = '1'
then open_form('XX');
else if :BLOCK.RADIOGRPNAME = '2'
then open_form('YY');
else if :BLOCK.RADIOGRPNAME = '3'
then open_form('ZZ');
end if;
end if;
end if;
in the pre-query trigger of the control block where XX,YY,ZZ are the three corresponding forms.
While clicking the radio button, 'm getting the error FRM-40010:cannot read form XX.fmb.
the .fmb, .fmx both exist in the location and individually all the forms are working fine but while being called from MAIN is showing this error.
I create a Menu with two Items in it (execute and Exit) .Then i save and compile it with My_Menu name .Then I edit Menu Module Property in Property palette of Module2(file name) .
Menu Module MY_MENU
But at run time its giving me following error message .
frm-10221 can't read menu
Is it possible to read the application URL while running the application
[URL]
Above is my URL i need to read i and t hold it on a variable at runtime
I have 100 image file in C:My_PIC/ i want read these image files and put in a table .
My table have 2 column : Id_pic varchar2(20) ,
PIC BLOB
I want read all files in C:MY_PIC and Insert in My table with a BUTTON in My form
ID_PIC = file name
PIC = image
row can be marked as read only in Oracle database
View 7 Replies View RelatedI want to read a range of excel by webutil in oracle form. I use command:
ole2_client.get_obj_property(worksheet, 'Range', args);
I want to know a list property of an OLE2 Automation Object?
I'm trying to read some data from external device via COMM Port.
Application is running n server and device is connected localy on my PC.
My device iz DPI605R for purpose of� pressure measuring.
I want read 500 GPG image files from a folder ( by A Button in Form ) and move images into a table with a image column (create new records with images) .
View 3 Replies View RelatedI 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..
I am running the login page on the server with the below URL .
[URL]...
However I am getting the below error .
Frm- 40010 Cannot read form test.fmx
I need to modify the procedure to read all the lines of a text. Actually in my table there is a personnel number column with duplicates and a TEXT column.I need to create a procedure to read all the text per personnel number and insert it into a another table.The below code is the procedure which is reading the two lines of text field. How can I modify it to read all the text per personnel number.
create PROCEDURE hr_load_restict_text_proc
as
CURSOR cur_hr_restrict
IS
SELECT personnel_number, line
FROM hr_restriction_text_temp
[code].......
How to read oracle diagram in the documentation?
legend etc.
I have a number of mails every day reporting different things. I would like to load these to an oracle table and query these and have metrics depending on the results in EM. Possible to load a mail to a table? Probably clob.
View 8 Replies View Related1. To create a read only user who can only query the views as well as db tables and views.
2. How to create such a read-only user. 3. I have taken a full expdp backup of the production and trying to import it on the pre-production.
I use impdp
system/password table_exists_action=replace full = y dumpfile=file_name.dmp remap_schema=SYSTEM:NEW_USER remap_tablespace=SYSTEM:NEW_USER ;
This can replace and import the tables but it can't replace and add the constraints , do I have to add some other parameter in the syntax if so what it should.
I am getting the file using CLIENT_GET_FILE_NAME. I need to read the data from the .xsl file and convert it into blob. The file should not be stored in DB.
View 8 Replies View RelatedI need to develop a form which has to read and display the contents of a text file that is stored in the Unix system where the Oracle data base is installed. So basically its the database server and not the forms application server.
1. Create an external table for the file everytime when the form is loaded by dropping and re creating the table and base the data block in the form on that table and execute_query and display the contents.
2. I am confused whether to use webutil or utlfile packages to read from the file and display on the screen as the file resides in the database or Oracle server and not forms application server or client machine.
How do I check for the data in the DMP file.
Actually I have done some search but with no result. I have to check the oracle DMP file which is being sent through the EXP utility from oracle and have to search for a pattern in the file. If the pattern in found then send a mail.
I have tried using the GREP on the DMP and SED but as the lines are longer than expected these are not providing desired results.
I have Oracle 10g on an XP machine, and use the 'Oracle in OraDB10g_home1' driver to read the data. I have another Windows Server 2008 R2 machine on the same network, with SQL Server 2012 on it. What is the best way to read Oracle Tables in SQL Server? Can I setup an ODBC link from my Windows Server machine to the Oracle Database (which would require me to download an Oracle ODBC driver)? Or is the best way to export the required tables from Oracle (e.g. into csv format) and import them into SQL?
View 1 Replies View RelatedI need a tutorial for using utl_file package to read and load in to oracle data.
Oracle is in Linux box.
I have a Clob file as a in parameter in my PROC. . File is comma separated.need procedure that would parse this CLOB variable and populate in oracle table .
View 6 Replies View RelatedI would like to develop a form which will be replica of windows explorer.It should be able to read all files or files from a specific folder from an unix platform.
if yes can i have a template. I do not want to start from the scratch since I do not have much time.