Dear All,
Sorry for this silly question.
How to execute a procedure?
Ans: There were couple of ways
1) EXECUTE user.PROCEDURE_NAME;
2) BEGIN
user.PROCEDURE_NAME;
End;
3) Using IDE's(SQL DEVELOPER / TOAD ) run/execute statements.
I have created a stored procedure to load the data from one table to other table and want to execute it. But I am getting no data in the new table, if I run as per above mentioned steps.
Where as the same stored procedure code is working, If I execute it as an anonymous block.
What mistake I am doing here and what should be the check list to correct it.
Thanks for your inputs in advance.
Thanks.,