C＃调用oracle存储函数 [英] C# call oracle stored function

问题描述

create or replace function ar_knyga_egzistuoja(
id number
)
return number
is
kiekis number;
begin
select count(*) into kiekis from knygos where kn_id  = id;
return kiekis;
end;

C＃代码：

C# code:

conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "ar_knyga_egzistuoja";

cmd.CommandType = CommandType.StoredProcedure;
OdbcParameter param = new OdbcParameter();

cmd.Parameters.Add("id", OracleType.Number).Value = id;

cmd.ExecuteNonQuery();
var kiekis = Convert.ToString(cmd.Parameters["kiekis"].Value);

MessageBox.Show(kiekis);

cmd.Parameters.RemoveAt(0);

conn.Close();

我收到错误：

I getting error:

PLS-00221: 'AR_KNYGA_EGZISTUOJA' is not a procedure or is undefined
ORA-06550: line 1, column 7:

这是不是程序，但功能，但我知道的功能，我可以打电话喜欢的程序，有什么不好？

This is not procedure but function, but I know that function I can call like procedures, what is wrong ?

推荐答案

你的 ORA-06550 代码表示函数的编译使用无效的声明并需要重新编写。我没有看到任何明显错误的代码，所以你可能有这样的权限或不正确的表名的问题，应该检查是否可以首先运行一个PL / SQL编辑器的功能。然后，你得到的运行后，尝试...

The ORA-06550 code you get means that the function was compiled with invalid statements and needs to be re-written. I'm not seeing anything obviously wrong with the code so you might have issues like permissions or incorrect table names and should check if you can run the function in a PL/SQL editor first and foremost. Then, after you get that running, try...

var cmd = new OracleCommand();

cmd.Connection = conn;
cmd.CommandText = "ar_knyga_egzistuoja";
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("id", id);
cmd.Parameters.Add("kiekis", OracleType.Number);
cmd.Parmeters["kiekis"].Direction = ParameterDirection.ReturnValue;

cmd.Connection.Open();
cmd.ExecuteNonQuery();

var kiekis = Convert.ToString(cmd.Parameters["kiekis"].Value);

MessageBox.Show(kiekis);
cmd.Connection.Close();

这应该能够运行的功能就像一个存储过程，同时期待名为<$ C返回值$ C> kiekis 键入 号可用于工作。

This should be able to run the function like a stored procedure while expecting a return value named kiekis of type number to be available for work.

这篇关于C＃调用oracle存储函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！