Oracle Database Discussions

Hi all,

Hope somebody can help me.

First of all, I am new to Oracle. I am working on a C# project where I am using the Entity Framework. I created three stored procedures to insert, update, and delete records from the database. After properly mapping the stored procedures to the corresponding table, within the project and running some tests, only the insert and delete stored procedures work. When I execute the update, everything seems to work fine, but the record is not updated. Second, in MS SQL Server I use the SQL Server Management Studio console to create and test a stored procedure by using the "EXEC StoreProcedueName". How do I test a stored procedure in Oracle? I want to make sure the stored procedure runs fine outside of Visual Studio.

Any help would be greatly appreciated.

Thanks in advance.