oracleforms

Oracle Forms - Host Command - Return Error Code

Within a Oracle Forms trigger I am using the host command to make a directory on the file server. An example of this part of my code is below: HOST ('mkdir'||:GLOBAL.DIRECTORY_PATH||'\FERTILIZER\'||ADDY); I need to have the error code returned to me if the directory is not created on the server. Any suggestions of the code I need to ad...

Oracle Forms - where is the current documentation?

I just spent far too long wandering around Oracle's website looking for the latest developer documentation for Oracle Forms (10g or 11g versions preferably). The closest I came was this page, but none of the links I clicked actually brought me to useful documentation. http://www.oracle.com/technology/documentation/10g_forms.html I'm l...

Can Oracle forms 11g connect to DB2 or SQL Server?

Hi, I just want to know whether Oracle forms 11g supports other databases like DB2, SQL Server etc. Also does Oracle forms 11g supports Oracle database 9i or 10g apart from 11g? ...

Where I can get oracle from builder 6?

I need Oracle form builder 6.0.(report also) would you help me where I can find it? ...

Calling an excel function from oracle forms

Can anyone suggest how I can use ole2 to perform an excel function (e.g. PMT()), from oracle forms and get back the result?? ...

Oracle Forms Application and Outlook 2010 conflict

We are using the web application that was build using Oracle Developer 10g (10.1.2.02). After the Microsoft Outlook 2010 has been installed we started having problems. Now every time we try to access the application, Internet Explorer crashes. Does anyone experiences the same problem ? I would really appreciate if you share your work a...

Database forms VS Programming

What is the benefit of using Oracle Database forms VS using C#(VB) or like this for programming? from academic view ...

Oracle Forms 10 auto save form data

He is there a function or setting which automaticly save's the form's data when a user forgot to press save? Like Word has? ...

How to reverse engineer Oracle forms?

I need some software to reverse engineer my Oracle forms to a diagram like UML (cannot because Oracle forms use functions) or DFD or CFD (SSADM). Any ideas on what to use? ...

Oracle forms 6i

Complete Oracle n00b here. I have to maintain a legacy form that was developed using Oracle forms 6i and runs on an Oracle 8i backend. Is there any location on the web from where I can still download Oracle forms 6i? If not then whats the best way to run this form on a newer version of oracle? ...

Automation testing tools for Oracle Forms app?

I'm looking for toolset recommendations to automate testing of an Oracle Forms application, with the tests (ideally) to be driven from Cucumber. I believe this is normal/unavoidable in apps based on Oracle Forms, but I'll spell it out anyway; the way the application works from an end-user perspective is: User connects via a browser, b...

Error when trying to run an update statement and getting identifier <table name> must be declare

i am getting error when trying to run an update query in key commit trigger in oracle d2k the error is: "identifier must be declare the complete code is as follows:--- DECLARE LS_STATUS VARCHAR2(1); LS_COUNT VARCHAR2(3); BEGIN GO_BLOCK('BOO_BLOCK_CAST'); LS_COUNT:=0; IF :BOO_BLOCK_CAST.NBT_CAST_NO IS NOT NULL THEN ...

problem in using methodology...

Dear friends I develop a software with Oracle form builder for my final thesis. I want to prepare some of software development document for my final thesis report. as you know oracle forms blow ver 8.0 is procedural base... I use oracle form 6... I need to prepare Software Requirement Specification (SRS) and Software design document (...