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


ADVERTISEMENT

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

PL/SQL :: Spool File Output From Unix To Windows

May 22, 2013

I'm running a sql file in Unix (using SQLPLUS command) and i want the file output to be sent to local windows directory. I specified the windows directory name in my Spool command (Spool C:/<Directory Name> ) , But it is not working

Our Unix server is a FTP server but i don't want to FTP the spool file from unix to Windows as the spool file is Huge and it takes hours for the transfer to complete (and we have to run the script multiple times).

Is there a way i can have the spool file created in Local windows directory when i run my sql script in Unix?

View 5 Replies View Related

PL/SQL :: ORA-29283 Invalid File Operation On Windows System

Jul 31, 2012

Windows 2003, DB 10.2.0.3...I have to read some files from remote folder, so on remote Windows machine I shared folder c:est (grant Everyone first, and Administrator then) and on DB Server I mapped the remote folder with letter T..All these operations were made with administrator privileges.

In Oracle I create a directory object with this command:
CREATE OR REPLACE directory T_DIR AS 'T:';

Then I granted read and write privileges to my user
GRANT READ, WRITE ON DIRECTORY T_DIR TO <user>; (I tried also to set PUBLIC and SYSTEM)

But when I try to open a file with UTL_FILE with this command

file_handler := UTL_FILE.fopen( 'T_DIR', 'Dati.ini', 'r' ) ;

the error is
Exception: ORA-29283: operazione file non valida
ORA-06512: a "SYS.UTL_FILE", line 475
ORA-29283: operazione file non valida

If I change my directory object in 'C: est' (local folder) it works correctly.I tried also restart DB while shared folders were connected but with the same result.I tried, from sqlplus, the command host (dir t:) and it works (folder is accessible)

Is it an Oracle bug? Is it a Windows bug?

View 5 Replies View Related

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 :: 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 :: Unable To Read Excel File?

Nov 1, 2011

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

View 6 Replies View Related

Forms :: Retrieving Images From File System

Sep 15, 2010

I am trying to retrieve images from the file system, but the open dialog box is not popping up for me to choose which file i want. It does nothing gives no error. Just says record 1/1 on the message bar at runtime.

I have two blocks on the module. One is the lobs_table block and the other is the control block. On the control block i have a when-button-pressed trigger on an item. And here is the code below.

Declare
jpg_image_dir VARCHAR2(100) := 'C:UsersajayiaDesktopMe_pics';
photo_filename VARCHAR2(100);
BEGIN
:System.Message_Level := '25';
[code]......

I don't know the code to use to get forms to bring up the open dialog box.

View 1 Replies View Related

Forms :: Read External File Data At A Time Like Bulk Collect Concept?

Jul 23, 2012

I have external file like (.csv or .txt) which contain million of record...i wnat to upload it in backend by using form 6i/10g.

by using package text_io.fopen i read it and by using for..loop conventional method insert record into table...but it will take time..

Is there any way like we use bulk collect and FORALL in backend for inserting data into table..

Is there any way to read external file at a time and insert it ...so minimize inserting time....process will become fast.

View 3 Replies View Related

Client Tools :: Connect Database On Unix And Windows

Jun 24, 2013

How I can connect database on unix OS and windows what is the deference.

View 7 Replies View Related

Forms :: Not Running On Internet Explorer

Apr 6, 2009

I am getting error while running oracle forms (oracle 10g) in internet explorer.

an unhandled win32 exception occurred in iexplorer.exe [7572]

View 6 Replies View Related

Forms :: Oracle 10g Do Not Show Anything In Explorer

Feb 4, 2011

Using Oracle 10g Form Builder, I can connect to the database, compile the form successfully but when I try to run the form by clicking Program/Run form, it opens a webpage(explorer) and displays ?ORACLE FORMS? label, but does not show the form.

After that IE encounters an error and asks me to notify Microsoft Corp. I have noticed that in Start OC4J Instance window 3 new rows:

09/11/04 16:24:42 FormsServlet init():
configFileName: C:DevSuiteHome_2/forms/server/formsweb.cfg
testMode: false

View 8 Replies View Related

Forms :: Calling Internet Explorer Within Form

Oct 4, 2011

is there any way to call internet explorer with in form.i want to provide net fascility to the users using 10g forms.

I have tried some beans but some restrictions are there.it is not properly displaying page.

View 3 Replies View Related

Forms :: Internet Explorer 8 Not Working As Browser For 10g?

Mar 1, 2010

For all my client machine Internet Explorer 8 is not working. Internet Explorer 7 is working fine . For a machine with Internet Explorer 8 after Installing Mozilla Firefox it's working under Mozilla Firefox Browser well.

View 3 Replies View Related

Forms :: Get Current Language From Firefox And / Or Internet Explorer

Feb 25, 2010

I am looking for a possibility to get the current language from Firefox and/or Internet Explorer.

I searched through the Mozilla Developer Center but could not find an interface to realize that. For IE I also didn't find anything.

I know that IE adapts the current system language from the OS, but can I readout this value?

View 1 Replies View Related

Zip A File In Unix Server Using PL/SQL

Oct 12, 2010

I have to pick a text file created in UNIX server directory and send it as an mail attachment.The problem here is, when the file size exceeding more than 10 MB. I think there is a way to zip a file in UNIX with some .gz extension or something like that.

how to zip a file in unix server using PL/SQL code. So that I will pick the zipped file and send it as an attachment.

View 4 Replies View Related

Forms :: Difference Between System.current_item And System.cursor_item?

Apr 1, 2012

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

View 2 Replies View Related

SQL & PL/SQL :: Empty Text File With Data In UNIX

Apr 14, 2010

I have text file with data in UNIX. I want to clear only records(make empty the file) using UTL_FILE..

I know we can remove the text file from UNIX and create file again with same name...

Is there any other way??

View 5 Replies View Related

Forms :: Open Test Form In Oracle 10g Only Internet Explorer Is Opening With Blank Screen?

Apr 26, 2010

I have installer oracle 11i database, with oracle 10g forms for development.When I am trying to open test form in oracle 10g form only Internet explorer is opening with blank screen, while it is connected to oracle database (version 11i).

Oracle 11i is on windows 2003 ent server and Oracle 10g is on windows 2000 professional...

View 2 Replies View Related

SQL & PL/SQL :: Attaching A File Residing On Unix And Emailing It Through Oracle?

Nov 11, 2011

I have a file which is placed on a certain location on unix server. I want to write a code which picks up that file and emails it to certain recipients.

View 3 Replies View Related

Windows :: Oracle 8i On XP System

May 12, 2002

i have installed oracle 8i on my windows xp system. it has not given me any problems during installation. i could log on to oracle and work on it without any problems. but when i restarted my system, my system has failed to start the oracle service, and i could no longer logon to sql * plus.

I've got messages 'oracle not available'. i've even tried to start the service from administrative tools-services, but of no use. then i created a new database and log on to sql* plus. but when i rebooted my system, the problem continued.

View 33 Replies View Related

Unix Command Run Successfully Through PL/SQL But Showing No Impact In UNIX?

May 19, 2007

I am using Oracle 9i and Unix on my system and trying to execute a UNIX shell command through external procedure in C.I created a shared lib (libextproc.so) for the following function.

int sysrun(char *command)
{
return system(command);
}

This function runs fine when caled through a driver function in C, meaning that the shared lib is fine.In PL/SQL, I have used the following method to invoke a UNIX command:-
create or replace library shell_lib as '/home/ECETRAonsite/oracle/OraHome1/lib/libextproc.so';
/
create or replace function sysrun (syscomm in varchar2)
return binary_integer
as language C
name "sysrun"
library shell_lib
parameters(syscomm string);
/

Now when I call this PL/SQL function to invoke the command, it is run succesfully but does not create the file.

SQL>
1 declare
2 rc number;
3 begin
4 rc := sysrun('/bin/touch /home/ECETRAonsite/oracle/OraHome1/test/sach');
5 dbms_output.put_line('Return Code='||rc);
6* end;
SQL> /
Return Code=0

PL/SQL procedure successfully completed.I have verified that the path for 'touch' is correct.Following are my configuration files.
listener.ora
-------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

[code]...

View 1 Replies View Related

Windows :: System Admin Log In Error

Feb 6, 2013

i want to log-in my local machine database as a system administrator , but it is giving an error:

C:Windowssystem32>sqlplus /@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:18:15 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR: ORA-01031: insufficient privileges

Enter user-name:

C:Windowssystem32>sqlplus /@myprodb as sysoper

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:19:28 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR: ORA-01031: insufficient privileges

Enter user-name:

but

C:Windowssystem32>sqlplus sys@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:20:45 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter 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

SQL>

and i have run cmd as administrator

View 20 Replies View Related

Windows :: System Integration CONSULTANT?

Jul 27, 2011

I need information to recommend something to the Client:Existing Application Environment is:

OS: Windows XP Server as well as Client
Database: Oracle 9i Server on XP
Oracle Client : Oracle 9i

They want to move to Windows 7 in ClientWhat all they need to upgrade if required...?Does Oracle 9i Client can be installed on windows 7 clientDoes Oracle 10g Client is required in the above mentioned case.

View 1 Replies View Related

Forms :: Oracle 11g Windows 64bit / File Extraction Password

Nov 27, 2012

I downloaded Oracle Fusion Middleware11g Forms and Reports (ofm_frmrpts_win_11.1.2.0.0_64_disk1_1of1). When I begin to extract I am getting bogged down with a password message and that is:

File Windows-amd64 is password protected. please enter the password in the box below.

BTW- I downloaded Windows64 based forms and reports on my windows xp pro machine. I am trying to unzip them and burn it on a DVD so that I can install them on my new dell windows 7 professional laptop.

View 7 Replies View Related

Oracle 11g R2 On Windows 2008 R2 - Cannot Login As SYSTEM

May 31, 2013

I created an empty database using the DB Configuration Assistant, then imported a dump file provided by a client. I believe what happened is that all of the user passwords (for SYSTEM, SYSDBA, etc.) which I had created in the DB Config Assistant were overwritten during the import process as I can no longer log into the DB.

I have attempted logging into sqlplus using the /as sysdba swith while logged in to the server as a user in the ORA_DBA role, but I still get the ORA-01031: insufficient privileges message.

I am running Oracle 11g R2 on Windows 2008 R2.

View 4 Replies View Related

Windows :: Installation Process Trying To Create Database On System

Dec 7, 2010

I'm trying to install Oracle10g in win7 Home premium. It is installing but problem is when installation process trying to create database on the system, a message is appearing which telling that ORA-12546:TNS:permission denied.

View 1 Replies View Related

Clusterware :: Oracle Installation On Windows Operating System?

Jun 14, 2012

install oracle clusterware on Windows Operating system

View 4 Replies View Related

Windows :: Install Oracle 10g Release2 In 32bit Server System?

Aug 2, 2010

I need to install oracle 10g release2 in 32bit windows server system.

I also need to replicate whole database at more than 10 locations...i m just confused which windows server system should i install the database?

View 2 Replies View Related







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