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
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
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
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
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
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
Mar 8, 2011
i want to run sql file by forms...is there command do that
View 3 Replies
View Related
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
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
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
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
Aug 15, 2012
Can i play .gsm sound file in FORMS6i / 10g ?
View 3 Replies
View Related
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
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
Apr 4, 2013
how can i open the .fmx file in oracle 10g?
View 12 Replies
View Related
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
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
Nov 1, 2007
how to call batch file from Oracle froms 10g
View 18 Replies
View Related
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
Nov 6, 2013
Do you have sample codes to upload file from client to server using 11g forms?
View 2 Replies
View Related
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
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
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
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
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
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
Mar 1, 2010
I need get access a property (time of last modification) file winword.
View 3 Replies
View Related
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
Mar 15, 2011
I need the code to export the data from the form to the excel directly.
View 1 Replies
View Related
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