Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dimension table load - PLSQL question

Re: Dimension table load - PLSQL question

From: Edgar Chupit <chupit_at_gmail.com>
Date: Thu, 29 Sep 2005 21:34:41 +0300
Message-ID: <a8f0771c050929113423debc95@mail.gmail.com>


Exactly what was your problem? If you just need to select just do a select (as I've described in previous mail), but if you have a lot of parameters (p_cdX) and don't like to type/copy&paste sql subqueries, just create simple loop to generate query and do "execute immediate query returning into p_key"? Or maybe you need to describe your problem more specific.

On 9/29/05, Edgar Chupit <chupit_at_gmail.com> wrote:
> Why not implement this in old fashioned way (don't you think that it
> will work just fine), just do:

--
Best regards,
  Edgar Chupit
  callto://edgar.chupit
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 29 2005 - 13:36:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US