Forms :: Reg CSV File

Mar 30, 2011

The form which i developed is for Multiple user. i.e many no of user upload the same csv file at the same time. To differentiate it 4r the user i gave the user name in Prefix. say the users name are xx and yy and the file name is test.csv. In the kentucky server it is loaded as "xx_test.csv" and "yy_test.csv". It loaded along with Double quotes.I used the varible to get loaded

l_bare_filename := '"'||v_username||'_'||substr(:FIC_SOURCE,instr(:FIC_SOURCE,'',-1)+1)||'"';

l_bare_filename is that variable.

When i tried to null the csv file it is not created as Double quotes in Kentucky server. say it is displaying xx_test.csv file. Below is the command for making null. I used the same variable

host('cat /dev/null > /tmp/'||l_bare_filename )

I want it to be displayed with Double quotes.

View 1 Replies


ADVERTISEMENT

Forms :: Getting Error When Cancel File Selection In File Open Dialogue

Mar 18, 2010

I have created the below stored procedure and calling the procedure in when-button-pressed trigger. Problem here is that when I cancel the file selection in file open dialogue box its raising exception.

PROCEDURE TEST
IS
buffer_lines client_text_io.file_type;
v_outputstr VARCHAR2 (32767);
p_delimiter VARCHAR2 (10) := '","';
v_transaction_no VARCHAR2 (10);
BEGIN
[code].......

View 3 Replies View Related

Forms :: Export Text File With Same File As Imported Text File?

May 30, 2011

Is it possible to get the same name of file name from imported text file?

What i've is, I import the text file then I exported it.

can I get the same name of the imported text file?

View 2 Replies View Related

Forms :: Oracle Forms Output Embedded In HTML File?

Jun 15, 2012

i'm using db and forms 10g. i want the output of the form to be embedded within a simple html page. lets say i want the html page to be divided into three frames. the uppermost horizontal frame will hold a banner (say). the left vertical frame will hold some advertisement (say).

(1) now the rest of the page will be covered by the third frame in which the fmx's will run.

(2) i want the login.fmx (startup form) to show up first instead of the servlet. infact the servlet should not show up at all.

View 1 Replies View Related

Forms :: Export Text File From Oracle Forms

Oct 9, 2010

Exporting text data from a table. Suppose I have a table of employees.

In oracle Forms. I make the two column of Hire_date1 and Hire_date2. When I put the Date Into Hire_date1 and Hire_date2 , And press push button. All the data save in text file C: emp folder.

View 4 Replies View Related

Forms :: D2k 6i And Excel File?

Jun 23, 2010

I have generate a excel file through oracle developer 2000 6iwith password protect using OLE2 but autofilter,sort and format column options are not working.

PROCEDURE UnProtectCell(r NUMBER,c NUMBER) IS
BEGIN
args:= ole2.create_arglist;
ole2.add_arg(args, NumToRange(r, c));
XLRange:= ole2.get_obj_property worksheet, 'Range', args); ole2.destroy_arglist(args);

[code]...

View 6 Replies View Related

Forms :: Command To Run SQL File?

Mar 8, 2011

i want to run sql file by forms...is there command do that

View 3 Replies View Related

Forms :: Upload File In Ebs 11i?

Oct 8, 2013

oracle forms 6i
oracle ebs 11.5.10
database 9i

i create new custom application in my ebs 11i and i want to upload file in our custom application and save it as file system in my server lunix

how i attach my file and i want to save it not as blob but just upload to my server and after download it?

View 2 Replies View Related

Forms :: Change FMX File In Use

Jun 14, 2012

I'm in an environment with Weblogic Oracle Forms 11G (Oracle Fusion Middleware). I can not update a form that is in use. I can not change the fmx file.

Can I change this? Where can I configure this?

View 4 Replies View Related

Forms :: Upload PDF File To Server

Jan 23, 2013

I'm using oracle 10g and Forms 9i . I need to upload a PDF file from client to server no to database, just like File, is there any way to get it, no webutil using.

View 1 Replies View Related

Forms :: Download File From DB Server?

Jan 31, 2011

i have aprocess that generates a textfile using utl_file but i need that file in the client pc.

is there a native method like as_to_client that i could use to copy this file in any client machine without the need of install an extra software in client pc

View 1 Replies View Related

Forms :: Can Play GSM Sound File In 6i / 10g

Aug 15, 2012

Can i play .gsm sound file in FORMS6i / 10g ?

View 3 Replies View Related

Forms :: How To Generate Excel File

Jun 12, 2012

I want to gerate the excel(Office 2010)file using oracle forms 6i. How we can achieve this with forms 6i?

View 4 Replies View Related

Forms :: How To Open PDF File In Oracle 10g

Nov 25, 2010

i am trying to open a .pdf file in oracle forms 10g which had stored in oracle 9i.10g database.

so which method shall i use to do this?

View 1 Replies View Related

Forms :: Open FMX File In Oracle 10g?

Apr 4, 2013

how can i open the .fmx file in oracle 10g?

View 12 Replies View Related

Forms :: Editing Base.htm File?

May 4, 2010

can I add a session (php code) to base.htm file?

if yes, what i have to do?

View 1 Replies View Related

Forms :: How To Get BLOB File Extension

Jun 25, 2010

There are different types of files loaded in database BLOB type column, .doc, .xls, .pdf or even .xlsx and .docx. Now, I need to download these file and open it. The problem is how can I determine what file extension these files have.

View 7 Replies View Related

Forms :: How To Call Bat File From Oracle

Nov 1, 2007

how to call batch file from Oracle froms 10g

View 18 Replies View Related

Forms :: Display PDF BLOB File

Apr 8, 2011

I just want to know if is it possible to display PDF blob file within the forms. Currently I use webutil to open pdf in browser. This time I need to display it in forms, so that upon scrolling, the user can view the pdf images of that particular record.

View 1 Replies View Related

Forms :: Upload File Using Oracle 11g

Nov 6, 2013

Do you have sample codes to upload file from client to server using 11g forms?

View 2 Replies View Related

Forms :: Burning A File To CD From Oracle 9i

Aug 23, 2010

I am working in Oracle Forms 9i, and I have a requirement to copy or burn a file from hard-disk to CD. This should be automatically done at the press of a button in Oracle Forms.

I have already tried using the following statement:

out_Item := TEXT_IO.FOPEN('F:file3.csv', 'w');

where F: drive represents the CD drive. It threw an ORA-302000 error. How we can achieve burning a file from hard-disk to CD through Oracle Forms.

View 6 Replies View Related

Forms :: Error In CSV File Generation?

Apr 12, 2010

Im generating a csv file using TEXT_IO Utility.The file generated contains one blank line at the last record.Say there is 10 records. Open the generated csv file in notepad and move the cursor down. After 10 records, the cursor will move down one more time.

How to avoid that blank line as im using cursor in my script. The script is attached below.

Version:
Oracle 9i Database
Oracle Forms 6i

View 2 Replies View Related

Forms :: How To Store PDF File In Database

Dec 18, 2010

I want to store pdf file in table using forms 6i. Then i want to open and view it in Acrobat Reader. using Forms 6i only.

View 1 Replies View Related

Forms :: File Transfer Through Pl/sql Programming?

Jun 15, 2011

I am facing a issue with one of my programming application. We need to transfer a file through pl/sql programming from a unix server to another destination(target) server.

How can we do it through pl/sql programming. I learnt that oracle streams can be used for this.

I do not know what all code is required for this. send me the code for a sample text file.

I also want to encrypt with a password and zip the file

View 3 Replies View Related

Forms :: FRM-10043 Cannot Open A File

Jul 11, 2011

When I am trying to open a PLL[5i] through Form5i Builder , Getting Error message like "FRM-10043 Cannot open a File".

View 1 Replies View Related

Forms :: Run Batch File Through Form?

Jan 12, 2012

I create a form with button....whenever i click button my batch file should be run..

My batch file code :

@ECHO OFF
cd
ipconfig /all
pause

When-button-pressed trigger :

======================================
client_host('D: est_ipa.bat');

When i double click .bat file, it will get proper info.But when i call this .bat file thru form, it will show blank screen..why this .bat file not running ?

View 2 Replies View Related

Forms :: How To Get Date And Time Of File Modification

Mar 1, 2010

I need get access a property (time of last modification) file winword.

View 3 Replies View Related

Forms :: Import Text File In Oracle 9i

May 3, 2011

I want to import text from text file. How i can import in oracle forms ( oracle 9i)

View 7 Replies View Related

Forms :: How To Export Data In 10g To Excel File

Mar 15, 2011

I need the code to export the data from the form to the excel directly.

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







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