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

Home -> Community -> Usenet -> c.d.o.tools -> Table column containing procedure

Table column containing procedure

From: Raymond Wong <wongbun_at_globalsources.com>
Date: 2000/07/25
Message-ID: <8ljjcb$66s3@imsp212.netvigator.com>#1/1

Hi, all.

I need your help.

I would like to implement a table with a column which stores a procedure. For example, I have a commission table storing 30 different commission calculation. I would like to allow the sales manager or company policy maker to input a formula for each row and that will become a 'row procedure'.

It's like a stored procedure, but it is maintained by row. Can this be implemented using ORACLE? If yes, what is the data type I should use? Received on Tue Jul 25 2000 - 00:00:00 CDT

Original text of this message

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