1 Reply Latest reply: Nov 29, 2013 3:02 AM by juliojgs RSS

    forms crashes when calling get_ole_memberid

    juliojgs

      I'm migrating 6i to 11g

      We had a very nice generic multirecord block to excel export feature.

       

      Now in 11g it crashes when I try to write an olevar in an excel range.

       

      I mean, I'm able to open the xls in the client with client_ole2, write some individual cells values, format then ... But when I get to the main part, the moment when I write the array in the excel range ... it crashes.

       

      Tracing it, I've found that the problematic built-in is:

      GET_OLE_MEMBERID

       

      This is the piece of code:

      Procedure Pf_Escribir_en_Rango (p_cel_ini char, p_cel_fin char, p_datos OLEVAR) IS
      Begin
        Pl_Set_Rango (p_cel_ini, p_cel_fin);     -- this one sets value for "rango" , which is a package level client_ole2.obj_type variable. I know this works ok.
        Set_OLE(rango, GET_OLE_MEMBERID(rango,'Value'),p_datos);     --> HERE IS THE CRASH
        DESTROY_VARIANT (p_datos);
        client_ole2.RELEASE_OBJ (rango);
      End;
      

       

      This code - without client_ole2 - worked very well in client/server 6i

      The olevar "p_datos" is created with to_variant of a plsql table

       

       

      Anybody knows how to write a plsql table into an excel range in 11g?

        • 1. Re: forms crashes when calling get_ole_memberid
          juliojgs

          This is the frmweb_dump:

           

          Last Trigger: WHEN-BUTTON-PRESSED - (In Progress)

          Last Builtin: GET_OLE_MEMID - (In Progress)

          ----- Call Stack Trace -----

          Symbol file C:\Oracle\Middleware\Oracle_FRHome1\RDBMS\ADMIN\oracore11.SYM does not match binary

          Symbol file C:\Oracle\Middleware\Oracle_FRHome1\RDBMS\ADMIN\oraclient11.SYM does not match binary

          Symbol file C:\Oracle\Middleware\Oracle_FRHome1\RDBMS\ADMIN\orageneric11.SYM does not match binary

          calling              call     entry                argument values in hex     

          location             type     point                (? means dubious value)    

          -------------------- -------- -------------------- ----------------------------

          Symbol file C:\Oracle\Middleware\Oracle_FRHome1\RDBMS\ADMIN\oracore11.SYM does not match binary

          Symbol file C:\Oracle\Middleware\Oracle_FRHome1\RDBMS\ADMIN\oraclient11.SYM does not match binary

          Symbol file C:\Oracle\Middleware\Oracle_FRHome1\RDBMS\ADMIN\orageneric11.SYM does not match binary

          77526260                      00000000            

          _siaugmi_GetMemID()  CALL???  00000000             85 0 0 0 128F04 6658CEDF

          +71                                               

          ----- End of Call Stack Trace -----