PL/SQL Archives - Stefan Macke

Oracle: How to call a function from the SQL*Plus command line

Stefan 23. Mai 2011 23. Mai 2011Blog 0

If you would like to verify the result of a function call in Oracle SQL*Plus you could simply include it in a SQL select statement like this: create or replace function testfunction(testparm IN number) return number is begin return(testparm); end testfunction; SQL> select testfunction(123) from dual; TESTFUNCTION(123) —————– 123 SQL>

Oracle: enable UTL_FILE.PUT_LINE to write output to a file

Stefan 29. März 2011 29. März 2011Blog 0

Today I wanted to log some database output to a text file with UTL_FILE.PUT_LINE but when I called this procedure: CREATE OR REPLACE PROCEDURE writeLog(line varchar2) iS file utl_file.file_type; BEGIN file := utl_file.fopen(‘/tmp’, ‘test.txt’, ‘A’); utl_file.put_line(file, line); utl_file.fflush(file); utl_file.fclose(file); dbms_output.put_line(line); END writeLog; it produced an ORA-29280 error: invalid directory path:…

Schlagwort: PL/SQL

Oracle: How to call a function from the SQL*Plus command line

Oracle: enable UTL_FILE.PUT_LINE to write output to a file

Suche

Werbung

Meta