SQL code
- Create Or Replace ProcedureP_outputdebug (a varchar2, B varchar2, c varchar2)
- Is
- VFileName varchar2 (100 );
- OutputFile UTL_FILE.FILE_TYPE;
- Begin
- Select 'Rfid _'| A. rfid |'. Log'
- IntoVFileName
- FromTbl_animal_infoWhereA. rfid ='123'
- ;
- OutputFile: = utl_file.fopen ('Background _ dump_dest', VFileName,'A');
- Utl_file.putf (OutputFile, a, B, c );
- Utl_file.fflush (OutputFile );
- Utl_file.fclose (OutputFile );
- End;
- SQL>Create Or ReplaceDirectory"Background_dump_dest"As 'D: \ database \ cares100 \ bdump';
- Directory created
- SQL>Grant Read OnDirectory"Background_dump_dest" ToMyuser;
- GrantSucceeded
- SQL>GrantWriteOnDirectory"Background_dump_dest" ToMyuser;
- GrantSucceeded
- SQL> call myuser. p_outputdebug ('1','1','1');
- Method called
- -- Note that the log directory must be created on the server where Oracle is located; otherwise, an error is returned.
For usage of UTL_FILE.FOPEN, see