Databases
StackOverflow2013
Postsdbo
POInstantiating oracle object type using a type name in varchar2
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInstantiating oracle object type using a type name in varchar2
    primarykey
    data
    text
    <p>Initial situation:</p> <ul> <li> I have a typename in a variable: </li> <code>type_name varchar2(20) := 'T_MY_TYPE';</code> <li> T_SUPERTYPE is a supertype of T_MY_TYPE </li> <li> T_MY_TYPE overrides a single method to provide specific behavior. </li> <li> The constructor function of my self defined object type T_MY_TYPE has no parameters. </li> <li> I need to create a type instance using the given variable. </li> <li> The created instance has to be assigned to a variable of the supertype T_SUPERTYPE. </li> <li> Oracle Version: 11.2.0.2.0, Developing with PL/SQL Developer 10.0.1 </li> </ul> <p>My failed attempt:</p> <pre> <code> declare type_name varchar2(20) := 'T_MY_TYPE'; myInstance T_SUPERTYPE; begin execute immediate 'myInstance := ' || type_name || '()'; -- Fails with ORA-00900: Invalid SQL statement -- tried alternative: exceute immediate 'select ' || type_name || '() from dual into myInstance'; -- doesn't work either (ORA-00933: SQL command not properly ended) end; </code> </pre> <p>Additional Information: I want to use a couple of object types that all inherit from one single supertype. All inheriting subtypes differ only in the implementation of a single method. In the end i will have a function that iterates over a number of varchar2 ( the type names), instantiates all types and calls the functions (all same name, but do different things because of the different implementation). The different subtypes contain some convenience stuff and forces the developer to stick to the rules by inheriting from the supertype. So i just want to use the classic advantage of polymorphism.</p> <p>As PL/SQL is definetly not my native language, i will appreciate any suggestion :)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSixDoubleFiveTreeTwoOne
    1. USSixDoubleFiveTreeTwoOne
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInstantiating oracle object type using a type name in varchar2
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPossible [duplicate](http://stackoverflow.com/questions/9362994/how-to-call-an-oracle-pl-sql-object-super-method/9364571#9364571)
      singulars
      1. POInstantiating oracle object type using a type name in varchar2
      1. UStbone
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload