1 2 Previous Next 25 Replies Latest reply: Feb 14, 2013 1:36 PM by TexasApexDeveloper RSS

    Problem REF

    984152
      hi

      CREATE TYPE emp_person_typ AS OBJECT (
      name VARCHAR2(30),
      manager REF emp_person_typ );

      CREATE TABLE emp_person_obj_table OF emp_person_typ;

      INSERT INTO emp_person_obj_table VALUES (
      emp_person_typ ('John Smith', NULL));

      SELECT *
      FROM emp_person_obj_table;

      in APPEX I get the following error:
      ORA-00932: inconsistent datatypes: expected NUMBER got REF db.emp_person_typ
      I was told that APPEX not accept REF, I wanted to know how I could do

      Edited by: 981149 on 14-feb-2013 8.02
        • 1. Re: Problem REF
          Howard (... in Training)
          Please see comments here (courtesy Tony Miller) {thread:id=2142116} .

          Tony may be able to add more as this is from 2010.

          I see Tony also suggested: "See this link... http://mikesmithers.wordpress.com/2012/02/22/getting-apex-to-play-with-ref-cursors/ "

          Hey, Tony. You out there?

          Regards,
          Howard
          • 2. Re: Problem REF
            984152
            I'm not sure we are talking about the same thing ...
            • 3. Re: Problem REF
              Howard (... in Training)
              Ah, you are probably correct. I'm was thinking REF cursers. Sorry?

              Howard
              • 4. Re: Problem REF
                984152
                my example has seen it? define an attribute of type REF
                • 5. Re: Problem REF
                  TexasApexDeveloper
                  APEX does NOT deal well with complex object types like this.. Why exactly do you wish to do this?

                  Thank you,

                  Tony Miller
                  Ruckersville, VA
                  • 6. Re: Problem REF
                    984152
                    I need for a university project
                    how do I use the ref? or how can I use objects without ref in APPEX in a timely manner?
                    • 7. Re: Problem REF
                      TexasApexDeveloper
                      In APEX?? You don't use them for forms & Reports.. I haven't seen any way to handle objects in APEX, since the controls are for simple items..

                      Thank you,

                      Tony Miller
                      Ruckersville, VA
                      • 8. Re: Problem REF
                        984152
                        so what can I use?
                        • 9. Re: Problem REF
                          TexasApexDeveloper
                          Define your requirements? What is the business problem you are trying to resolve??

                          Thank you,

                          Tony Miller
                          Ruckersville, VA
                          • 10. Re: Problem REF
                            984152
                            my problem is:

                            database for screening of films and passages of commercials and trailers in a multiplex cinema.
                            The Projection class contains the description of the screenings are planned for a movie (the room in which it is projected, the date of the projection and the start time).
                            Each movie can `or have associated different projections.
                            A projection refers to a single film. A projection can be associated with several steps advertising (commercials or movie trailers).
                            The association between projection and Advertising is many to many.

                            I have to solve it with an object database
                            I would also class diagram but I do not know how to put it on the forum
                            publicity is super-class of spot and trailer
                            the relations are:
                            projection-film
                            projection-pubblicity
                            film-trailer

                            Edited by: 981149 on 14-feb-2013 9.35
                            • 11. Re: Problem REF
                              Howard (... in Training)
                              In the early days of computing -- as the earth was cooling and we engraved 0's and 1's on stone tablets, we placed complex data in arrays and used integer subscripts to link that data. ??? (more) I suppose APEX would support such linking.
                              • 12. Re: Problem REF
                                TexasApexDeveloper
                                Then you would look at a development tool THAT CAN work with an object based database design.. Java comes to mind, maybe Cold Fusion.. APEX will handle a relational database design not containing object types defined within it.. Unless you go and write code to handle retrieval and saving of the objects wrapping apex code around those methods..

                                Thank you,

                                Tony Miller
                                Ruckersville, VA
                                • 13. Re: Problem REF
                                  fac586
                                  >

                                  Please update your forum profile with a real handle instead of "981149".
                                  I need for a university project
                                  how do I use the ref? or how can I use objects without ref in APPEX in a timely manner?
                                  Is there a stipulation that this project must use object types and APEX? Is it intended that this be a demonstration of proficiency in these technologies?

                                  If not, why have you decided that you want/need to use objects and APEX?

                                  Have you taken courses or been instructed in the use of Oracle object-relational technology and/or APEX?
                                  • 14. Re: Problem REF
                                    TexasApexDeveloper
                                    It would until you get into displaying stuff and processing stuff.. APEX deals with simple objects, NOT complex objects... Just the way it is, until they decide to start handling more complex stuff.. I'd prefer they fix the NO PRINT ENGINE functionality in APEX before they go off and deal with complex objects..

                                    Thank you,

                                    Tony Miller
                                    Ruckersville, VA
                                    1 2 Previous Next