Using .NET Stored Procedures in Oracle 10gR2
![Using .NET Stored Procedures in Oracle 10gR2]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Using .NET Stored Procedures in Oracle 10gR2")
From the OTN Series on “Mastering .NET Application Development with Oracle”, this installment on taking advantage of .NET stored procedures in your applications. See Using .NET Stored Procedures in …
Category: PL/SQL
Oracle Designer – Keyword Expansion upon Check Out
A little while ago I wrote the article Oracle Designer Check In – synchronize P_VERSION argument on this weblog. In it, I discuss the desirability of having Oracle Designer …
Oracle Designer Report – SQL Script for Roles vs. Modules
On my current project, we had a request from the customer to produce an overview of all the (Database) Roles in the Application with a list of Modules, Screens …
Oracle Designer Check In – synchronize P_VERSION argument
As you can probably tell from the topics and nature of my blog-postings recently, I am very deepy involved in a project using classical Oracle development technology such as …
Introducing new Oracle10g R2 features for Application Development (article in Dutch)
For the Fall 2005 issue of OGh Visie, the magazine of the Dutch Oracle User Group, I have written an article introducing the most enticing new features for Application …
Use of TODO tags to quickly generate a tasklist for PL/SQL development
There are quite a few neat tricks we can steal from other technology stacks and communities for use with PL/SQL development. I have recently written an article on AOP …
Dashboard for Oracle Designer – free extension to Repository Object Browser
It can be both quite useful and rather difficult to monitor the events taking place in Oracle Designer and/or Oracle SCM (Software Configuration Manager). Keeping track of all Check …
Designer ERD as pdf
An easy way to get your Designer ERD’s in a PDF-files is using PDFCreator. PDFCreator will install a new virtual printer. Using this printer to print your ERD in …
PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving
Source code control for PL/SQL is often discussed in the organizations that I encounter. The database itself will always hold the latest version of the PL/SQL objects we are …
PL/SQL post compiler to fix TAPI – dealing with the 'TAPI cannot deal with MERGE' problem
Recently I wrote a post about the failure of the TAPI (table API) generated by Oracle Designer to work together with Merge operations: Designer TAPI triggers fail on SQL …
Designer TAPI triggers fail on SQL MERGE operations
It turns out that the combination of the Table API (TAPI) as generated by Oracle Designer and MERGE operations using the Oracle 9i SQL Merge statement are not compatible. …
Tuple Rules! Using NVL2 and NULLIF.
While working on a current project I ran into the requirement that a column was mandatory, depending on the value of another column. The other way ’round was also …
View to select CG$ERRORS from (easing RuleFrame pain using a Table Function)
On my current project I am doing a lot of work with CDM RuleFrame and the Oracle Designer Table API. I just learned that the TAPI cannot survive MERGE …
Poor man's VPD – Virtual Private Database before 8i and in Standard Edition Databases
The concept of Virtual Private Database – aka Row Level Security or Fine Grained Access Control – is quite powerful. Without any impact on the SQL used in the …
Death of the End Date – How LAG and LEAD help fight redundancy
Yesterday just prior to our AMIS Query on ADF Faces I was talking to Toon Koppelaars about quite something else: the end_date column in tables that contain contiguous records …
Oracle Designer and Oracle SCM – Last Date Modified and querying in the ROB
Today I decided to write a small package, an extension, to the Repository Object Browser for Oracle 10g (or 9i) Designer and Oracle 10g SCM. This extension will provide …
Another Pop-Quiz: Whose VPD policy is used when executing SQL in a (definer rights) package?
Virtual Private Database does not let me go. Today I had another burning question to which I could not see the immediate logical answer. I know that when a …
Returning a Ref Cursor based on a PL/SQL Collection
The question on the OTN Forum was: How do i add rows to a pl/sql table and then use the table to open a ref cursor.. Somehow I was …
Good Citizenship – Have Client Applications register themselves with the database
Years ago I have read about the package dbms_application_info for the first time. This is a standard supplied package, shipped with every Oracle Database. It can be used to …
Debugging PL/SQL with DBMS_DEBUG
A very good instruction on the programmatic interface to Orace’s PL/SQL debug facilities. If you do not happen to have a GUI PL/SQL debugger – such as in JDeveloper …
Pop-quiz: VPD policy that depends on a table with a policy…
What happens if the policy function on table A returns a predicate that refers to table B and table B has its own policy. For example: in a Master-Detail …
Select Trigger in Oracle Database – introducing Fine Grained Auditing
Does Oracle provide a SELECT trigger in the same way that we have INSERT, UPDATE and DELETE triggers? No, it does not. However. It does offer something that comes …
Data Profiling with Oracle Warehouse Builder 10gR2 (article in Dutch)
The 10gR2 or Paris release of Oracle Warehouse Builder is attracting a lot of attention. During Oracle Open World 2005 of course, and in a number of Blogs by …
PL/SQL Profiling
How do you trace performance issues and bottlenecks in your PL/SQL applications? Since 8i the Oracle database has been equiped with the profiling tool dbms_profiler. It is quite simple …
Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)
Oracle SCM – the Software Configuration Manager – provides the backend source code control services for Oracle Designer. It offers among other things functionality for Version Control: Check In, …
Building Check In protection into Oracle Designer/Oracle SCM – Check In only by the user that did the Check Out
One of the peculiarities – that word once took me three minutes to pronounce more or less correctly during a workshop in Melbourne, Australia and I vowed never to …
Standard for Database Development – Getting rid of USER from PL/SQL and SQL – no longer is USER equivalent to End User
Many applications built in the Client/Server era made use of the fact that every end user had his or her own Database User Account and every Database Connection and …
Repository Object Browser – Invoking the full property palette for any secondary element
The Repository Reports in the Oracle Designer web-interface Repository Object Browser provide an overview of the most useful properties of the most important components of the elements in the …
Integration between Repository Object Browser and Headstart Utilities Quality Reports
The Repository Object Browser is a valuable web-based interface to the Oracle Designer and SCM Repository, as I discussed in a recent post: Installing the Oracle Designer Web Interface …
Installing the Oracle Designer Web Interface – Repository Object Browser (dig up that little nugget)
One frequently overlooked component of Oracle Designer is its Web Interface: the Repository Object Browser. Added in 2003 to Designer 6i and 9i as well as in 2004 to …
Some small improvements for CDM RuleFrame (including code)
After a year full of stuff like Spring, UIX and ADF, JHeadstart, Struts and JSF, XSL-T and the likes, PL/SQL and SQL, I had a bout of nostalgia this …
Book Review: Beginning Oracle Programming
Title: Beginning Oracle Programming Authors: Sean Dillon, Christopher Beck, Thomas Kyte with Joel Kallman and Howard Rogers Publisher: Apress ISBN: 1-59059-286-7 Publication Date: Sep 2003 Website: http://www.apress.com/book/bookDisplay.html?bID=253
Hierarchical query with nodes from different tables – DEPT and EMP nodes in one tree
Hierarchical queries using CONNECT BY logic are discussed quite frequently. Often in terms of EMP, the famous demo table that has a self referencing foreign key – MGR to …
Bill of Materials and Hierarchical Queries – Which Component contains a component that…
My two previous posts discussed presenting data in a tree-like fashion and filtering hierarchical data sets on certain query conditions while still returning a tree-like result set. This post …
Great Oracle Forms 'plugin' – multirecord table column resize/sort/move around
Developed by Francois Degrelle, this is a great enhancement for any Oracle Forms 9i or 10g application: a simple to install plugin that allows users to resize columns in …
Ant, Stored Procedures and dbms_output
Running sql (scripts) from ant using the ant task is quite easy and straight forward. Unfortunately, the ant sql task is not really suited for running pl/sql, e.g. exec …
Oracle Warehouse Builder suddenly stops working?
Did you recently try to start your OWB client and found that it suddenly did not want to start? Well you’re not the only one. All OWB users around …
PLDOC, documenting your PL/SQL directly from the database
Ever asked a PL/SQL code developer to create documentation for his code, the way Javadoc is able to create for Java code? It is possible using the open-source tool …
Feuerstein is coming to Amsterdam
On september 8, 2005 Quest Software will organize a training seminar in Amsterdam by Steven Feuerstein. It will cover two topics: 1. Correcting PL/SQL Worst Practices and 2. Survey …
Using Oracle Enterprise Search (Text Searches)
Last week I attended a Theme meeting of the Dutch Oracle Usergroup (OGH). The topic was called “Zoek en Gij zult Vinden” (“Search and you will find”) by Wouter …