Recent content by genetics

  1. G

    Database Alias

    Good question! there are three posibilities: 1st: don't be ungry but maybe your "idea" is not good (from OOD point of view). You should change this. If you want - I can help you, but contact with my be my private email. 2nd: (easiest) override constructor for utiliti form and add new...
  2. G

    Package Wizard and dbms_aq.message_properties_t

    I forgot write that when I create the same procedure and change (make some conversion) that problematic type to diffrent one (without senderId field) than everything is Ok. B.R. Lukasz Z.
  3. G

    Package Wizard and dbms_aq.message_properties_t

    Simple package procedure definition: PROCEDURE DequeueRecord2( piNavigation IN BINARY_INTEGER, poMsg OUT TF2MRecord, poMsgProp OUT dbms_aq.message_properties_t, pRESULT OUT NUMBER); Wizard is creating also type: DbmsAqMessagePropertiesT (it could be usefull to give the...
  4. G

    package wizard and object type...

    Hi! What's going on? I repeat my question... please, I need this feature... I'm using package wizard, and I have problems with one, predefined by Oracle type, called: dbms_aq.message_properties When procedure has a parameter with this type, I can't call that one. When I try to do this I...
  5. G

    Achieving an ORDER BY

    Hi First of all: 500.000 is not much. 'Order by' takes so much time probably because you forget to create index... With index it should be quick-and-easy.. Rest about QBE - sorry, but I can't understand where the problem is... Regs. Lukjel
  6. G

    Package Wizard and dbms_aq.message_properties_t

    Hello To All !!! I'm using greate tool: Package Wizard. And I'm also using AQ mechanism from Oracle (8.1.7... in future 9) but.... there is one problem. I have one proc in my package where I have defined parameter OUT: MSG_PROP OIUT dbms_aq.message_properties_t and it doesn't work! I can't call...
See more
Back
Top