469,271 Members | 829 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

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?
Jul 19 '05 #1
2 2054
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---
"Gh0st1n5h3ll" <ne******@yahoo.com> a écrit dans le message de
news:fd**************************@posting.google.c om...
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?

Jul 19 '05 #2
> 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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

20 posts views Thread by Doug Holton | last post: by
1 post views Thread by Achim Domma | last post: by
2 posts views Thread by flyzone | last post: by
3 posts views Thread by GaryDean | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.