Forms :: Read / Write In Unix From Oracle Forms Installed In Windows

Nov 24, 2011

I 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.

View 2 Replies


ADVERTISEMENT

Forms :: Modifying Form On UNIX Server Using Builder Installed On Windows Desktop

May 20, 2010

We 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?

View 2 Replies View Related

Forms :: Replica Of Windows Explorer - Read UNIX File System

Jun 14, 2011

I 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.

View 5 Replies View Related

Forms :: Read And Write File Using Oracle 6i?

Nov 16, 2011

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.

View 5 Replies View Related

Forms :: Read File From Unix (Database Server)?

Apr 15, 2010

I 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.

View 5 Replies View Related

Installed Oracle 11.2.0 On Windows 7 64 Bit - Initialization Error

Mar 20, 2011

I install Oracle 11.2.0 on Windows 7 64bit and i install PL/SQL Developer.

when i run the PL/SQL and connect to Oracle i get this error:

Initialization error
Could not load "C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll"

OCIDLL forced to C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll
LoadLibrary(C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll) returned 0

View 7 Replies View Related

Windows :: Detect Oracle Version And Platform Installed?

Mar 14, 2012

Is there a way to check which versions or oracle installed on the machine from command line?

The thing is I don't want to login to the database so I can't use SQL Plus also, till now I ran tnsping and checked the output but in case there are several versions of different platform I got only one version that was first on the path env.

View 1 Replies View Related

Security :: Provide Read / Write Access To Oracle User?

Jun 2, 2011

I will have to provide read/write access to an oracle user. What privileges should i grant to the user so as to enable the user to read from and write to the files?

View 2 Replies View Related

Export/Import/SQL Loader :: Get Exact Path Where SQLLDR Got Installed In UNIX?

Nov 1, 2013

How to get the exact path where SQLLDR got installed in UNIX. I am getting a path related issue while executing SQLDR unix command in Oracle

View 3 Replies View Related

Forms :: Print Oracle Report 10g Using UNIX

Mar 25, 2010

I installed a printer(HP Laserjet 3390) in UNIX(Solaris).Followed the instructions while installing as to the path it should be present for Reports to read it etc.,Also modified the uiprint.txt file with the desired .hpd file.Logging on to the UNIX machine, I am using the below command

rwrun.sh report=xyz.rdf userid=XXXX/XXX@xxx paramform=no p_orig_org='0825' desformat=pdf destype=printer desname=xxxx batch=yes
This command invokes the printer and
^[%12345X@PJL
@PJL SET RESOLUTION=300
@PJL SET PAGEPROTECT=OFF
@PJL SET ENTER LANGUAGE=PCL
^[%1A^[E^
@PJL RESET
^[%12345X

is what it prints.Realizing that this is because of the missing parameter,tried to change paramform=yes but I am not sure how to pass the parameter.

View 11 Replies View Related

Forms :: Launch Application From Oracle In Unix OS

Jul 1, 2010

my problem is this. I created the java classes using itext to create a document library. Rtf, or. Odt. I integrated classes in Oralce form and everything works. I created a file. Odt application server on a folder and now only remains for me to open the file. The roads are two:

1. Directly from the server, you can?

2. From the client using the API or openoffice launching the executable with cmd?

Oracle Forms is a command to transfer files on the client and run the executable swriter of openoffice?

View 4 Replies View Related

Forms :: FRM-92100 Error In Oracle 10.1.0.4 Under UNIX B.11.11

Jul 30, 2010

We have recently migrated from IAS 9.0 to IAS 10.1.2 in one of our development Server hosted in UNIX B.11.11. We are using Oracle forms as front end. We have re-compiled all the existing forms and libraries using IAS 10. There were no changes in the forms and libraries. We deployed the forms in our development box and configured it, since we are using our own environment specific copy of default.env file. With few of forms we are facing the FRM-92100 error mentioning the "Connection to Server was interrupted". Most of the forms are running fine but with few forms we are facing this error. Some of details are:-

Oracle 10.1.0.4
UNIX B.11.11
IAS 10.1.2

NLS_LANG parameter in default.env is set to "american_america.WE8ISO8859P1"..We have even tried copying the libraries in our local system and then opening and saving them and ftp'ng them back in to UNIX server and then recompiling there with full permissions but still unable to resolve this error.

View 2 Replies View Related

Forms :: How To Read Regedit Using Oracle 6i

Mar 12, 2012

How to read regedit using oracle forms6i ?

View 6 Replies View Related

Forms :: How To Read Registry From Oracle

Feb 4, 2012

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.

View 1 Replies View Related

Forms :: Write Trigger To Insert System Clock Time In Oracle?

Jan 4, 2013

how can i write a trigger to insert the system clock time in the oracle form?

View 15 Replies View Related

Forms :: Could Install Oracle 10g Forms On Windows 7

Feb 28, 2011

Could I install Oracle 10g forms on windows 7?

View 1 Replies View Related

Forms :: ORACLE ERROR Unable To Read List Of Values

Sep 28, 2010

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

View 5 Replies View Related

Forms :: Installed 10g - Not Able To Run Form?

Jan 6, 2011

I 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 Related

Forms :: Passing Value From Unix To Forms

May 9, 2011

is there a way where i can pass the value from unix to forms?

View 1 Replies View Related

SQL & PL/SQL :: Any Parser To Read And Write In Java

Mar 9, 2010

I want to know if there are any freeware's available to read and write .sql files. I hava a .sql file with set of insert statements and I need to identify the values that are pushed into table, the table name, the inner query clauses etc., from the sql statement.

After identifying, need to translate and push those changes back to the .sql file. Is there any way to do this with parsers rather reading the whole of file line by line.

I did come across few parsers like ZQL, sqljep etc

View 3 Replies View Related

PL/SQL :: Read Byte Array And Write It Into File

Sep 19, 2013

I have a web service which gives me the response in Byte array.write this byte array into a binary file? .

View 2 Replies View Related

Windows :: OScanner - Java JRE Installed On Machine

Mar 16, 2011

I have recently downloaded (the zip file for) OScanner (1.0.6) and have Java JRE installed on my machine. However, I am experiencing some difficulty in running the scanner. how I should start to use this tool, once I have downloaded the zip file.

View 8 Replies View Related

Forms :: Installed Forms6i On Windows7 But Ifbld60.exe File Unable To Execute?

Oct 26, 2010

I 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 View Related

Server Administration :: Taking Tablespace Offline / Cannot Read Or Write

Nov 24, 2012

I have created an user named "Raja" with a default tablespace as "Raja_TBS" along with a datafile "rajadata.dbf". I have taken the tablespace offline

SQL> alter tablespace raja_tbs offline;

Tablespace Altered. when I take a tablespace offline, which means I cannot read or write and the tablespace is currently unavailable for users. I am still able to create a table on the "Raja_TBS" while it is offline.

View 39 Replies View Related

Server Administration :: ORA-27070 / Async Read / Write Failed

Jan 6, 2013

i have tried to create the index in diff tbs also but same error is there

SQL> create index inx_tbl_voicechat_unsub_ani on tbl_voicechat_unsub (ani) tablespace ideadb_index;
create index inx_tbl_voicechat_unsub_ani on tbl_voicechat_unsub (ani) tablespace ideadb_index
*
ERROR at line 1:
ORA-01115: IO error reading block from file 201 (block # 144265)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).
ORA-01115: IO error reading block from file 201 (block # 144265)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).

View 10 Replies View Related

Forms :: Reports In Unix Environment

Mar 23, 2010

Below is my code for calling a report from form in windows environment. I want to use the same report to be called from Unix environment . When m using application server tbanner@.... instead of 'repsrv@ahad-pc' is throwing error its in UNIX environment

REP-51002: Bind to Reports Server tbannerdb.kfupm.edu.sa failed

Declare
v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?';
v_connectVARCHAR2 (200) := 'userid=abdulahad/inshalla@test';
v_report_serverVARCHAR2 (30) := 'repsrv@ahad-pc';
v_report_nameVARCHAR2(100) := 'test3.rdf';
[code].......

View 6 Replies View Related

Forms :: Oracle 10g On Windows 7

Oct 28, 2011

I have windows 7 professional edition 32bit and i have tried to run oracle form 10g on chrome and Mozilla browsers they require plugin but don't install, windows ie8 crashes. i searched through internet about this problem some suggested to use jinitiator, i installed it manually and auto both and also paste the "jvm.dll" but the problem is yet to be solved.

View 1 Replies View Related

Forms :: Oracle 10g On Windows XP

Sep 19, 2011

i like a color which is on my desktop, i want that color as my Canvas background color. i press the print screen button on my laptop, open Ms Paint, Paste it there, and pick the color.

Now i want to use the picked up color to be appeared in my oracle forms color palate. how could i do that.

View 2 Replies View Related

Forms :: Alternate For OLE In Unix Application Server

Feb 19, 2011

Am tring to export a data from oracle forms to excel. I use ole2 option. it is working perfectly in my desktop. But when i move the same to our application server, it is not working. I belive OLE is related to Microsoft office and our server is unix based.

View 1 Replies View Related

Forms :: Installing Oracle 10g DS On Windows 7

Sep 20, 2010

I am trying to install Oracle 10g Developer suite on windows 7 but the system gives the following error. (file attached). I have successfully installed Oracle 10g Database.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved