Oracle Error 20055
File [message #446129] Fri, 05 March 2010 09:18 wtolentino Messages: 196Registered: March 2005 Senior Member i have a procedure that reads a file from a server. this works in all tiers except for the production, which when we recently migrated the procedure in production and run it from there it appears to be failing. because i do not have access to production tier i have asked our database administrator to run the debug script to diagnose the issue. set servertoutput on; declare pFileName varchar2(80) := 'marchiselli.txt'; vSFile utl_file.file_type; -- source file vNewLine VARCHAR2(200); -- line of character strings vLineCtr number := 0; -- line counter begin vSFile := utl_file.fopen('DIR_MRCH_IN', pFileName,'r'); if utl_file.is_open(vSFile) then dbms_output.put_line('read file '||pFileName||' success'); end if; utl_file.fclose(vSFile); exception when utl_file.invalid_mode then RAISE_APPLICATION_ERROR (-20051,'Invalid Mode Parameter'); when utl_file.invalid_path then RAISE_APPLICATION_ERROR (-20052,'Invalid File Location'); when utl_file.invalid_filehandle then RAISE_APPLICATION_ERROR (-20053,'Invalid Filehandle'); when utl_file.invalid_operation then RAISE_APPLICATION_ERROR (-20054,'Invalid Operation'); when utl_file.read_error then RAISE_APPLICATION_ERROR (-20055,'Read Error'); when utl_file.internal_error then RAISE_APPLICATION_ERROR (-20057,'Internal Error'); when utl_file.charsetmismatch then RAISE_APPLICATION_ERROR (-20058,'Opened With FOPEN_NCHAR But Later I/O Inconsistent'); when utl_file.file_open then RAISE_APPLICATION_ERROR (-20059,'File Already Opened'); when utl_file.invalid_maxlinesize then RAISE_APPLICATION_ERROR(-20060,'Line Size Exceeds 32K'); when utl_file.invalid_filename then RAISE_APPLICATION_ERROR (-20061,'Invalid File Name'); when utl_file.access_denied then RAISE_APPLICATION_ERROR (-20062,'File Access Denied By'); when utl_file.invalid_offset then RAISE_APPLICATION_ERROR (-20063,'FSEEK Param Less Than 0'); when others then --RAISE_APPLICATION_ERROR(-20099, 'Unknown UTL_FILE Error'); raise_application_error (-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); end; / when the code above is run from the development and test tier it was success: read file marchiselli.txt success PL/SQL procedure successfully completed. however in production tier it
script for Oracle alert log on Windows If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Alert script for Oracle alert log on Windows Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch http://www.orafaq.com/forum/t/155708/ to Hybrid Mode Switch to Threaded Mode 10-23-2006,06:21 AM #1 Chucks_k View Profile View Forum Posts Senior Member Join Date Dec 2001 Posts 337 Alert script for Oracle alert log on Windows Hi all, Can anyone point me in the direction of a VBScript alert log monitoring script in a Windows envirmonent? Have done a search and seen mostly alert script which http://www.dbasupport.com/forums/showthread.php?53081-Alert-script-for-Oracle-alert-log-on-Windows email errors in the alert log on a Unix env, would like something similar for a Windows env! Thanks in advance, Chucks Reply With Quote 10-24-2006,07:27 AM #2 JMac View Profile View Forum Posts Red Boy of Differdange Join Date Jan 2000 Location Chester, England. Posts 818 I use DBMS_JOB to run a package every 5 mins to check the alert log. This uses UTL_FILE to read the alert log and UTL_SMTP to email me. And it works too! Reply With Quote 10-24-2006,09:41 AM #3 Chucks_k View Profile View Forum Posts Senior Member Join Date Dec 2001 Posts 337 I am not too pl/sql savvy, would it be possible to have a look and use the code pls? Reply With Quote 10-24-2006,11:08 AM #4 JMac View Profile View Forum Posts Red Boy of Differdange Join Date Jan 2000 Location Chester, England. Posts 818 The procedure to send the mail is: PROCEDURE SEND_MAIL IS (p_recipient IN VARCHAR2, p_sender IN VARCHAR2, p_sender_text IN VARCHAR2, -- Appear in e-mail as 'From:' p_subject IN VARCHAR2, p_message IN VARCHAR2) AS c utl_smtp.connection; v_msg_string VARCHAR2(4000); -- BEGIN c := utl_smtp.open_
SonicWALL User Sorry, we are having issues processing your request. If you https://support.software.dell.com/spotlight-on-oracle/kb/20055 own the SonicWALL product requested please confirm that you have registered your product at My SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary oracle error unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue Search Sign In Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all oracle error 20055 Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My