Forms :: Use Client_get_file_name To Display Select File Dialog Box

Mar 5, 2010

I am trying to use client_get_file_name to display the select file dialog box. My problem is that I can get the dialog box to open but it does not default to the folder that I specify in the client_get_file_name parameter (r_system_data.import_dir points to c:

eports).
v_filename := client_get_file_name(r_system_data.import_dir, null,
'CSV Files (*.csv)|*.csv|',
'Select a file to import travel details from');

The strange thing is when I use JInitiator 1.3.1.22 the diolog box defaults to the c: eports folder but when I use J2SE JRE 1.5.0_21-b01 it defaults to c: emp (which is where 'My Documents' points to, may be just a coincidence)

I am running Windows XP SP3 with IE8.

View 5 Replies


ADVERTISEMENT

Application Express :: Link Local File With Browse File Dialog

Aug 15, 2012

I'm looking for a solution to hyperlink to a local file (i.e. C:/test.txt). I want that the user clicks on a "browse file" button like the file browse item. after the user selected a file or just a folder the path should be shown in a display only item. this item should be clickable...

Is it possible to create a "Browse file" dialog? I know that to link to a file is possible with some HTML tags in the "pre element text" and "post element text" fields. something like "<a href="... but I don't know how this works.

View 2 Replies View Related

Application Express :: Skillbuilders Modal Dialog - Condition For Parent Page Dialog?

Sep 26, 2012

When using this awesome plugin, I have a dynamic action on my calling page that deals with the selection from the dialog.

It uses

Select type:DOM Object
DOM Object: document
Condition: javascript expression
($v('P110_PROD_SEARCH') == 'BLAH')

where the js expression is making sure I run the correct dynamic action, particularly when I have a few buttons on the page invoking different variations of the modal dialog.

My first action is some javascript that interrogates the value of this.data.modalPageCloseValue this facilitates me make decisions in later actions on whether to run some pl/sql, for instance.

potential APEX bug (Display item with HTML affected by dynamic action and since we can't put conditions on actions - I was wondering if I could incorporate something into my dynamic action condition to stop the entire dynamic action from executing if modalPageCloseValue is null - but it seems to be out of scope?

View 4 Replies View Related

Client Tools :: Shortcut To Get Select Connection Dialog Box In SQL Developer?

Jul 8, 2011

Is there a shortcut to get the Select Connection Dialog box in SQL Developer?

Every time I need to execute a Query I have to use the mouse to change the Connection, if there is any Shortcut then that would be easier for me to wotk with.

View 8 Replies View Related

Forms :: Open Dialog Box On From

Feb 19, 2013

i have oracle from 10g installed. i have added webutil libraries.and its has been complied succesfully.now i have a one button on form. on that button triggerd i want open dialog box to select the file.like browse.

for that i have used below command.
webutil.Client_Get_File_Name('C:','file_name.xls','XLS Files (*.xls)|*.xls|',NULL,OPEN_FILE,TRUE);

but it showing me error i.e 'Client_Get_File_Name muse be declare'..

View 1 Replies View Related

Forms :: Builder Debugger Dialog Box Server Name

May 31, 2012

I notified some strange behaviour of my forms debugger. When I insert debug.attach piece of code into ma form and fired them on Windows machine after inserting into Oracle forms builder debugger dialog box server name (usualy ip) and given port from oracle forms window then everything works fine, breakpoint is catched. But when I changed my OS to RedHat then I am not able to come into all kind of trigger form code. Only program units could be debugged.

View 7 Replies View Related

Forms :: Open Dialog Window Using Oracle 10g

Jul 7, 2012

i want to open dialog window using oracle forms 10g on button click event.

View 3 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 :: Prevent User From Navigating To Another Webpage By Displaying Dialog Box

Dec 8, 2010

how to know when a user was navigating away from the current open form (and I wanted to prevent the navigation with a dialog box) because they had entered a new URL in the address bar and were trying to navigate to it? I've seen a reference to it from an ADF perspective -> [URL]

but was wondering how to do it within Forms?

The reason for this is that i would want to prompt the user to confirm that they wanted to exit the form as potentially they would have a record (in the form) flagged as being updated and as such no other user (including themselves) could susbequently access it. So, I'm basically wanting to know if there is a way to catch the fact that the user is about to navigate to another web page.

Is it by using javascript and if so, how would it be implemented?

View 1 Replies View Related

Forms :: Select A File And Load CSV Data Into A Table?

Mar 16, 2010

I am new to oracle designer, forms. The requirement is to select a csv file in a form ,read the file and load selected columns from a csv file into a table.

I am using CLIENT_TEXT_IO. I want to know how to extract the data from selected columns from csv file and insert into a table if the lenth of the columns are of variable length.

Another condition is that if there are duplicate rows based on orderid then take the maximum order seq nbr.Do I need to use
temp table for this logic?

View 1 Replies View Related

Forms :: Create Dialog Box / Upload Image On Image Item

Sep 26, 2010

i want to create a simple form in this form i want to upload the image on the image item with browse button that open a diaglog box that go to the image i select the image and this image is display on image item on the form.

View 1 Replies View Related

Display String Using Select Statement In Oracle 10g

Jul 27, 2010

i want display a string like this using a select statement in oracle 10g.i have tried but not yet done.

example:
-----------
from 'ABCDEFGH' to 'ACEG'
removing 'BDFH' from the source string 'ABCDEFGH'

i giving here the example you can take any valid string i want the result like the above example and also in a dynamic manner means we can give string to a select statement in run time.can it is possible in a select statement only.

View 14 Replies View Related

Windows :: Select Installation Method Does Not Display?

Feb 11, 2013

I have installed oracle 10g in D drive .

The instalation says it is succeessful, without asking the database name or the password .

I have followed the steps given in the attached file .

However it is not asking the databse name or password ( no configuration set up is appearing for the user to interact with the system ) .

So, after installation I can not give the username and password .

The tnsnames.ora file is given below

# tnsnames.ora Network Configuration File: D:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

[Code]....

The files from where I installed is ds_windowx86 disk1 and disk 2.

View 26 Replies View Related

Application Express :: Get Display Value From Select List

Sep 9, 2012

I am using Apex 4.1 and I have a select list in my page. I know i can access the value of the selected item by :P1_SelectList, but I would like to know how to access the display value of the selected item.

View 6 Replies View Related

Fetch Records In Single Select Query And Display

Mar 15, 2011

I have 3 tables, Emp(Emp_id,emp_name),dept(dept_no,dept_name),emp_dept(emp_id,dept_no). Emp tabl ehas some 20 employes id who belongs to different departments.There are few employee who belongs to multiple departments as well. I want to fetch records of emp_id, emp_name, dept_no in the following format.

Name id dept_no
Ram 101 10
20
30
Ani 201 10
20

View 1 Replies View Related

SQL & PL/SQL :: Display Data In Required Format By Select Query?

Dec 12, 2012

i like to display a Table data like the below format,

Output:

EMPNO JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
00094 122 153 145 224 245 545 114 544 444 111 555 222
00095 233 123 145 224 205 545 114 444 444 111 555 222
00096 163 123 145 224 215 545 114 551 444 111 555 222
00097 163 0 145 224 215 545 114 551 444 111 555 222
conditions:

where condition:
where year = 2007

Table Structure:

create table HR_PAYSLIP
(
EMP_NO VARCHAR2(6) not null,
YEAR NUMBER(4) not null,
MONTH NUMBER(2) not null,
BASIC_PAY NUMBER(9,2),
)

Insert Command;

INSERT INTO PAYSLIP (EMP_NO, YEAR,MONTH,BASIC_PAY)
VALUES(00046, 2007, 1, 2314);

Pls Note: The above table data i have mentioned is an example with employee numbers and the basic_pay for all months in the particular year 2007, the employee no may be more and that must be displayed only one time like above for year 2007, and if the basic salary is zero for a month then it should be displayed as zero for a particular month

So how to write a Query for that?

View 9 Replies View Related

PL/SQL :: How To Display Pseudo Static Index Using Select Statement

Jul 20, 2012

I have to display a 24 hours time as an index. (00:00 - 23:00) That is easy, if the data exists.

But, if the data is not regularly exists on specific hour (the time/hours is not regular, i.e: 00:00, 01:00, 05:00, 08:00, 10:00, 11:00, 23:00), then it is OK for a TABLE, but not for a CHART.

Here is the story:

I wrote an SQL statement that can "choose" what to display respectively to the the available time. The result will be displayed on the chart: Days or Time is used for X-Axis, and the respective Value on the Y-Axis.

Example:

+ if the data consists of "days" (i.e: the last 5 days from now, 16/07/2012, 17/07/2012, 18/07/2012, 19/07/2012, 20/07/2012), then the chart will show those dates on the X-Axis.

+ if the data consists of "hours" (i.e: 1 single day, from 00:00 hour - 23:00), then the chart shows hours on the X-Axis.

If the 'hours' are not regular, means: there is no data on specific hours, the query result is also not regular, means: the X-Axis-value 'jumps' irregularly.

Question:

Is it possible to query our own static value?

for example:

select 'hello' from dual --> result: "hello", 1 column, 1 row

But how to display this in multiple rows, i.e.:

Time
*****
0
1
2
3
4
5
...
...
23

Note: the X-Axis on the chart template can be only customized for 1 single mode, example: "Days", but of course it is not going to show up properly if the query result are in "Hours". It means: I have to find the workaround on the SQL Query.

DB: ORA 11

View 9 Replies View Related

Application Express :: Select List Read Only / Or Display Only

Sep 3, 2012

I have Select list itemS based on Lookup tables. When the form in Edit mode, I want to prevent the end user from changing the value of these Select list items. How can I accomplish this ??? **If I change the type of the item to Display only, then it will show the returned value of the Select list.

View 1 Replies View Related

Application Express :: Display Quarter Of Year As Select List

Jul 16, 2012

I need to display quarter of current year in select list.

for example current year is 2012 so, i want Jan-Mar 2012,Apr-Jun 2012,July-Sept 2012,Oct-Dec 2012 in select list.

View 3 Replies View Related

Reports & Discoverer :: Print Dialog Box Doesn't Appear?

Oct 20, 2010

I have designed a report (by oracle report 6) when i run it on the report preview when choosing print the print dialog box doesn't appear on other pc the dialog box appears.

I want the print dialog box to show.

I set the JOBPRINT parameter to yes which is the default value but didn't solve it.

View 2 Replies View Related

Client Tools :: Display Clob Column In Text File In Sqlplus

Mar 30, 2012

I have extracted data from table and write into one text via sqlplus utility in shell scripts. i got correct output. i am having two issues on the output file

1) Outfile file size is huge high compare then table segment data.

2) last column having extra space.

The output column is clob datatype. so i have added set long 50000 and set longchunksize 50000 parameter. after adding these only i got above issues. without two options, i am not getting this isssue but lines are wrapped.

#Set the scripts Path
SCRIPTS_PATH="/usr/local/ccms/gpa/svr/scripts"
echo $SCRIPTS_PATH

[Code]....

View 2 Replies View Related

Application Express Listener :: When Click On Add File It Display A Blank Page?

Nov 10, 2012

My configuration is
APEX 4.2 on Windows XP with APEX Listnere on Glassfish 3.1.2 Open Source Server Edition.
The database is 11G XE

Let me explain the scenario which is not working.A Modal region which is having a file browse item based on WWV_FLOW_FILES and a button called add file.

When I click on add file it display a blank page and in the URL I could see [URL]...But actually it inserted file in the table.

I have put wwv_flow* in Listener Configuration for allowed procedures.I have another page where I have a page item which is based on BLOB column specified in item source attribute. And that is inserting file and displaying the pages correctly.

View 0 Replies View Related

Forms :: Display Multiple Forms At Runtime

Oct 13, 2009

is there a way to keep the display of the form when we call another new form. my scenario will be as following:

am in form1 , i call form 2 from a menu, after this call form2 is open in place of form1.

i have no control in form1 and i can't change anything on it, i don't know hw the menu option is calling form2.the only control i have will be within form2 if there is any change i can make it.i read something about MDI, and OPEN_FORM() procedure, but i think this will required a change in form1 which i can't do.

is there any change i can make in form2 to display it and keep the display of form1 at the same time behind it ?

View 5 Replies View Related

Forms :: How To Display PDFs In Oracle Forms

Mar 19, 2012

I would like to display PDFs in Oracle Forms. The PDFs are stored in an Oracle 10g database.

View 2 Replies View Related

SQL & PL/SQL :: Export Large Number Of Records From Select Into Text File

Feb 9, 2011

I need to export large number of records from select into the text file. It's about 2milion records.I can do it by PLSQL (see below) where executing of process takes time too much. How to export to text file faster?

DECLARE
fileid UTL_FILE.file_type;
BEGIN
fileid := UTL_FILE.fopen ('VRS_CEM', 'cust.txt', 'W');
UTL_FILE.put ( fileid, 'IMSI|MSISDN|CONTRACT');
UTL_FILE.NEW_LINE(fileid);
[code]....

View 8 Replies View Related

JDeveloper, Java & XML :: How To Write Results Of Select Statement Into File

Feb 25, 2011

SQL> desc res;
Name Null? Type
----------------------------------------- -------- ----------------------------
RESULT PUBLIC.XMLTYPE

SQL> select * from res;

RESULT
--------------------------------------------------------------------------------
<fine No="2"><stdNo>2</stdNo><value>300</value><reason>breaks keyboard</reason><
date>2011-10-03</date></fine>

how can me write results of select statement into xml file instead of show them on screen?

View 20 Replies View Related

SQL & PL/SQL :: Generate A Select Query In Runtime And Store Results Of It Into A File?

Aug 15, 2011

I need to generate a select query in runtime and store the results of it into a file.Each time the column name and table name in the query will differ.Now im able to generate the select query through for cursor but problem is to store the results to the file.I tried using plsql table,im able to get the values to that table and store the results to a file,but the results of the query is more then 10000 lines (it might increase also)where only 4000 characters where able to store in the plsql table.so rest of them are not stored in the file.

View 3 Replies View Related

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 :: To Display Specified Image

Jan 14, 2012

I want to display a specified image if not form_success!

declare
image_path varchar2(80) := 'C:R_ORACLEPHOTOS';
photo_name varchar2(80);
begin
:system.message_level := '25';
[code].......

View 1 Replies View Related

Forms :: How To Display Photo

Jun 23, 2010

My form failed to display photo (data type long row).

scenario a)
If photo in black and white with
width : 472 pixels
height: 590 pixels
horizontal resolution : 300dpi
vertical resolution : 300dpi
bit depth : 8
size file : 28KB

scenario b)
If photo in color with
width : 124 pixels
height: 155 pixels
horizontal resolution : 75dpi
vertical resolution : 75dpi
bit depth : 24
size file : 14KB

Above 2 scenario:

My form 6 program can successful display the photo for scenario a , while for scenario b, my form 6 program failed to display the photo.

View 4 Replies View Related







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