Oracle Forms Questions


Debugging Oracle Form in 10g
      Hi , I am currently working in form 10g and i m newbie to that technology…        I want to debug my form and also check step step by values of variables which i defined.. Can u plese help me out to solve my problem…if any document available to step by step debugging… Thanks

Answer Question   |  September 29, 2010  4:52 AM
Debugging, Oracle Form Builder, Oracle Forms, Oracle Forms 10g
asked by:
30 pts.

How to connect Oracle 8i and Oracle forms
In the Laptop how to connect oracle 8i and forms and reports. Pls explain the procedures to follow

Answer Question   |  September 21, 2010  7:16 AM
Oracle, Oracle 8i, Oracle 8i Installation, Oracle DBA, Oracle Forms, Windows XP
asked by:
15 pts.

Webpage calling from Oracle Forms 6i
I need to call a specific webpage from my forms 6i using a button please help

Answer Question   |  September 7, 2010  5:45 PM
Oracle developers, Oracle development, Oracle Forms, Oracle Forms 6i
asked by:
5 pts.

I want to connect Oracle Forms 10g with Oracle 10g application server database
I want to connect Oracle Forms 10g with Oracle 10g application server database.how can i do that??

Answer Question   |  March 29, 2011  7:16 AM
Oracle 10g, Oracle Application Server, Oracle Forms, Oracle Forms 10g
asked by:
5 pts.

How to call report 6i from forms6i defining the username/password
I am using forms6i and Report6i, Now I am trying to connect to another user to run the report. How to call report 6i from forms6i defining the username/password

Answer Question   |  January 24, 2011  10:10 AM
Oracle, Oracle Forms, Oracle Forms 6i, Oracle Reports, Oracle Reports 6i, Oracle User Profiles
asked by:
5 pts.

How to connect oracle database 8i (personal edition) with d2000 (forms 4.5 & reports 2.5)?
In the laptop how to connect oracle database 8i (personal edition) with d2k (forms 4.5 & reports 2.5) Pls tell me procedure for this connect with database?    

Answer Question   |  August 25, 2010  6:21 AM
Oracle, Oracle 8i, Oracle 8i error messages, Oracle connection error, Oracle connectivity, Oracle Database, Oracle Forms, Windows XP
asked by:
15 pts.

Not able to connect to database through Oracle form builder
Iam not able to connect to database through form builder.How to add an entry for your XE database in your tnsnames.ora file?

Answer Question   |  August 17, 2010  11:21 AM
Oracle connectivity, Oracle Database, Oracle Form Builder, Oracle Forms
asked by:
5 pts.

Temp table with months in Oracle
how to create temporary table which contains all the months from january to december

Answer Question   |  August 11, 2010  4:31 AM
Oracle, Oracle Forms, Oracle Table, Oracle Tables
asked by:
50 pts.

How to display non existent data as 0 in Oracle
in my table there refno,purchase,sale,acc_type are four columns.i have to sum(b) and sum(c). for a perticular date.but the query should show 0 for clumn b & c where there no value has been entered.suppose purchase,sale, are summing per month.but in some month there is no entry for a,b,c,d.so how to show them for that month [...]

Answer Question   |  August 11, 2010  3:37 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table
asked by:
50 pts.

Connecting and disconnecting Oracle sessions through Oracle forms
How to  connect and disconnect oracle sessions through oracle forms?(suppose I need to validate user whose corrently loged on.)   email to :anandan.muthukannan@tcs.com

Answer Question   |  August 10, 2010  1:31 PM
Oracle, Oracle administration, Oracle authentication, Oracle connectivity, Oracle Forms, Oracle User Profiles
5 pts.

ordering dates in Oracle
how to order the months and year in descending order from a table?suppose there are 2 culomns one contains month and another contains year.then how to show them in an order like jan-2001,feb-2001,mar-2001………like this. plz suggest some answer for this.

Answer Question   |  August 9, 2010  3:49 AM
Oracle, Oracle Database, Oracle Forms, Oracle Table
asked by:
50 pts.

How to create MDI FORM in d2k?
How to create MDI FORM in d2k

Answer Question   |  July 26, 2010  7:08 AM
D2K, D2K Forms, MDI, Oracle Forms, Windows XP
asked by:
15 pts.

Oracle Forms 10g code
how to show all empid in list item in oracle form during the runtime… pl give me details with code. table structure is    create table dept( empid int,ename varchar2(20)); gv me full code of the  under the form_instance_click………                             

Answer Question   |  June 22, 2010  6:30 PM
Oracle 10g, Oracle Forms, Oracle Table
asked by:
10 pts.

ERROR MSG DURING ORACLE FORMS INSTALLATION
ERROR IS USER1.PIN(20) OS_ERROR WHILE SPAWNING…IFSRV60 -INSTALL FORMS60SERVER-DEFAULT…PORT=900 MODE=socket batch+yes  

Answer Question   |  June 14, 2010  1:24 PM
Oracle error messages, Oracle Forms, Windows Server 2003
asked by:
5 pts.

how to reference one Oracle 6i rpt param value from another param?
I am trying to validate that two report parm dates are nomore than 2 years apart, how can I reference the from date while validating the to_date

Answer Question   |  June 3, 2010  4:07 PM
Oracle 6i, Oracle Forms, Oracle Query, parameter values
asked by:
5 pts.

program too large ( D2K form builder)
i have written some code in D2K 6i form builder, in a button trigger name is ” WHEN_BUTTON_PRESSED”. While compiling I am getting an error program too large. plz answer.

Answer Question   |  February 1, 2011  5:30 AM
D2K, D2K 6i, D2K Forms, Oracle 6i, Oracle Forms, Oracle Forms Error Messages
asked by:
55 pts.

Oracle Forms and Reports
I would like to know whether is there any web site which offers free practice exercises on Oracle Forms and Reports?

Answer Question   |  July 13, 2010  7:36 AM
Oracle, Oracle 10g, Oracle Forms
asked by:
5 pts.

oracle forms 6i
i need to know the coding for NEXT BUTTON in oracle forms 6i,when the fields are not database items…. i want to fetch next record after pressing NEXT BUTTON…i have applied select query and tried to store the fetched records in fields of the form….but in vain…i got no output in the screen…jst the empty [...]

Answer Question   |  April 30, 2010  11:07 AM
Oracle 6i, Oracle administration, Oracle Forms, Oracle Forms 6i
asked by:
5 pts.

Oracle Forms 10g – Form sometimes retrieves data, sometimes retrieves nothing with same query
I have run into a problem with 2 Oracle forms I have “adopted”.  When a user hits the next block button to execute the query based on their criteria, the forms will sometimes return data and sometimes will clear out every text field on the screen (it isn’t deleting or removing the text elements… just [...]

Answer Question   |  April 27, 2010  1:50 PM
Oracle Forms, Oracle Forms 10g, Oracle Forms Error Messages
asked by:
15 pts.

Browser still Open oracle forms 10g
we’re using Oracle forms 10g, after exiting from the Application the browser stilll open, is there a code or built in function that will close the browser?

Answer Question   |  May 6, 2010  1:20 PM
Oracle Forms, Oracle Forms 10g, Oracle Forms Error Messages, Oracle Reports 10g
asked by:
10 pts.