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

Home -> Community -> Usenet -> c.d.o.server -> Re: Object type change on the fly

Re: Object type change on the fly

From: G-Man <gfeiner_at_gmail.com>
Date: 2 Feb 2005 20:32:39 -0800
Message-ID: <1107405159.554366.281840@f14g2000cwb.googlegroups.com>


Not sure I followed everything your looking for, but here goes.

It is generally a bad idea create objects on the fly. Why not create a type and procedure for each "type" you need in a package (overloading procedures for each type). Depending on which type is passed, it will run the appropriate procedure.

Put all the code you need to run in the procedures. Return a ref cursor back to the calling code. Received on Wed Feb 02 2005 - 22:32:39 CST

Original text of this message

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