我几乎可以确定这是用户错误。
我刚开始连接C#到Oracle数据库,已经按照Oracle在线文档的代码进行建模。我的PL/SQL在Oracle SQL Developer中可以正常运行。但在test.aspx页面中,我遇到了如下错误:
ORA-00922:缺少或无效的选项
test.aspx.cs页面的后台代码为:
我刚开始连接C#到Oracle数据库,已经按照Oracle在线文档的代码进行建模。我的PL/SQL在Oracle SQL Developer中可以正常运行。但在test.aspx页面中,我遇到了如下错误:
ORA-00922:缺少或无效的选项
test.aspx.cs页面的后台代码为:
string currentTerm = getCurrentTerm();
string passwd = "<get password input>";
string salt = "<get salted input>";
conn.ConnectionString = ConfigurationManager.ConnectionStrings["CONNECTIONSTRINGNAME"].ConnectionString;
conn.Open();
// pl/sql block
string pl_sql = " set serveroutput on " +
"DECLARE"+
" output tablename.function%TYPE;" +
"BEGIN"+
" tablename.myfunction(:1,:2,:3);" +
" dbms_output.put_line('output= '||output"+
"END;";
//Oracle Parameters necessary for the myfunction function
OracleParameter p_1 = new OracleParameter(passwd, OracleDbType.Varchar2, 50, ParameterDirection.Input);
OracleParameter p_2 = new OracleParameter(salt, OracleDbType.Varchar2, 50, ParameterDirection.Input);
OracleParameter p_3 = new OracleParameter("3", OracleDbType.Varchar2, 50, ParameterDirection.Output);
// create the command object
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = pl_sql;
// add the parameters
cmd.Parameters.Add(p_1);
cmd.Parameters.Add(p_2);
cmd.Parameters.Add(p_3);
// execute the pl/sql block
cmd.ExecuteNonQuery();
// get a data reader from the ref cursor
// note: this is on p_3, the output value
OracleDataReader dr = ((OracleRefCursor)p_3.Value).GetDataReader();
while (dr.Read())
{
Response.Write("Salt licked hash: "+ dr[0].ToString());
//Output the line retrieved from dbms_output.put line
Response.Write("<br />");
Response.Write("DBMS_OUTPUT STATUS: "+ p_3.Value.ToString());
}
REDACTED_TABLE
是一个函数名,那么在第130行和第77行有什么内容? - Justin Cavecode
//Oracle Parameters necessary for the myfunction function OracleParameter p_1 = new OracleParameter(passwd, OracleDbType.Varchar2, 2000, ParameterDirection.Input); OracleParameter p_2 = new OracleParameter(salt, OracleDbType.Varchar2, 2000, ParameterDirection.Input); OracleParameter p_3 = new OracleParameter(output, OracleDbType.Varchar2, 2000, ParameterDirection.Output); - Geekender