Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\sc\sc

Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\sc\sc_core.js

// SC uses pages 
// 139  Describe
// 1200 Query
// 1201 History
// 1202 Explain
// 1203 Saved Sql
// 1003 Main Page
var g_dObj = '';
var gBindVals = '';
var mill = 0;
var gTid = '';
var gResults = '';
//var gFind = '';
var gNoQueue = '';
var gNoJobs = '';
var g_Running = '';

function RemoveChar(str) {
 charToRemove = '"';
 regExp = new RegExp("["+charToRemove+"]","g");
 return str.replace(regExp,"");
}

function RemoveSemiColon(str) {
 charToRemove = ';';
 regExp = new RegExp("["+charToRemove+"]","g");
 return str.replace(regExp,"");
}

// saves SQL to session state
function sc_postQUERY() {
    // set P1003_SQL_COMMAND2 = P1003_SQL_COMMAND2.Selected text
    sc_getSel();
    var sql = $x("P1003_SQL_COMMAND1").value;
    var sel = $x("P1003_SQL_COMMAND2").value;  
    var tSql = trimAll(sel);
    var schema = $x("P1003_SCHEMA").value;
    var get = new htmldb_Get(null,4500,null,1200);
		get.add('P1003_SQL_COMMAND1',sql);    
    get.add('P1003_SQL_COMMAND2',tSql);
    get.add('P1003_SCHEMA',schema);
    // post values to session
    get.get();  
    // clear all vars
    get = null;
    sql = null;
    sel = null;
    tSql = null;
}

function sc_ClearMessageArea(){html_RemoveAllChildren('htmldbMessageHolder')}

function sc_SetSchemaOnly(){
  	var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=ReturnNothing',0);
    get.add('P1003_SCHEMA',$x("P1003_SCHEMA").value);
    get.get();  
}

function sc_getResults(sessionId){  
  // return if no sql to run
  if ($x("P1003_SQL_COMMAND1").value == "")
    return false;
  sc_getSel();
  // set P1003_SQL_COMMAND2 = P1003_SQL_COMMAND2.Selected text
  var sql = $x("P1003_SQL_COMMAND2").value;
  var sql = RemoveSemiColon(sql);
  var tSql = trimAll(sql);
    var l = sc_EncodedLength(tSql);
  if (l > 32000) {
    // alert('URL Encoded SQL length '+l+' exceeds allowed 32k limit');
     alert('URL Encoded SQL length exceeds allowed 32k limit');
     return;
  }

// test for desc stmt
  if ( tSql.substring(0,4).toUpperCase() == 'DESC' ) {
    html_TabClick($x('describe_tab'),'describeHolder'); 
    var dSql = trimAll(tSql.substring(tSql.indexOf(' ')));
    var dSql = RemoveSemiColon(dSql);
    if (dSql != '' ) {
      g_dObj = dSql;
    }
    sc_getDesc();
    tSql = null;
    sql = null;
    dSql = null;
    $x("resultsHolder").innerHTML = '';
    return
  }
  // end describe test
  sc_clearResults();
  // check for bind values   
  var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=sc_getBind',0);
   get.add('P1003_SQL_COMMAND2',tSql);
  gResults = get.get();
  get = null;
  // end check for binds
  if (gResults == '') { 
    // no binds process sql
    gBindVals = '';
    var pCall = 'sc_DisplayRes()';
    setTimeout(pCall,1);
  } else {
    // binds exist get values via popup
    gResults = null;
    var url = 'f?p=4500:138:'+sessionId+':::';
    popUpNamed(url,'bindLov');
  }
}
    
function sc_getDesc(dFetch){
    var lObj = '';
    var lUser = '';
    var Upperobj = '';
    var holder = '';
    holder = $x("describeHolder");  
    schema = $x("P1003_SCHEMA").value;
    if (g_dObj && g_dObj.indexOf('"') == -1 ) {
      Upperobj = trimAll(g_dObj.toUpperCase());
    } else {
      Upperobj = trimAll(RemoveChar(g_dObj));
    }
    if (Upperobj.indexOf('.') > 0) {
      lUser = Upperobj.substring(0,Upperobj.indexOf('.'));
      lObj = Upperobj.substring(Upperobj.indexOf('.')+1);
      lAct = 'HAVE';
    } else {
      lObj = Upperobj;
      lUser = schema;
      lAct = 'GET';
    }
    var get = new htmldb_Get(null,4500,null,139);        
     get.add('P1003_SCHEMA',schema);
     get.add('P139_OBJECT',lObj);
     get.add('P139_OWNER',lUser);
     get.add('P139_ACTION',lAct);
    gResults = get.get(null,'<htmldb:BOX_BODY>','</htmldb:BOX_BODY>');
    get = null;
    var holder = $x("describeHolder"); 
    holder.innerHTML = gResults;
    $x("P1003_SQL_COMMAND1").focus();
    cDebug(gResults)
    gResults = null;
    var obj = null;
    var Upperobj = null;
    var holder = null;
    var sql = null;
    var tSql = null;
}

function sc_postBind(bindVals){
    opener.gBindVals = bindVals;
    opener.sc_DisplayRes();
    close();
}

// used to generate sql when clicking on links in desc tab
function sc_getSQL(objName){
    var l_owner = '';
    var l_pack  = '';
    var l_proc  = '';
    var foo = objName.split('.');
    if (foo.length == 1) {
      l_owner = foo[0];
    } else if (foo.length == 2) {
      l_owner = foo[0];
      l_pack  = foo[1];
    } else if (foo.length == 3) {      
      l_owner = foo[0];
      l_pack  = foo[1];
      l_proc  = foo[2];
    }
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=sc_buildSql',0);
    if (l_owner != '' ) {
        get.add('P139_OWNER',l_owner);
    }
    if (l_proc != '') {
        get.add('P139_OBJECT',l_pack+'.'+l_proc);
    } else {
        get.add('P139_OBJECT',l_pack);
    }        
    gResults = get.get();
    ret_Column(trimAll(gResults));
    get = null;
    gResults = null;
    l_owner = null;
    l_pack  = null;
    l_proc  = null;
    foo = null;
}

// this will only ever be called from sc_DisplayRes()
function sc_DisplayRes2() {
      var sqlHolder = $x("dSQLResult");
      var pipeHolder = $x("DBMS_OUTPUT_DIV");
      var dResult = '';
      var dDbms = '';
      sqlHolder.innerHTML = sqlHolder.innerHTML+'.';
      dResult = sc_readOut(gTid);
      if (dResult.indexOf('HTMLDB:NONE') > -1 ) {
        setTimeout("sc_DisplayRes2()",1000);
        return false;
      } else {
        sqlHolder.innerHTML = dResult;
        dDbms = sc_readDbms(gTid);
        pipeHolder.innerHTML = dDbms;
        if (dDbms.indexOf('HTMLDB:NONE') == -1 ) {
          $x('R137341724550811368').id = $x('R137341724550811368').id + '_show';
        }
      }
    $x("P1003_SQL_COMMAND1").focus();
    sqlHolder = null;
    pipeHolder = null;
    dResult = null;
    dDbms = null;
}

function sc_getPlan(){
    var results = '';
    sc_getSel();
    var holder = $x("explainHolder");  
    var sql = $x("P1003_SQL_COMMAND2").value;
    var tSql = trimAll(sql);
    var schema = $x("P1003_SCHEMA").value;
    var get = new htmldb_Get(null,4500,null,1202);        
    get.add('P1003_SQL_COMMAND2',tSql);
    get.add('P1003_SCHEMA',schema);
    results = get.get(null,'<htmldb:BOX_BODY>','</htmldb:BOX_BODY>');
    holder.innerHTML = results;      
    $x("P1003_SQL_COMMAND1").focus();
    get = null;
    results = null;
    holder = null;
    sql = null;
    tSql = null;
    schema = null;
}

// Used for getting SQL command from selection
function sc_getSel() { 
 if (document.selection) {
   //IE support for inserting HTML into textarea
   var sel = document.selection;
   var rng = sel.createRange();
   var seltxt = trimAll(rng.text);
   if (rng.text == null || rng.text == "") {
     $x('P1003_SQL_COMMAND2').value = $x('P1003_SQL_COMMAND1').value; 
   } else {
     $x('P1003_SQL_COMMAND2').value = seltxt;
   }
 } else  {
  // Mozilla/Netscape support for selecting textarea
  cmd = $x('P1003_SQL_COMMAND1');
  start = cmd.selectionStart;
  end = cmd.selectionEnd;   
  sel = (cmd.value).substring(start, end);  
  if (sel == null || sel == "" ) {
    $x('P1003_SQL_COMMAND2').value = $x('P1003_SQL_COMMAND1').value;
  }  else {
    $x('P1003_SQL_COMMAND2').value = sel;      
  }
 }
}

function sc_PageInit(){
  db_Resize();
  window.onresize = function(){db_Resize()};
  sc_initSlide();
  var cFlag = $x("P1003_AUTOCOMMIT_0").checked;
   if (!cFlag) 
    sc_createJob();
  cFlag = null;  
  $x("P1003_SQL_COMMAND1").focus();
  var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=get_message',0);
  get.add('SYSTEM_MESSAGE','NO_JOB_QUEUE_PROCESSES');
  gNoQueue = get.get();
  get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=get_message',0);
  get.add('SYSTEM_MESSAGE','NO_AVAIL_JOBS');
  gNoJobs = get.get();
  get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=get_message',0);
  get.add('SYSTEM_MESSAGE','SC_SQL_RUNNING');
  g_Running = get.get();
}

function sc_callResultPopup(sessionId, resultId) {
  var url = 'f?p=4500:1223:' + sessionId + ':::1223:P1223_ID:' + resultId;
  popupURL (url);
}

function sc_returnSQL(){
   var ret = $x("P1003_RETURN_INTO").value;
	 sc_getSel();
	 opener.$x(ret).value = $x("P1003_SQL_COMMAND2").value;
   ret = null;
   window.close();
}

function sc_toggleJob(obj) {
    $x("P1003_SQL_COMMAND1").focus();
    if (obj.checked) {sc_removeJob();}
		else {sc_createJob();}
}

function sc_removeJob() {
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=sc_remove_job',0);
    gResults = get.get();
    get = null;
    gResults = null;
	  sc_ClearMessageArea()
}

function sc_readOut(pTid) {
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=sc_read_out',0);
    get.add('P1200_STMT',pTid);
    gResults = get.get();
    get = null;
    return gResults;
}

function sc_readDbms(pTid) {
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=sc_read_dbms',0);
     get.add('P1200_STMT',pTid);
    gResults = get.get();
    get = null;
    return gResults;
}

function sc_sendSql(pType) {
    var sql = $x("P1003_SQL_COMMAND2").value;
    var rows = $x("P1003_ROWS").value;
    var tSql = trimAll(sql);
    var schema = $x("P1003_SCHEMA").value;
    var get = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=sc_sql_trans',0);
     get.add('P1003_SQL_COMMAND2',tSql);
     get.add('P1003_AUTOCOMMIT','N');
     get.add('P1003_SCHEMA',schema);
     get.add('P1003_ROWS',rows);
     get.add('P1200_TYPE',pType);
     if (gBindVals != '') 
       get.add('P1200_BIND_VALS',gBindVals);
    gResults = get.get();
    sql = null;
    rows = null;
    tSql = null;
    schema = null;
    get = null;
    return parseInt(gResults);
}

function sc_CancelSave(){
	html_RemoveAllChildren('htmldbMessageHolder');
	sc_close('saveDialog');
	}

function sc_popup(id){
	var t = sc_cascadeUpUntil($x(id),'TABLE');
    t.closable='1';
    t.movable  = '1';
    html_ShowElement(t);	
    sc_Centerme(t);
    t = null;
    if(id=='saveDialog'){$x('P1003_SAVE_NAME').focus();}
}

function sc_Centerme(id){html_Centerme(id)}

function sc_close(id){
  var t = sc_cascadeUpClose($x(id),'TABLE');
  html_HideElement(t);
  t = null;
  html_enableBase();
}

function sc_postHistory(historyId,qSchema){
  $x("P1003_SAVE_NAME").value = '';
  $x("P1003_SAVE_DESC").value = '';
  $x("P1003_QUERY_ID").value = '';
  $x("P1003_SCHEMA").value = qSchema;
  var geter = new htmldb_Get(null,4500,'INTERNAL_APPLICATION_PROCESS=sc_posthistory',0);  
    geter.add('P1201_HISTORY_ID',historyId);
  var sql = geter.get('FULL');  
  var e2 = $x('P1003_SQL_COMMAND1');
  e2.value = sql;
  sql = null;
  e2.focus();
  geter = null;
  return;  
}

function sc_clearResults(){
 if ($x("resultsHolder")){$x("resultsHolder").innerHTML = g_Running;}
}

/* static for saved sql PPR*/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de