PL\SQL Developer: Stored procedure availibility delay
810295Nov 9 2010 — edited Nov 9 2010Hello,
I'm new in Oracle world and have an issue. I use PL\SQL Developer 7.1 on my desktop machine. Oracle database is 11g and it's located on remote server.
There's a strange behavior for me. When I write stored procedure, I'm able to execute it right away using PL\SQL Developer and it's, of course, expected. All is fine.
Also, I have the application written in C# (VS2010) that calls the same stored procedure. The problem is I can't use the stored procedure right after it's been written. When I try to use it, this error appears:
ORA-06550: Row 1, Column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_INTEGER'
ORA-06550: Row 1, Column 7:
PL/SQL: Statement ignored
The stored procedure becomes available next day, which means it works and there's no error. It happens with all stored procedures. I use Oracle Data Provider for .NET, version 4.112.1.2.
I suppose there's something simple that I'm not aware of.
Could you, please, let me know what's going on and how to resolve this issue?
Thank you in advance.
Goran
Edited by: 807292 on 08.11.2010 23:28