Recent content by Mousstifay

Hi! For those who knows, i am using the utility oracle trace collecte( otrccol) which create a .dat file which grows by collecting data from the database. The Oracle bug imposed a limit of 2Go size of this collection file. Is it possible to zip this file while is growing so that it never...

Hi! I want to know how to mail a log file from a shell script to a netscape or other mail address.. Thanks you guys!

it just create a ".sql" file i launch using sqlplus. it contains this lines: echo "set serveroutput ON SIZE 1000000" > tr_appel_sqlplus.sql echo "set echo off" >> tr_appel_sqlplus.sql echo "set termout off" >> tr_appel_sqlplus.sql echo "set feedback off" >> tr_appel_sqlplus.sql echo...

Thanks for the answer. Regards with my first question, i'll explain it using your example: I have already created the cursor.What i expect to do is the return all the value to my shell script: For example: I call this procedure from my shell this way . tr_appel_sqlplus.sh...

You mean Oracle release 8i?

Hi! I have in fact two questions...I am a beginner in the field an i want to know how to pass values return by a cursor in PL/SQL functions to my shell script and indeed threat them one by one ... My second question is that i am not able to write comments during my shell script using this the...

Hi! I have in fact two questions...I am a beginner in the field an i want to know how to pass values return by a cursor in PL/SQL functions to my shell script and indeed threat them one by one ... My second question is that i am not able to write comments during my shell script using this the...

Hi everybody! Here is my question and thanks for the answers. I am checking from a table via a PL/SQL function the contents of a table: function Main_chargement_dmt return number is Le_chg_v TR_CHG_DMT%rowtype; Ln_Code_Retour number; Ex_Erreur_Appel_Fonction Exception; BEGIN...