Forms :: Make Excel Dump For Some Banking Application Using 6i?

Jun 17, 2010

I am trying to make an excel dump for some banking application using Forms 6i . I am making use of OLE to make an excel dump. I have a small problem while using this OLE concept . I have an Account column which is is having the data type VARCHAR2 at database level . when i try to make a excel dump of this column , then the values in the account number column in excel is getting converted into number column . Eg: A/c - 000123 is appearing as 123 in excel. How this can be retained as 000123 in excel sheet .

test case -

actual value appearing value in excel
000123 123

code extract in hv used -

args := ole2.create_arglist;
ole2.add_arg(args, rowcount);
ole2.add_arg(args, colcount);
cell := ole2.get_obj_property(worksheet, 'Cells', args);
ole2.destroy_arglist(args);
ole2.set_property(cell, 'Value', rec1.BANKNR);
ole2.release_obj(cell);

View 1 Replies


ADVERTISEMENT

Forms :: How To Make Oracle Application Always On Top

Feb 13, 2010

I want to make oracle application "always active" or "always on top" automatically when windows logon as feature provided in task manager.

View 2 Replies View Related

Client Tools :: Not Able To Make ORA Connection Through Macro In Excel

Mar 15, 2012

i have windows 7 on machine. When i am trying to connect to oracle client using macros from excel like

OraSession = CreateObject("OracleInProcServer.XOraSession")

its giving me error saying "activex component cant create the object."

View 3 Replies View Related

Forms :: Open New Excel Application From 10g?

May 6, 2008

How can i open a new Excel application from Forms 10g?

View 2 Replies View Related

Application Express :: 4.2 - Make URL Shorter?

Mar 22, 2013

I am using apex 4.2, mod_plsql

the url of application is very long, is there any way to make it short

View 4 Replies View Related

Application Express :: How To Make A Multiline Label

Jul 19, 2012

how to makea multiline label. I have couple of text fields and would like to have the label divided in two lines for each of them. I tried with new line character etc. however didn't succeed.

View 2 Replies View Related

Application Express :: How To Make Error Message Red

May 20, 2013

A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,

I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?

View 2 Replies View Related

Application Express :: How To Make Use Of Error Template Control

Oct 2, 2012

I actually have tried to read the Customizing Templates chapter of the Users Guide. According to that guide, the following substitution strings are supported in the the Error Template Control section of page templates.

#MESSAGE# and #ADDITIONAL_INFO# - Places the error message.
#TECHNICAL_INFO# - Displays detailed internal error information which will just be visible for developers.
#BACK_LINK# - Displays a link back to the previous page.
#OK# and #RETURN_TO_APPLICATION# - Returns to translated text strings.

However, if I enter the follow code

<p> message:     #MESSAGE# </p>
<p> additional info:   #ADDITIONAL_INFO# </p>
<p> techie stuff:     #TECHNICAL_INFO# </p>
<p> back link:     #BACK_LINK# </p>
[code]........

return to application: Return to application.

It appears that only the first substitution string is doing anything. I'm especially interested in additional info and technical info. The back_link just looks like an html snippet, not sure why I would use a substitution string for this. I imagine the last two could facilitate site translation, but that doesn't work much if there is no machinery for translating error messages themselves.

View 5 Replies View Related

Application Express :: How To Make Default Attachment As CSV File Instead Of HTM

Oct 28, 2012

I am having an interactive report with an email subscription.

My question is, how can I make the default attachment as a .csv file instead of the .htm file?

View 2 Replies View Related

Application Express :: How To make Item Mandatory Dynamically

Oct 24, 2013

How to  make an item as a  mandatory field dynamically with the change of another item in different regions

View 10 Replies View Related

Application Express :: Make Fields On Form-page More Accurate?

Oct 18, 2012

How to make fields on form-page more accurate? I want make fields one under another one, and control the distance between them.

View 3 Replies View Related

Application Express :: Where To Make Changes To Calendar Height / Width And Misc

Nov 13, 2013

Apex 4.2I have a page with a calendar on it. I have several issues with formatting the data within each cell. Currently, I use a substitution string to place the id in the calendar cell.

Clicking the id will link to another page. What I notice is that for each id on a calendar cell (or date), it lists them one under the other. Is there any way to list them side by side? Also, I need to make changes to the calendar cells. I would like to expand the width and the height, but am not sure where to do this.

View 1 Replies View Related

Application Express :: How To Make Use Of SSO Login Credentials Of Oracle In Authentication Schema

Jul 16, 2013

I am using SSO login for Authorizations. Would like make use of SSO for creating authentication schema. My main requirement is to assign privilege based on users using SSO loging.

View 0 Replies View Related

Application Express :: How To Make Report Column Non-editable In Master-detail Form

Jun 20, 2013

I have created a master-detail form. The detail columns are created as report columns instead of getting created as Items. I need to make a column non-editable.

View 1 Replies View Related

Application Express :: Store Encrypted Numeric Value And Make Unencrypted Value Visible To Just Some Users In Apex

Jul 3, 2013

I'm looking for a way to store an encypted numeric value in one field in a table (so that it appears encrypted even to a DBA) and to display the unencypted value in Apex forms and interactive reports for some users but not others.

View 4 Replies View Related

Forms :: How To Make A Calendar

Mar 4, 2003

I have read the messages below about making a calendar but am still unsure of how to go about doing this. I have the STNDRD20.OLB file, but I don't know where to put it or what to do with it! What comes next?

View 20 Replies View Related

Forms :: How To Make A Node

Feb 27, 2012

How to make a node of a Hierarchical Tree BOLD without intervene java code ?

View 1 Replies View Related

Forms :: Make Calendar In Oracle 10g

Sep 15, 2011

I want to make calendar in oracle form 10g, but i don't know make it. How to do make calendar?

View 2 Replies View Related

Forms :: Make Field Non Editable

Jul 29, 2010

I have a field on the form which is a database field and the value is populated by a LOV. The user should not be able to edit the value selected or enter his own values in the field. Basically the field should only be populated by the lov and should not be editable.

I tried using the SET_ITEM_PROPERTY('XX.XX', UPDATE_ALLOWED, PROPERTY_FALSE); but this only disable update against existing value. If a user selects a new value from LOV that can be edited.

View 8 Replies View Related

Forms :: Make Cursor At The Item

Jan 25, 2013

I have a button "clear" , I want when the button is clicked the items will be cleared and the cursor is at the first item, here is the

:emp.id:=null;
:emp.ename:=null;
:emp.sal:=null;
go_item('emp.id');

=>but the problem that the item changes color, but the cursor remains at the button "clear"

NOTE:
I used the "when-new-item-instance" trigger to change the color of text items

View 3 Replies View Related

Forms :: Make One Form For Many Systems

Mar 4, 2013

make one form for many systems i have (i.e) I need to make it like portal many button for many systems When i enter the button i login to specified system (i.e) I need to make new connection to this schema and disconnect the previous one.

View 1 Replies View Related

Forms :: How To Make Calculator In Oracle 6i Or 10g

Jul 22, 2013

Is it possible to design calculator in oracle forms 6i or 10g?

View 2 Replies View Related

Forms :: How To Make Block Query

Jan 30, 2012

I have one form, when i press f7 , it says the "The function has no meaning in this context" , how to make it query enabled block.Actually i am going to that block using when button pressed and execute_query.

View 12 Replies View Related

Application Express :: Upload From Excel For Several Tables

Jan 7, 2013

Pretty new to APEX and was hoping to accomplish with native functionality.

Using the latest APEX, there is nice functionality that creates a wizard for you for a single table. I wanted to have a single wizard but pick a table then have the ability to map my fields for insert/update.

View 2 Replies View Related

Forms :: How To Make Browse Image In Oracle 10g

Apr 17, 2011

how to make browse image in oracle form 10g?

View 1 Replies View Related

Forms :: Make Field Protected Against Update?

Apr 29, 2011

What i am required to do is to protect a field 'COUR_CODE' from update when the SHIP_METHOD='R'. c

if :system.record_status = 'INSERT' then
declare
vcour_code ACCOUNTS.cour_code%type := NULL;
vcourier_account_no ACCOUNTS.courier_account_no%type := NULL;
canvas_name varchar2(30);
begin

[code]....

View 11 Replies View Related

Forms :: How To Make Query Mode Work (f11)

Apr 2, 2012

I have created a custom form. I have field called Order No. When i query on Order no.. i should be able to pick order no as well as other fields related to it. how do i acheive this functionality. I mean the f11 and ctrl f11 querying functionality.

View 18 Replies View Related

Forms :: How To Make Demand Wise Report

Jul 3, 2013

I have a payment table that has the ids of cds that has being sold in the past month. From there I want to make a demand wise report. I am aware of the report wizard in the oracle forms but I dont want to use it. Here are the tables in a bit more details.

payment: id_cd, price, dateofsell
cd_details: id_cd, name, price, language.

View 6 Replies View Related

Forms :: Export Forms Data Into Excel Sheet - Client-ole2 Not Working?

May 28, 2010

I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet

View 7 Replies View Related

Forms :: Map Excel Columns On Oracle Forms And Insert It Into Database

Apr 12, 2013

I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.

So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.

-more details

I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.

COL1 --> list value of database column
COL2 -->list value of database column
COL3 -->list value of database column

Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.

View 1 Replies View Related







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