Director read write file operations

declare

l_file UTL_FILE.file_type;

fileHandler UTL_FILE.FILE_TYPE;

l_location VARCHAR2(100) := '';

l_text VARCHAR2(32767);

mesaj VARCHAR2(32767);

l_filename VARCHAR2(100) := '';

l_filename_output VARCHAR2(100) := '';

asd VARCHAR2(32767);

begin

mesaj:=' ';

l_file := UTL_FILE.fopen(l_location, l_filename, 'r', 32767);

LOOP

UTL_FILE.get_line(l_file, l_text, 32767);

--DBMS_OUTPUT.PUT_LINE(l_text);

--mesaj:=mesaj||l_text||', '', '||chr(13) || chr(10)||' ';

END LOOP;

UTL_FILE.fclose(l_file);

fileHandler := UTL_FILE.FOPEN(l_location,l_filename_output, 'w');

UTL_FILE.PUTF(fileHandler, mesaj);

UTL_FILE.FCLOSE(fileHandler);

EXCEPTION

WHEN OTHERS THEN

NULL;

end;

Oracle Plsql Injection

http://pages.kivancg.com/OraclePLSQLInjection.ppt

Türkçe Oracle white paper

http://pages.kivancg.com/Oracle_VTYS_Giris.pdf

Cursor in Cursor

DECLARE

CURSOR cur_log IS SELECT PK_VALUES, COLUMNS_HEADER, COLUMNS_OLD_VALUE,COLUMNS_NEW_VALUE FROM XXTEB_AUDIT_LOG WHERE PK_VALUES=202;

BEGIN

FOR cur_log_rec IN cur_log LOOP

DECLARE CURSOR cur_result IS SELECT h.COLUMNVAL as Header, nv.COLUMNVAL as NewValue, ov.COLUMNVAL as OldValue

FROM TABLE(CAST (XXTEB_STR2TBL (cur_log_rec.COLUMNS_HEADER,'|') AS XXTEB_TABLE)) h

JOIN TABLE(CAST (XXTEB_STR2TBL (cur_log_rec.COLUMNS_NEW_VALUE,'|') AS XXTEB_TABLE)) nv ON nv.ROWNO=h.ROWNO

JOIN TABLE(CAST (XXTEB_STR2TBL (cur_log_rec.COLUMNS_OLD_VALUE,'|') AS XXTEB_TABLE)) ov ON ov.ROWNO=nv.ROWNO

WHERE 1=1;

BEGIN

FOR cur_result_rec IN cur_result LOOP

dbms_output.put_line (cur_result_rec.Header||';'||cur_result_rec.OldValue||';'||cur_result_rec.NewValue);

END LOOP;



END;

END LOOP;

END;

Redo Undo difference

http://askthekg.googlepages.com/Haisley.pdf

Document Library view document problem

Problem solved:
It is not mentioned in Document Library Readme.

Here is what I need to do:
edit following function in flow_ schema

wwv_flow_epg_include_mod_local

and
comment out this line
-- return false;

and

Modify following line and change your schema_name and then compile function.


if upper(procedure_name) in (
'GET_DOC','SCHEMA_NAME.GET_DOC

') then
return TRUE;

send email from database utl smtp

alter system set smtp_out_server = ':25' scope=both;

exec utl_mail.send(sender => 'sender@sender.com', recipients => 'kivancg@gmail.com', subject => ‘Testing UTL_MAIL Option’, message => ‘blah blah blah’);