Re: Using fully qualified table_name.database_object in application code?

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Mon, 24 Feb 2003 10:44:37 -0800
Message-ID: <F001.0055713C.20030224104437@fatcity.com>

I try not to do it. Here's an example:

I have one central schema in development, this schema's objects relate most closely to my production schema. I keep a set of public synonyms that refer to this schema's objects.

As developers want to make changes to objects, I allow them to make their own copy of the object. This allows the developer to access only his object without having to make code changes, as the name in the developer's schema is the same as the public synonym. Once the developer's code moves to test and production, no hard-coded names have to be changed.

If we hard-coded the owner.object_name, we'd have to make changes to code as it moves through the various environments, something we don't want to do

• laura pena <lizzpenaorclgrp_at_yahoo.com> wrote:
  >
  > I would like to know if it is advocated to use fully qualified
  > table_name.database objects in application code.
  >
  > Example would be schema.table_name in a PL/SQL code.
  >
  > I would like to know the Pros/Cons if there are any?
  >
  > Thanks in advance.
  >
  >
  >
  > ---------------------------------
  > Do you Yahoo!?
  > Yahoo! Tax Center - forms, calculators, tips, and more
  

  ---

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Feb 24 2003 - 12:44:37 CST