Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

i want to install utl_file package

636853May 9 2008 — edited May 9 2008
My utl_file package is corrupt.

it shows errors while i m executing my stored procedure SP_DATA_VERIFICATION:

ORA-04063: package body "SYS.UTL_FILE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.UTL_FILE"
ORA-06512: at "SYS.SP_DATA_VERIFICATION", line 55
ORA-06512: at line 2

Early it was working fine. But today i received such error.

I opened my utl_file package, and run the

CREATE OR REPLACE PACKAGE "UTL_FILE" script.

but when i try to run below body script, it give me errors.

i need to re-install my UTL_FILE package.

Help me on this.

CREATE OR REPLACE PACKAGE BODY "UTL_FILE" wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
6557 1244
sQzi/XeknIPmomghTl85qyxlp0Ywg81xeSD9vvO5F3OeM6kVb+U2p5DSGAQicGw7Guk8mBW5
xWFt4RWoEeI1x7+v7dJeP8863MutXcBjMv2wkzZK7V10B4IoF0CW2Uxhz5B5wMJN6ihd/poi
dhnttaUoCaC2My8lAIrACW9cGQGZkqdQtZdud/abG/anBdi+ep1F5DOWmtyhzDubEsIwym1R
l+wHhMwyOhsg4j4oYOIwS52VJP++4HrLBLXyeHydDq6g+2pEZSHwockHMjW+twFMDUwrMsvV
5k/qeMf/8y+iHg/CkjLE15T+HPnqsbZiPHmfqk2/QpU+BcpVCv2bm+afQDxCt3hVa5dOlAir
MDJqHn9VHIPiPuWyqNTDnB9eo3v36EMkPPgnMZQy6aqGrI7BClH6nExVenxSJjyyc37myAf0
hwHEraHYchO+O+o6pvlvgRk9y9yVIdlpUG+q2enVPsPhAB5lBRYxCU2nk5OeHgbDXvI9XVW8
Jm7hkiL2oVhcEwD9rAw5euj6ICK8qv75wdCaUJ2/k4Sa9ULrJST/JgiY5LyG4GfaKYBUVWQ1
B64tR30PGkw0pW0msnhVp4LIlVDiBKppasEoGBD5L1sEqmlqwSgYUjrzC2uVIsfjLNCrjvh3
L4AcKjZf6lYt09Oyjh0no5dLK29tQFFfipjxrW/Ffay87dVNPxSp4nMInYenMhPrCJaUgi/k
5/zQ3eQFKFJHEt8y2CnV2V4NjJU2gcte2LjNWQ2Y6IeLChC31VUJzMvpNLWaW/gkd0vogS4Z
UtjLxDsE6pEEleCdh17wgoA7dto4JANszfPeTkqRPWo4Mdyhw5QkX8tEMZRP5v6zY8hMLRZf
x/EBNWaPyEoEdeNz7Iq5Fv0cF4DGp6AIIm1zm4ijXxhzD3+cAWRVvNrn4tSj1lwge+AXWs5n
GKNDhrsLukNOBJRcP7+s6gtr2onlAjI6684ioeesynGhEcxuGmSBRWjEBXVhBhCqeMmarh69
ruSiGFxuA7V9VFeO1ZFIL7slKCC1iLu3lQW7nFxXh5p1u6ZIPy/ia+tp4ihCwhDqx3rnizJM
i5M9hoBAI7+sQ4O9GUYw3JgH/65zLv5Wk2Ey65BAmN9yDx3ZEfga//ID6bqc+NEkdx4qx49Z
+BTXRS6HyUwIG9yreO5ktatIFciohIv1En1OpTKPF49LCiIoD4iMrZwbnTuaS00JPInvE4iB
lsxUx0yYwGirneQExEBImvy8vaCn9YdZzOmhxyN+IixY2R1BQNneew882p7uTmGTHFlk+D3/
/BMcgbEPQ3m/BHArhywNfmdB0fai5dHUYIPd/wqN6Igcp5oz2NM1kAafv/zOPL/FzlOsp+fE
/

GRANT EXECUTE ON "UTL_FILE" TO PUBLIC;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2008
Added on May 9 2008
3 comments
5,765 views