How to execute the procedure in plsql developer

[prawin62]

Hi,

I have created bellow procedure

"CREATE OR REPLACE PROCEDURE prawin1(registrationid NUMBER, firstname CHAR,
lastname CHAR, email VARCHAR2, dateofbirth date, age NUMBER) IS
BEGIN
INSERT INTO prawin62 VALUES (registrationid, firstname, lastname, email, dateofbirth, age);
END;

when I executed this procedure from sql*plus

new row was added to that table when i checked in that sql* plus

but when I am checking from plsql developer that table was not displaying the newly added rows---- why? ( i have logged out and checked those)

2) how to execute the procedure in plsql developer

I entered the values with using the 'test' that procedure and executed that procedure

but the nothing was updated in the table

can you help me?

Thanks,
Praveen.

 

[Marco Kalter]

but when I am checking from plsql developer that table was not displaying the newly added rows---- why? ( i have logged out and checked those)

Perhaps the inserted record was not yet committed?

2) how to execute the procedure in plsql developer

Right-click on the procedure, select "Test", provide values for the parameter variables, and execute. Again the newly created record must be committed (commit button on the toolbar) before it is visible from other sessions.

 

[prawin62]

Thanks

~Praveen