First create a Trigger and with Procedure you insert records. The :new w

If records are inserted into table without committing.How
to refer to these values in a procedure?

Question Posted / swapna

Answer Posted / swapna

First create a Trigger and with Procedure you insert
records.
The :new will take the new values.
So use Triggers in Procedures.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many sectors are in a partition?

1118

How do you explain an index number?

1185

how to enter numeric values as hex numbers? : Sql dba

1101

Advantages and disadvantages of stored procedure?

1167

What is latest version of sql?

1102

how to do backup entire database? : Transact sql

1195

Can function return multiple values in sql?

1098

Can triggers stop a dml statement from executing on a table?

1158

What are inner outer left and right joins in sql?

1059

Can we rename a column in the output of sql query?

1042

how to analyze tables with 'mysqlcheck'? : Sql dba

1061

What is pessimistic concurrency control? : Transact sql

1135

what is dbms? : Sql dba

1036

What is the use of function "module procedure" in pl/sql?

1237

How can we optimize a sql query?

1109