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

Home -> Community -> Usenet -> c.d.o.misc -> How to add an object to an existing table?

How to add an object to an existing table?

From: Ubiquitous <weberm_at_polaris.net>
Date: Thu, 18 Nov 2004 15:06:53 +0000 (UTC)
Message-ID: <cnidqd$5sj$1@news.utelfla.com>


I have an existing table in ORACLE 8 and would like to make an existing stand-alone stored procedure, load_table(file_name), a method associated with the table. Without bogging you all down with too many details, the stored procedure uses the input parameter to determine how to parse the file for inserting into the table.

Now, I did some prelimionary reading on objects and it appears I would either have to add it to the table as a new data column OR recreate the table as an object and then add the stored procedure as a method.

Is there another way to associate the stored procedure with the table, other than using a package with the table's name? I really hate having this freefloating  stored procedure while other codes are stored in packages and I don't particuarly want to "normalize" load_table(file_name) into seperate versions for each package.

Thanks in advance!
MRW   Received on Thu Nov 18 2004 - 09:06:53 CST

Original text of this message

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