Mardi 13 mai 2008
This PJC is a workaround to the issue defined in the bug 3867157 on Metalink.

It allows having the same behaviour on the Web that the one it has on the C/S version. The When-List-Changed trigger would fire only when the mouse is clicked or when the Enter key is pressed, but not when the end-user types a letter to filter the list.

 

Read the article

par Francois Degrelle publié dans : Oracle Forms
ajouter un commentaire commentaires (0)    créer un trackback recommander
Mercredi 30 avril 2008
Two Oracle Forms Java Beans have been updated:

JTable Java Bean with a correction concerning the color/format for CHAR cells


Dynamic Menu Java Bean that, now, allows multiple sub-menus

par Francois Degrelle publié dans : Oracle Forms
ajouter un commentaire commentaires (0)    créer un trackback recommander
Dimanche 6 avril 2008

Hello there,

I would be pleased to present the brilliant work of a nice French person, who has developped a library, capable of encapsulating the so complex OCI interface.
It is a powerful workaround for those C programmers that are not totally satisfied with the Pro*C stuff, and want to handle the powerful OCI without the headache that comes with.

Here is the summary of what his tool can do that I quote as he wrote himself:

 

Introduction

OCILIB is a free, open source and platform independant library, written in C, that access Oracle Databases.

The OCILIB library :

  • Encapsulates OCI (Oracle Call Interface which is powerful but complex)
  • Hides OCI complexity
  • Proposes instead a simple, readable and reusable API
  • Offers up to 310 simple and straightforward APIs.

Introduction

Current version : 2.3.0 (2008-03-30)

Main features

  • Data binding
  • Integrated smart define and fetch mecanisms
  • Full Unicode support on all platorms
  • Multi row fetching
  • Binding array Interface for fast and massive bulk operations
  • Reusable Statements
  • Connection Pooling
  • Global Transactions
  • Returning DML feature support
  • ROWIDs support
  • Named Types (Object types) support (User or Builtin)
  • Cursors
  • PL/SQL blocks
  • PL/SQL Ref cursors and Nested tables
  • LOB (BLOBs/ FILEs)
  • Supports lobs > 4Go
  • Long datatype (piecewise operations)
  • Provides "All in one" Formatted functions (printf's like)
  • Smallest possible memory usage
  • Date/time management
  • Timestamps and Intervals support
  • Error handling
  • Describe database schema objects
  • Access columns by index or name
  • Hash tables API
  • Portable Threads and mutexes API
  • Supports static / shared oracle linkage
  • Support runtime loading (no OCI libs required at compile / time)
  • Great performances (straight OCI encapsulation)

Download

Get OCILIB from OCILIB Project page at Sourceforge Website

Author

OCILIB is developped by Vincent Rogier
par Francois Degrelle publié dans : Other
ajouter un commentaire commentaires (0)    créer un trackback recommander
Mardi 25 mars 2008
Here is a code snippet showing how you can test if a file exists on a web site (that you have access, of course).
It uses the UTL_HTTP database package.

DECLARE
  url       VARCHAR2(256) := 'http://sheikyerbouti.developpez.com/tmp/f6_menus/menudef.mmb';
  username  VARCHAR2(256);
  password  VARCHAR2(256);
  req       UTL_HTTP.REQ;
  resp      UTL_HTTP.RESP;
BEGIN
  req := UTL_HTTP.BEGIN_REQUEST(url);
  IF (username IS NOT NULL) THEN
    UTL_HTTP.SET_AUTHENTICATION(req, username, password);
  END IF;
  resp := UTL_HTTP.GET_RESPONSE(req);
  DBMS_OUTPUT.PUT_LINE('response -->' || resp.status_code);
END;


If the file exists, you get a 200 (also known as UTL_HTTP.HTTP_OK) return code. If it does not exist, you get the famous 404 (
also known as UTL_HTTP.HTTP_NOT_FOUND) return code.
par Francois Degrelle publié dans : Oracle PL/SQL
ajouter un commentaire commentaires (0)    créer un trackback recommander
Mardi 25 mars 2008
The Forms Swing JTable Java Bean has been updated to correct some issues when used with the JInitiator plugin.
If you are using this plugin, 
re-load the new jar file from the article.
par Francois Degrelle publié dans : Oracle Forms
ajouter un commentaire commentaires (2)    créer un trackback recommander
Créer un blog sur over-blog.com - Contact - C.G.U. - Rémunération en droits d'auteur avec TF1 Network - Signaler un abus