problem in create connection from forms 6i to oracle 9i on the same machine
i installed oracle 9i on a machine succesfuly then i installed forms 6i on the same machine what can i do to connect from forms to oracle

Answer Question   |  July 6, 2009  7:43 PM
Oracle 9i, Oracle development, Oracle Forms 6i

creating procedure for searching in oracle 8.0.6
how can i create a procedure to search records in oracle 8.0.6…i m using vb.net 2008 as frontend application

Answer Question   |  July 6, 2009  7:56 AM
Oracle 8.0.6, Oracle development, VB.NET, Visual Basic 2008

How to develop a executable for develper 6i
How to develop a executable for Oracle Forms 6i & Report 6i

Answer Question   |  April 10, 2012  11:18 AM
Oracle Developer 6i, Oracle development

ORA-01031 Insufficient privileges
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

Answer Question   |  June 16, 2009  6:51 AM
Foreign keys, ORA-01031, Oracle development, Oracle error messages, Oracle foreign keys, Oracle primary keys, Primary keys

Delphi application freezing on search
We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.

Answer Question   |  May 26, 2009  9:56 AM
Delphi 5.0, Oracle development, TAdvStringGrid

View .pdf file from Oracle Forms 10g
Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files from the database to [...]

Answer Question   |  January 14, 2011  1:47 PM
Oracle, Oracle 10g, Oracle developers, Oracle development, Oracle Forms, Oracle Forms 10g

Calculate time difference with Oracle 9i
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i go for any trigger?if [...]

Answer Question   |  February 29, 2012  11:50 AM
Oracle 9i, Oracle development, Oracle Forms 6i, Oracle triggers

Call parameter from Oracle Reports 10g web.show_doc
the code DECLARE rep_url varchar2(2000); BEGIN rep_url:=’/reports/rwservlet?’ ||’&report=c:testrpt10g.rdf’ ||’&desformat=htmlcss&destype=cache’ ||’&userid=stlexport/stlexpst@as’; WEB.SHOW_DOCUMENT(rep_url,’_blank’); END; is running well. But now i want the report’s parameter form to be displayed. How can i do this using web.show_document(…)

Answer Question   |  January 17, 2011  9:20 AM
Oracle 10g, Oracle development, Oracle Forms 10g, Web.Show_Document

How can we pass Oracle username/password programmically?
i want to add record in one table but by using 2 different usernames. for example, i want to save products information by using username: POS, but i want to use username: Stark to add new department in department table.

Answer Question   |  May 15, 2009  5:57 AM
Oracle development

How can we call different canvases within one window?
i want to design a form with three canvases. but problem is occur that other two canvases are not shown at run time. i want to create a push button and when i press it then 2nd canvas must be open.

Answer Question   |  May 15, 2009  5:51 AM
Oracle Developer 6i, Oracle development, Oracle Forms Canvas

How user parameters are created in Oracle Reports 10g
how user select the parameter from the parameter list and how it is created

Answer Question   |  May 12, 2009  4:13 AM
Oracle development, Oracle Reports 10g

Can I run Seconds on an Alert in Oracle Forms 6i
I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.

Answer Question   |  April 22, 2009  5:53 AM
Oracle development, Oracle Forms 6i, Time On Alerts in Oracle Forms 6i

Dear Carlos De Leon… Kindly help me out
Hi…. Dear Carlos De Leon You have told that i have to do that by saving the value of the parameter in the database and use it later when i need that…. Can you please help me out how can i do that…. we will have to pas as much parameters as the number of [...]

Answer Question   |  April 21, 2009  6:27 AM
Carlos De Leon, Oracle development

A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)
whenever i am trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:— a program is trying to automatically send email on your behalf do you want to allow this? if this is unexpected it may be virus and you should choose no I dont want [...]

Answer Question   |  May 12, 2011  9:06 AM
Microsoft Outlook, Oracle Developer 6i, Oracle development, Outlook

Oracle SQL question
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I’m unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case [...]

Answer Question   |  April 22, 2009  2:39 AM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL

How to create procedure in Oracle
I WANT TO CREATE A PROCEDURE FOR DOING FOLLOWING 4 ACTIONS 1) That will first delete all data from xa and then load data from xls file (TOWN.XLS on d drive)with columns USER_ID, CLUSTER_CODE,TOWN, TOWN_CATEGORY, TOWN_TYPE, TYPE, STATUS INto the table XA TABLE XA ( USER_ID VARCHAR2(40) NOT NULL, CLUSTER_CODE VARCHAR2(15) NOT NULL, TOWN VARCHAR2(50), [...]

Answer Question   |  July 30, 2009  12:28 PM
Microsoft Excel import/export, Oracle development, Oracle import/export

Using INSTEAD OF Views in Oracle Forms 6i
I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I [...]

Answer Question   |  July 30, 2009  7:18 AM
FRM-40602, INSTEAD OF triggers, Oracle development, Oracle Forms 6i, Oracle Views

DB2/400 field to match an Oracle VARCHAR?
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS [...]

Answer Question   |  May 18, 2009  9:03 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR

Please help . What I am doing wrong
Dim cmd As OracleCommand Dim ds As DataSet Dim dv As DataView Dim da As OracleDataAdapter = New OracleDataAdapter ‘ This does not work.. which is what I need, Country and State are entered by the user - cmd = New OracleCommand(“Select state_code, state_name, state_status” & _ ” FROM m_state” & _ ” WHERE country_code [...]

Answer Question   |  April 3, 2009  8:49 PM
.NET, Oracle development

Appeon with Oracle
How to Configure Oracle Data Base with Appeon.

Answer Question   |  March 31, 2009  7:24 AM
Appeon for PowerBuilder, Appeon with Oracle, Oracle development, Oracle interoperability