oracleÖÐͨ¹ýʱ¼ä²éѯÄÚÈݵÄÎÊÌâ - Oracle / ¿ª·¢
ÏÂÃæÊÇ.netÉϵĴúÂë
private void button1_Click(object sender, EventArgs e)
{
DateTime GivenDay = DateTime.Parse(SelectDay.Text.Trim());
Fill_dayview(GivenDay);
}
//ÓÃÓÚÉú³ÉÈÕÊÓͼ
private int Fill_dayview(DateTime GivenDay)
{
//Éú³ÉÒ»¸öеÄDataSet
DataSet DS_DayView = new DataSet();
MySchedule DaySchedule = new MySchedule();
if (!DaySchedule.GetScheduleByGivenDay(ref myConn, ref DS_DayView, ref GivenDay))
return -1;
int nScheduleCount = DS_DayView.Tables["ScheduleList"].Rows.Count;
dg_dayview.DataSource = DS_DayView.Tables["ScheduleList"].DefaultView;
return 0;
}
ÏÂÃæÊÇoracleµÄ´úÂ룺
CREATE OR REPLACE PROCEDURE GetScheduleGivenDay (GivenDay date)
as
task_title task.title%type;
task_detail task.detail%type;
task_begintime task.begintime%type;
task_notifytime task.notifytime%type;
task_neednotify task.neednotify%type;
task_finished task.finished%type;
tasktype_typetitle tasktype.typetitle%type;
priority_title priority.prioritytitle%type;
begin
select
task.title,
task.detail,
task.
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
java.sql.SQLException: ORA-04031: unable to allocate 26416 bytes of shared memory ("shared pool","SELECT * from ( SELECT rownu...","Typecheck heap","qry_text : qcpis ......
ÎÒÓÃmyeclipseÁ¬½ÓOracleÒ»Ö±±¨´í£¬Ò»ÏÂÊDZ¨´í½ØÍ¼£¬
Çó¸ßÈËÏàÖú¡£
ÎÞͼÎÞÕæÏà....
file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JDBCÁ¬½Ó´íÎó.png
....
Äã¿´¿´Çý¶¯ºÍORACLEµÄ°æ ......