Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. OracleParameter op = null;
  2. OracleDataReader dr = null;
  3.  
  4. OracleCommand cmd = new OracleCommand();
  5.  
  6. cmd.CommandText = "pkg_prov_index.getNextPanel";
  7. cmd.CommandType = CommandType.StoredProcedure;
  8.  
  9.  
  10. op = new OracleParameter("pCurrentPanelId", OracleDbType.Int32);
  11. op.Direction = ParameterDirection.Input;
  12. op.Value = masterProviderIndex.CurrentPanelId;
  13. cmd.Parameters.Add(op);
  14. op = new OracleParameter("pRefCursor", OracleDbType.RefCursor);
  15. op.Direction = ParameterDirection.inputOutput;
  16. cmd.Parameters.Add(op);
  17. dr =cmd.ExecuteReader(); Here , it gives me an error that says ORA-06550: line 1, column 37: PLS-00201: identifier 'XYZ' must be declared at
  18. if(dr.HasRows)
  19. {while(dr.Read())
  20. {
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement