Browse for files through oracle forms placed in unix server


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Browse for files through oracle forms placed in unix server
# 1  
Old 02-18-2010
Browse for files through oracle forms placed in unix server

I use a forms application where I develop the forms(Oracle 6i) in windows server and compile(Oracle 9i) the same in Unix server.
The whole forms application executables are placed in Unix.
My requirement is to upload data from excel sheet to oracle tables using Oracle forms. I have developed the form.
The scenario is when I click on the UPLOAD button in the form it should browse for the file to be uploaded.
With windows application its working but not with the unix application.

I want the same thing for the application in Unix server also. In the Unix application when I click on the UPLOAD button nothing is happening

The code written behind the UPLOAD button is
-----------------------------------------------------------------------
Code:
DECLARE 
   lv_dirname   VARCHAR2(255); 
   lv_filename  VARCHAR2(255); 
BEGIN 
        
   tool_env.getvar('DEMO20', lv_dirname); 
   lv_dirname  := 'c:\'; 
   lv_filename := get_file_name(lv_dirname, NULL, 'ESN List (*.txt)|*.txt|' ); 
   IF lv_filename IS NOT NULL THEN 
      :FILENAME := lv_filename; `
   END IF; 
    
    
END;

-----------------------------------------------------------------------
What changes I have to do for the same thing to happen in forms which is connected to unix server.
I want the equivalent code which does the same for the forms placed in the Unix server
Please help on this issue.

Last edited by pludi; 02-18-2010 at 06:12 AM.. Reason: code tags, please...
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

Help Required to access files in Oracle T4-4 server

Hello, First i'm a newbie, so don't mind if i sound stupid. I am working on Oracle t4-4 server with SUN SOLARIS 5.10 installed. I can access server via serial port and net mgt port. But the problem is when i login to console it starts flooding with messages and i can't type anything. I know... (4 Replies)
Discussion started by: Bilal Maan
4 Replies

2. Programming

How to find Oracle forms that use a column in Solaris ?

I am trying to find all the oracle forms that have text item invoice_id in Solaris ( SunOS 5.10) If I use grep -i -l 'invoice_id' * I get only those oracle forms that have 'invoice_id' in the PL/SQL code. I want to find all the oracle forms that use invoice_id column in their datablocks.... (1 Reply)
Discussion started by: megha2525
1 Replies

3. Shell Programming and Scripting

Find and delete files and folders which are n days older from one unix server to another unix server

Hi All, Let me know how can i find and delete files from one unix server to another unix server which are 'N' days older. Please note that I need to delete files on remote unix server.So, probably i will need to use sftp, but question is how can i identify files and folders which are 'N'... (2 Replies)
Discussion started by: sachinkl
2 Replies

4. Shell Programming and Scripting

script for to take files from FTP server to UNIX server and Unzipped that files

script for to take files from FTP server to UNIX server and Unzipped that files (1 Reply)
Discussion started by: sunilamarnadh
1 Replies

5. UNIX for Dummies Questions & Answers

Connecting to Unix server through Oracle

Hi, I need some help regarding oracle with unix script Actually i have a shell script and i want that it gets triggered through a oracle Db.I dont have any idea how is it done, even whether it is possible....pls help.....!!!! (3 Replies)
Discussion started by: fidelis
3 Replies

6. UNIX for Dummies Questions & Answers

Unix Forms

Hi Im new so be gentle Just starting out in programing and i want to try unix to see what all the fuss is about. But right now im like a kid in a sweet shop, spoilt for choice. Theres red hat, fedora, linux, ubuntu and thats just for starters I've been told ubuntu is a nice... (3 Replies)
Discussion started by: NightWatchman
3 Replies

7. IP Networking

Unix Server Oracle

unix server oracle working with dump nodes. I want to connect to window base system by which i want to transfer the oracle data to window base plateform. Is there any way to connect. (0 Replies)
Discussion started by: shikhar_0509
0 Replies

8. UNIX for Dummies Questions & Answers

2 oracle version in unix application server

Hi, Ive got to 2 Oracle Versions in the application server. Currently running on 8.0.5, and I've recently installed 8.1.7. I would like to ask if it is possible upon restarting the server, to set the default environment to be pointing to 8.1.7 instead of 8.0.5? thnks (1 Reply)
Discussion started by: lucy
1 Replies

9. Solaris

compiling Oracle Forms in UNIX-solaris

I am using the command: f60gen to complie a form and it says it does not work Pls help, as I am trying to compile a few .fmb files to fmx... Cheers (1 Reply)
Discussion started by: etravels
1 Replies
Login or Register to Ask a Question