Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- OracleParameter op = null;
- OracleDataReader dr = null;
- OracleCommand cmd = new OracleCommand();
- cmd.CommandText = "pkg_prov_index.getNextPanel";
- cmd.CommandType = CommandType.StoredProcedure;
- op = new OracleParameter("pCurrentPanelId", OracleDbType.Int32);
- op.Direction = ParameterDirection.Input;
- op.Value = masterProviderIndex.CurrentPanelId;
- cmd.Parameters.Add(op);
- op = new OracleParameter("pRefCursor", OracleDbType.RefCursor);
- op.Direction = ParameterDirection.inputOutput;
- cmd.Parameters.Add(op);
- 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
- if(dr.HasRows)
- {while(dr.Read())
- {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement