PL/SQL Blocks

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Gh0st1n5h3ll
    #1

    PL/SQL Blocks

    I'm the user of an oracle data base, recently, the dba installed a
    patch on the data base and we got problems couse the aplications
    couldn't do any insert or select; the desition was to remove the patch
    and leave the data base as it was orginally, it was done but one of
    the binaries is not working properly and the technical support of the
    aplication told me that maybe the use of PL/SQL Blocks was affected by
    the install/uninstall of the patch. Im not strong in PL/SQL so I don't
    know what it means, could you give me any clue?
    Tags: None
    • Syltrem
      #2
      Re: PL/SQL Blocks

      I'm afraid we can't help much with so little information.

      Let's say someone changed a part on your car, and it started to make a funny
      noise.
      You take it back to the garage, and they take out the part they changed.
      But you still have problems. How do you fix the car?

      Pls provide any error message you get (noise description), patch number
      (part) they installed/deinstalled.

      And what is the binary you're talking about? Does it belong to Oracle or
      your application?

      --
      Syltrem

      OpenVMS 7.3-1 + Oracle 8.1.7.4
      http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
      ---zulu is not in my email address---
      "Gh0st1n5h3 ll" <nexurina@yahoo .coma écrit dans le message de
      news:fd04e831.0 404280948.603be d39@posting.goo gle.com...
      I'm the user of an oracle data base, recently, the dba installed a
      patch on the data base and we got problems couse the aplications
      couldn't do any insert or select; the desition was to remove the patch
      and leave the data base as it was orginally, it was done but one of
      the binaries is not working properly and the technical support of the
      aplication told me that maybe the use of PL/SQL Blocks was affected by
      the install/uninstall of the patch. Im not strong in PL/SQL so I don't
      know what it means, could you give me any clue?

        Comment

        • Daniel Roy
          #3
          Re: PL/SQL Blocks

          I'm the user of an oracle data base, recently, the dba installed a
          patch on the data base and we got problems couse the aplications
          couldn't do any insert or select; the desition was to remove the patch
          and leave the data base as it was orginally, it was done but one of
          the binaries is not working properly and the technical support of the
          aplication told me that maybe the use of PL/SQL Blocks was affected by
          the install/uninstall of the patch. Im not strong in PL/SQL so I don't
          know what it means, could you give me any clue?
          Could you give more details as to how this binary "is not working
          properly" (error message, version, ...). If you want to see any
          invalid PL/SQL stored in the database, take a look at STATUS in
          DBA_OBJECTS, and look for anything "INVALID" for
          procedures/functions/packages/package bodies (for OBJECT_TYPE). You
          can try to compile anything invalid using "alter
          procedure/function/... compile", and issue a "show errors" if it
          fails, to see the reason why it wouldn't compile. That's all I can
          advise, based on the skeleton of info you provided.

          HTH

          Daniel

            Comment

            Previous template Next
            Working...