Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: PL/SQL Blocks

Re: PL/SQL Blocks

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 28 Apr 2004 16:30:29 -0700
Message-ID: <3722db.0404281530.4d545cc5@posting.google.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?

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 Received on Wed Apr 28 2004 - 18:30:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US