To writeDeclareT_filename Text_Io.File_Type;w_NewLine varchar2(200); BeginT_filename := Text_Io.Fopen('c:test.txt', 'W');Text_Io.Put_Line(T_filename,'this is test...
You can use host command in 9i/10g which will interact with the Application server's OS. If you want to access the client machine OS then you have to use WEBUTIL functionality
HOST command works fine with Oracle Developer 6i.Since Oracle Developer 9i and 10g are Web-enabled this became obsolete. In replacement of this, you need to install a utility called "Oracle WebUtil". ...
It fires just before SQL * forms the current block.
prachi
Sep 13th, 2006
That master detail trigger name is on-clear-details. so this trigger does not exist atleast in 6 and above versions. don'y know abt lower versions
Parimala
Sep 5th, 2006
Hi, on-clear-block Trigger is an master detail trigger when Master-detail relation block is created and when the master block is cleared, on-clear-block trigger will fire and its functionality is dependent upon the Co-ordination properties of Master-detail block.