-
-
-
-
how to avoid the mutating error with sample program
Hi, can any body give me the sample program for avoiding the mutating error. we can avoid the mutating through the statement level trigger instead of using the statement leve trigger, i need one sample program to avoid the mutating error by using pl/sql table.Thanks Saravanan.P
-
PL/SQL Procedure Send mail problem
Hi all I wrote a procedure to send email via plsql procedure, It was compiled successfully but not working .... here is the code (actuly i added the dbms output like step1 ,step 2 to see in which step the control is going on ) {geshibot language="PL/SQL"}create or replace PROCEDURE send_test_message IS mailhost VARCHAR2(64) := 'mail.cmcltd.com'; sender VARCHAR2(64) := 'akash.sharma@cmcltd.com'; recipient...
-
-
Give the structure of the procedure ?
PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;