Oracle 6i Questions


My Oracle forms 6i Form is exiting automatically
Dear friends, My problem is…after compiling, my Oracle Forms 6i form is exiting automatically. How can I solve this problem?

Answer Question   |  April 1, 2013  11:41 PM
Oracle 6i, Oracle Forms
asked by:
30 pts.

Clear button
Hi friends, I had created one form contains 2 table details(emp,dept), I saw the details from 2 table by entering empno but I want to clear those text fields.

Answer Question   |  March 19, 2013  1:05 PM
Oracle 6i, Oracle Forms
asked by:
5 pts.

Date field validation
Hi friends, I need a help from your side…I have developed one form in Oracle 6i. The problem is Date fields date format should take automatically (example 12jan2013 it has to take 12-jan-2013 automatically). Could you please tell me how to do it?

Answer Question   |  February 4, 2013  2:11 AM
Oracle 6i, Oracle Forms
asked by:
5 pts.

IMPORT OR EXCEL DATA INTO ORACLE FORMS 6I
Hi all, i have to import excel data of two column into oralce forms 6 i on button pressed trigger. can any one help me in this regard with source code. thanks a lot in advance

Answer Question   |  October 30, 2012  9:55 AM
EXCEL DATA, Import, Oracle 6i
asked by:
5 pts.

Populate List Item in Oracle
I would like to populate list item, plz help me.

Answer Question   |  February 28, 2012  4:44 PM
Oracle 6i, Oracle 6i import/export
asked by:
5 pts.

Oracle
Dear sir I am in problem , please help me How to change the direction of the report automatically by the code and not through the design phase in oracle 6i

Answer Question   |  February 28, 2012  7:17 PM
Oracle 6i, Oracle 6i Reports Builder
asked by:
40 pts.

oracle 6i form foreground color problem.
Dear sir,           i am omprakash, working as ERP(oracle form 6i) programmer for simplex engg. foundry work ltd. bhilai. I have some problem , i would like to resolve it by you.plz help me…. 1) I am working on hr module , i have made student attendance form, where attendance is enter and marked default [...]

Answer Question   |  March 31, 2012  7:19 AM
Oracle 6i, Oracle Forms, Oracle Forms 6i, Oracle Reports
asked by:
Om1
5 pts.

Oracle 6i parameter value
HI, Friends this is Nayeem, I need a help from your side. i have a report in oracle 6i, the problem is i have three parameter of date like WHERE ((MANT_REQ.REQ_DATE between R1 and R2)and (MANT_REQ.MANT_REQ_NO=: MAINE_REQUEST)) in this i have list of values for all three parameter my problem is when i m selecting the [...]

Answer Question   |  May 31, 2011  5:54 AM
D2K, D2K 6i, D2K Forms, Oracle 6i, Oracle Forms 6i
asked by:
20 pts.

ORA106500:WHEN-BUTTON-PRESSED raised unhandled exception. … i want to open ms word file when button pressed trigger
Dear All i am using oracle 6i and oracle 9i database i want to open word file when pressed button in form but there is no error during compilation error at runtime showing below code wrote in WNBP trigger: declare AppID PLS_INTEGER; begin AppID := DDE.App_Begin(‘C:ProgramDataMicrosoftwindowsstart menuprogramsWINWORD.exe C:orantBINifbld60.EXEsupppe_pre2.fmb ‘,DDE.APP_MODE_NORMAL); end; plz if anyone help me

Answer Question   |  August 2, 2011  5:57 AM
Oracle 6i, Oracle 9i, Oracle developers, Windows 7
asked by:
45 pts.

Can’t export Oracle 6i report to txt file
When i generate to txt file from some 6i report , the result txt file has no data Although main report desplay data . Pls, advice me to solve this problem 

Answer Question   |  February 23, 2011  1:25 PM
Oracle 6i, Oracle 6i import/export, Oracle Reports, Oracle Reports 6i blank reports
asked by:
55 pts.

Oracle Reports 6i tables
Hi All, I am working in Oracle 6i reports, I want to hide some report columns value at runtime. For example if dataentry operatior run a invoice report the value columns are print like ‘**********’ otherwise it will print original value. The users are controlled in a seprate table. Using that table I want to [...]

Answer Question   |  September 29, 2010  11:50 AM
Oracle 6i, Oracle Reports, Oracle Reports 6i, Oracle Tables
asked by:
5 pts.

we are using a oracle D2k 6i based software and by mistake some one has changed a .fmx patch to open with notepad. Can I recover the files affected?
we are using a oracle D2k 6i based software and by mistake some one has changed a .fmx patch to open with notepad and now all the files with such extension has been changed. so please tell me how to recover the file.

Answer Question   |  July 2, 2010  8:10 AM
D2K 6i, File recovery, FMX, Oracle 6i, Patch management
asked by:
10 pts.

Getting the error unable to perform query ora 00904 on an item of previous form which is already deleted.
using oracle 6i i save as a form to make another one and deleted all the items,triggers and other programme units,lovs from it. I added new items and new data source to its block. But its giving the error unable to perform query ora 00904 on an item of previous form which is already deleted. [...]

Answer Question   |  July 1, 2010  11:58 AM
ORA-00904, Oracle 6i, Oracle Error Codes, Oracle Forms 6i, Oracle Query
asked by:
10 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.

underscore is replaces with space oracle reports 6i
I have a problem. I am setting value of a varchar2 variable and including an underscore in taht string value. but when I print it, this underscore is replaced with a space character. What can I do in this situation. plz help me out.

Answer Question   |  May 11, 2010  8:08 PM
Oracle 6i, Oracle Reports, Oracle Reports 6i
asked by:
5 pts.

oracle forms 6i
i want to know the coding for button which is named as’next’…i want to fetch next records every time i press this button in my form… but my coding is not woking properly…i dont get any error…but i dont even get any output too…as the fields in output screen(form) remains empty…but yes in the screen [...]

Answer Question   |  May 10, 2010  5:23 AM
D2K 6i, Oracle 6i, Oracle Developer 2000
asked by:
75 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.

drop down list Oracle 6i
i a creating a login page i which user have to select that he want to log in as admin or as user i want user select from drop down list so plz guide me how drop down list is formed in orcle 6i from builder

Answer Question   |  April 20, 2010  5:39 AM
Oracle 6i, Oracle 6i Reports Builder, Oracle administration
asked by:
5 pts.

Exporting data from report 6i to excel
Hi pleaze any body tell me how i export data from report 61 to excel. pleaze send code.my email id is r.yasirarfat@yahoo.com

Answer Question   |  April 18, 2011  10:43 AM
Microsoft Excel, Oracle 6i, Oracle 6i import/export
asked by:
15 pts.