如何使用匿名pl/sql块

[百战天王]

比如这样一句
declare
vDEST_LOB blob;
n number;
Begin
select a.image into vDEST_LOB from tb_image a where a.id='123';
n:= DBMS_LOB.GetLength(vDEST_LOB);
end;

在CommandText里怎么设置参数，才能传出n？

[皇城龙三]

public   static   int   ExecuteNonQuery(string   commandText){   
  private   SqlCommand   command   =   new   SqlCommand();   
  command.Connection=new   SqlConnection(connectionString);   
  if(command.Connection.State   ==System.Data.ConnectionState.Closed)   
  {   
  command.Connection.Open();   
  }   
  command.CommandText   =   commandText;   
  int   result=-1;   
  try{   
  result=command.ExecuteNonQuery();   }   
  catch   (Exception   e)   
  {   
  throw   e;   
  }   
  finally   
  {   
  command.Connection.Close();   
  }   
  return   result;   
  }   
    

[百战天王]

顶一下

[zsuswy]

设置输出参数， outputparameter

[yuanhuiqiao]

Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)
    Try
        Dim oracleConnection1 As OracleConnection = New System.Data.OracleClient.OracleConnection()
        oracleConnection1.ConnectionString = "user id=sb;data   source=sbprod;password=sb"
        Dim Procedure As String = "yourProcedure"
        Dim dacommand As New System.Data.OracleClient.OracleCommand(Procedure, oracleConnection1)
        oracleConnection1.Open()
        dacommand.CommandType = CommandType.StoredProcedure
        
        Dim inputParameter As New OracleParameter("vDEST_LOB", OracleType.Blob, 4)
        inputParameter.Direction = ParameterDirection.Input
        dacommand.Parameters.Add(inputParameter)
        'inputParameter.Value =  yourValue;
        Dim outputParameter As New OracleParameter("n", OracleType.Number, 4)
        outputParameter.Direction = ParameterDirection.Output
        outputParameter.Value = "2"
        dacommand.Parameters.Add(outputParameter)
        dacommand.ExecuteNonQuery()
            
        oracleConnection1.Close()
    Catch
        Throw
    End Try
End Sub

[百战天王]

在CommandText里怎么设置参数，才能传出语句里的结果n:= DBMS_LOB.GetLength(vDEST_LOB);