2 Replies Latest reply: Jan 2, 2012 2:33 AM by 903978 RSS

    More references for nested views documentation and examples

    903978
      Hello,

      I have been looking for documentation about nested views in Oracle documentation site, but I could not have found direct documentation/examples focused in this feature.

      I found references in "Oracle Tuxedo 11g Release 1 (11.1.1.2.0) Release Notes" in "What’s New and Improved".

      Also in "Using an VIEW Type Buffer in Programming an Oracle Tuxedo ATMI Application Using C.", subsection "Creating a View Description File " in table "Table 2-7 View Description File Fields", it says that field type can only set to short, long, float, double, char, string, or carray but no any type for nested views.

      In this page in "Listing 2-12 View Description File for an Independent View" the view "MYVIEW" has a "struct" type ( ...struct empname ename 1 - - 0...). Is this type for the nested view feature?

      Note: the URL with the example view is: http://docs.oracle.com/cd/E18050_01/tuxedo/docs11gr1/pgc/pgbuf.html#wp1127609
      and the content is:

      ---------------------------------------------------
      $ /* View structure */
      VIEW empname
      #TYPE CNAME FBNAME COUNT FLAG SIZE NULL
      string fname - 1 - 25 -
      char minit - 1 - - -
      string lname - 1 - 25 -
      END
      $
      VIEW MYVIEW
      #type cname fbname count flag size null
      float float1 - 1 - - 0.0
      double double1 - 1 - - 0.0
      long long1 - 1 - - 0
      short short1 - 1 - - 0
      int int1 - 1 - - 0
      dec_t dec1 - 1 - 9,16 0
      char char1 - 1 - - '\0'
      string string1 - 1 - 20 '\0'
      carray carray1 - 2 CL 20 '\0'
      bool bool1 - 1 - - 0
      signedchar signedchar1 - 1 - - 0
      unsignedchar unsignedchar1 - 1 - - 0
      wchar_t wchar_t1 - 1 - - 0
      unsignedint unsignedint1 - 1 - - 0
      unsignedlong unsignedlong1 - 1 - - 0
      longlong longlong1 - 1 - - 0
      unsignedlonglong unsignedlonglong1 - 1 - - 0
      longdouble longdouble1 - 1 - - 0
      struct empname ename 1 - - 0 <------------------------------- Type is "struct", to be use for nested views?
      END
      ---------------------------------------------------

      Where I can find more specific documentation?

      Thanks in advance