Executing Stored Procedure Fails with 'Stored Procedure doesn't exist' message
------------------------------------------------------------------------------
Key: DNET-517
URL: http://tracker.firebirdsql.org/browse/DNET-517
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 3.1.1.0
Environment: Windows 8 Pro 64 bit, Visual Studio 2012
Reporter: Cecil Martin
Assignee: Jiri Cincura
Priority: Critical
When executing a stored procedure, the provider returns an error stating the
stored procedure doesn't exist. Error occurs when trying to execute command as
type StoredProcedure or Text. Following are stack trace messages:
Using fbcommandbuilder.deriveparameters to derive parameters for stored
procedure:
Error:
Stored procedure doesn't exist.
Stack Trace:
at
FirebirdSql.Data.FirebirdClient.FbCommandBuilder.DeriveParameters(FbCommand
command) in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommandBuilder.cs:line
71
at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime
execTime, String theUser, Int32 JobId, Int32 JobsId) in
C:\Users\cmartin\Documents\Visual Studio
2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 376
at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual
Studio
2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line
44
And for executing as "execute procedure sp_jobq_add(?,?,?,?,?,?)":
Error:
Dynamic SQL Error
SQL error code = -204
Procedure unknown
SP_JOBQ_ADD
Stack Trace:
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in
c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line
520
at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime
execTime, String theUser, Int32 JobId, Int32 JobsId) in
C:\Users\cmartin\Documents\Visual Studio
2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 396
at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual
Studio
2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line
44
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
