电梯直达

1楼 [收藏(0)] [报告]

发表于 2007-07-26 16:05 |只看该作者 |倒序浏览

#!/bin/bash
cat <<__EOF__
Content-type: text/html; charset=GB2313
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>Customer Profile</title>
<script LANGUAGE="JavaScript">
function getAWB()
{
var flightNbrDt = document.fm1.flightNbrDt.value;
__EOF__
sqlplus -S $ORAUSR<<DB_EOF >/home/fgc/bin/import/report/conpage/tmp
set serveroutput on size unlimited
set linesize 500
set tab off
set heading off
DECLARE
M_AWB DECLGRPMAWB.MAWB%TYPE;
CURSOR CURSOR_MAWB IS
SELECT
MAWB
FROM
ACCS.declgrpmawb
WHERE
declgrpoid = (SELECT
DECLGRPOID
FROM
DECLGRP
WHERE
GROUPNUMBER = 'CA969'
AND
GROUPDATE = '26-JUL-07');
BEGIN
DBMS_OUTPUT.PUT_LINE('kkk');
OPEN CURSOR_MAWB;
LOOP
FETCH C_MAWB INTO M_AWB;
EXIT WHEN C_MAWB%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('document.fm1.mawb.value=oookkk');
END LOOP;
CLOSE CURSOR_MAWB;
DBMS_OUTPUT.PUT_LINE('dok');
/
DB_EOF
cat <<__EOF__
alert('done');
}
....
__EOF__