(Andre Crone) Old style Forms applications normally don’t hold much workflow functionality. Sure there is an order in which the forms should be used. The workflow of the application is in the mind and knowledge of the user. For my current project I am investigating, together with my colleague Peter

(Brian Peasland) When running an application that is connected to an Oracle server/database, and trying to add rows or make a call to the DB, I am getting various errors that I believe are stating that the stored procedures are invalid. This is the first time I am using Oracle (10g). Is there anythi

(Mark A. Williams) Suppose you’ve just received an e-mail detailing several IT initiatives, two of which will affect your future application development techniques. First, all applications should be designed to minimize network utilization. And second, applications that use Oracle databases must use

You may need the Result Set from a Query in your .NET or Java Code by calling a Stored Procedure. Here are some samples for SQL Server and Oracle 10g.

(Gavriel Pedros) Imagine the following scenario: While doing research for an implementation-related project, you read a blog or article about certain open source software that is “database independent” and that should work with “any” ANSI SQL compliant database, such as Oracle Database.

(Sylvain Fontaine) For several years, I worked as an Oracle Consulting employee, and I’d like to share my experience in that role, working on a massive Oracle Applications implementation deployed in an FDA-regulated company.

(Sam Alapati) There are several configuration directives that you can use to configure basic things such as the directories from which OHS will serve static Web documents or the directories for storing the error logs. You also have directives that help configure access control by specifying the serv

(Mark Brunelli) Brian Peasland knows the Oracle Database. As an independent Oracle database consultant and SearchOracle.com’s resident expert on backup and recovery and database design, Peasland spends his days helping companies and individuals get more out of Oracle’s flagship database management s

(Bas Klaassen) FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin).

(Steve Muench) In previous columns, I’ve discussed how you can use Oracle JDeveloper to create data-bound Web pages for an application’s view layer by dragging and dropping components in a visual editor. In a future column, I’ll investigate similar capabilities that Oracle JDeveloper provides for bu