Per creare e scrivere su un file con PL/SQL č necessario definire abilitare la directory nei parametri di init.ora attraverso il parametro
utl_file_dir, per esempio:
utl_file_dir=c:\tmp
oppure nelle versioni di Oracle pių recenti tramite i comandi
CREATE OR REPLACE DIRECTORY UTL_DIR AS 'c:\tmp';
e la successiva assegnazione dei grant necessari:
GRANT READ ON DIRECTORY UTL_DIR TO PUBLIC;
CREATE OR REPLACE PROCEDURE PRO_WRITEFILE AS
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
-- se l'accesso al filesystem č stato definito da CREATE DIRECTORY specificare solamente il di questa.
fileHandler := UTL_FILE.FOPEN('c:/tmp', 'miofile.txt', 'w');
UTL_FILE.PUTF(fileHandler, 'Questo testo viene scritto dalla procedura\n PRO_WRITEFILE');
UTL_FILE.FCLOSE(fileHandler);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: path non valido o non in INIT.ORA.');
END;
Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131
Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale
Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect