Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Object type change on the fly
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