sqlplus system/111111@localhost:1522/进入oracle
create user GDB identified by GDB_PWD; 创建用户
grant all privileges to GDB;
dr 删除用户
log 在终端显示
sqlplus sys/111111@localhost:1522
grant execute on utl_http to GDB;
select * from dba_data_
alter tablespace USERS add datafile ‘/u01/app/oracle/oradata/(XE)…./users01.dbf’ size 10240M;
alter tablespace USERS drop datafile ‘/u01/app/oracle/oradata/XE/sysaux.dbf’;
drop tablespace USERS including co
~/.bashrc 添加环境变量
CONSTRUCTOR FUNCTION GetContractInventoryDetails RETURN SELF AS RESULT AS
BEGIN NULL; RETURN; END GetContractInventoryD
TO_TIMESTAMP_TZ(‘08/13/2015’,’mm/dd/yyyy’)
grep -ih ‘create table’ table.sql &droptable.sql
Instr()函数返回字符或字符串在另一个字符串中第一次出现的位置
date -d “(awk&-F.&'{print1}’ /proc/uptime) second ago” +”%Y-%m-%d %H:%M:%S”
IGNORE_PLS_INTEGER(l_tmp_7.getobject(l_var_vpn_routing));
将 l_tmp_7 类型 转成 l_var_vpn_routing 类型的值(复杂类型装换）
Anydata.convertObject(l_var_connection ) 将 l_var_connection 复杂类型的值 转成 anydata
IGNORE_PLS_INTEGER (l_res_n_list(i).getCollection (l_tmp_list(array) )); 将 l_res_n_list里的值传给l_tmp_list
need extend
l_offer_data := AnydataList();
l_offer_data.extend(l_offer_data_t.COUNT);
for i in 1..l_offer_data_t.COUNT
l_offer_data(i):=AnyData.CONVERTVARCHAR2(l_offer_data_t(i));
l_process .get_response().getTypeName()
IF l_tmp IS NOT NULL AND l_tmp.COUNT &0 THEN
l_function_type_list := FunctiontypeArray();
for i in 1..l_tmp.COUNT
l_function_type_list.EXTEND;
IGNORE_PLS_INTEGER(l_tmp(i).getObject(l_function_type_list(l_function_type_list.COUNT)));
l_loc_addr_site_id_array := LocationsiteaddressidtypeArray();
l_loc_addr_site_id_array.
l_loc_addr_site_id_array(l_loc_addr_site_id_array.count):=l_loc_addr_site_
p_site_addr_list.set_loc_site_addr_id(l_loc_addr_site_id_array);
exception when others THEN
dbms_output.put_line(‘exception!’);
dbms_output.put_line(‘error message: ‘||sqlerrm);
dbms_output.put_line(‘error position: ‘||dbms_utility.format_error_backtrace);
2015-AUG-10 12:18:20
fetch l_cr into l_
EXIT WHEN l_cr%NOTFOUND;
l_result(l_result.COUNT) := Anydata.convertvarchar2(l_equip);
WHEN DataNotFoundException
log_debug ((‘debug’) || ‘: ’
|| (‘Caught Data Not Found Exception from GetAsset!!!!No rethrow here!!!’
|| SQLERRM ));
log_vistit改成
log_debug (‘contract_discount_to_gcsm:’||l_pstmt );
log4j_visit (‘debug’, ‘unknown_function’,
‘** discountDetailsList.size() = ’
|| TO_CHAR (l_discount_details_list .COUNT));
:= (CASE WHEN
+ 1000 &= p_idlist .COUNT THEN l_j + 1000
ELSE p_idlist .COUNT END);
plsql 也称过程化的sql ,是oracle对sql的扩充，在普通 sql 的基础上增加了编程语言的特点
plsql 语言的组成：块结构，一个plsql一般有以下几个部分
–变量定义部分
–执行体的开始
–异常处理（可选的）
–执行体的结束
chr(10)表示换行,chr(13)表示回车
IF condition1 THEN
statements1;
ELSIF condition2 THEN
statements2;
exit [when condition]
WHILE condition
statements
FOR var IN lowest_number..highest_number
statements
异常处理的完整流程：
定义异常－＞抛出异常－＞捕获及处理异常
处理非预定义异常
非预定义异常有错误号没有名字，处理的办法是：自己定义一个名字，绑定到错误号，捕获错误名
myexcp EXCEPTION;
PRAGMA EXCEPTION_INIT(myexcp,-02292);
dno emp.deptno%
delete from dept where deptno=
WHEN myexcp THEN
delete from emp where deptno=
delete from dept where deptno=
自定义异常处理
例：定义一个异常，往emp表中插数据，如果工资少于1500 抛出异常，不能让他插
v_no emp.empno%
v_name emp.ename%
v_sal emp.sal%
myexcp EXCEPTION;
if v_sal&1500 then
insert into emp (empno,ename,sal) values (v_no,v_name,v_sal);
WHEN myexcp THEN
insert into emp (empno,ename,sal) values (v_no,v_name,1500);
创建DML触发器
CREATE OR REPLACE TRIGGER trigger_name
BEFORE|AFTER event ON table_name
[FOR EACH ROW]
#加了这一个就是行级触发器，如果不加就是语句级
例：定一个触发器，禁止用主户在非工作时间修改emp表
create or replace trigger change_emp
before insert or update or delete on scott.emp
if (to_char(sysdate,’fmhh24’) not between 9 and 18) then
raise_application_error(-20000,’DML on ad 9:00-18:00’);
CREATE [OR REPLACE] PROCEDURE procedure_name
[(part_name [ IN | OUT | IN OUT] datetype… )]
[AUTHID DEFINER | CURRENT_USER]
procedure_body
过程调用、运行
call | execute procedure_name(part_list);
存储过程运行权限要求：
1、运行一个过程时，默认是以定义者的权限来访问相关表，所以即便运行无法访问存储过程涉及到的表，
过程也能运行，如果要改变这种方式在定义过程时加 AUTHID CURRENT_USER
requestDoc
DBMS_XMLDOM.
requestNode
l_clob_1 := TO_CLOB(l_tmp_string);
requestDoc := dbms_xmldom.newDOMDocument (l_clob_1);
requestNode :=
XMLDOM.item (xmldom.getelementsbytagname (requestDoc,
‘updateAccountRequest’ ), 0);
request := SoapDecUpdateAccountRequest.decode_update_account_request(requestNode);
requestMap := Varchar2AnydataMap_gdb();
requestMap.put(‘Request’ , ANYDATA.convertObject(request));
:= p_request_map .get(‘Request’);
IS NOT NULL THEN
IGNORE_PLS_INTEGER (l_tmp_1.getObject (l_request ));
if responseMap.containsKey( ‘Response’) then
responseDoc := SoapEncUpdateAccountResponse.encode_root_upd_acc_resp(response);
l_xmltype := dbms_xmldom.getXmlType(responseDoc);
—-将responseDoc转成XML格式。
dbms_xmldom.freeDocument(responseDoc);
response_clob := l_xmltype.getClobV
—-将xmltype转成clob格式的
JAVA 通过JDBC 连接oracle：
public static void main(String[] args) {
Class.forName(“oracle.jdbc.driver.OracleDriver”);
Connection conn = DriverManager.getConnection(“jdbc:oracle:thin:@localhost:1522:xe”, “charlene”, “123”);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(“SELECT * FROM csi_dppco.address”);
while(rs.next()){
System.out.println(rs.getInt(1) + “\t” + rs.getString(2));
}catch(Exception err){
System.out.println(err.toString());
正则表达式： 删除空行
^[\s\t]*\n
sed -i ‘/^\@.*/a\showerrors;′test.sqlMOUSETRAP_HOME/bin/xml-transformer in.xml mapping.txt out.xml
方法编译方式：
DiscountdetailsListAdd (l_discount_details_list ,l_discount_det );
文件编译一遍，有这个方法的文件
CREATE OR REPLACE PROCEDURE
DiscountdetailsListAdd (list IN OUT DiscountdetailsList , v IN
DiscountDetails )
IS BEGIN list. list (list.count ) := END ;
终端路径：要在你正在编译的目录下
l_bvoip_schedule_discounts
:= BvoipscheduletypeArray ();
l_bvoip_schedule_discounts (l_tag_number + 1) := BvoipScheduleType ();
类型不匹配修改：
component ‘SET_GCP_RATE_PLAN_EFFCTV_DATE’ must be
这种就是缺少函数
要在typ里面写入
构造函数的关键字是constructor
MEMBER FUNCTION get_schedule_discounts (SELF IN BvoipCountryInfo ) RETURN
BvoipscheduletypeArray ,
CONSTRUCTOR FUNCTION BvoipCountryInfo RETURN SELF AS RESULT)
CONSTRUCTOR FUNCTION NmapNetworkLegacy RETURN SELF AS RESULT IS BEGIN RETURN; END;
函数之间是逗号分割，最后一个不写逗号。
Invalid reference to variable ‘L_SCL_EFF_DATE’
log4j_visit (‘debug’, ‘unknown_function’, ‘** sclEffDate(for BVOIP AVPN Facilitaion) = ’ || l_scl_eff_date .to_string());
FORCE UNDER DppcoUtil_dppqcb
是继承关系
lc_rs%ISOPEN
l_tmp_2 := l_tmp_1.
– l_tmp_2
:= l_tmp_1 ;
l_tmp_2 := l_tmp_1.
IS NOT NULL THEN
IGNORE_PLS_INTEGER (l_tmp_2.
getObject (l_discount_det_1 ));
– l_discount_det_1
p_atp_info IN OUT NOCOPY
AtpInfoType , p_solution_type IN VARCHAR2 )
nocopy什么意思：
in out说明这个参数数个传入传出参数
varchar2是类型
nocopy：引用别人的话
pl/sql中对out，in out参数使用的？默认形参会复制一份实参的副本，然后在内部传递，修改等，发生异常，不会赋值给实参，控制权交还调用环境，而实参值不变，还是调用前的值。而使用了nocopy后，形参将获得一个指向实参的指针，然后在内部传递，赋值都直接修改实参了，此时如果异常发生，控制权交还调用环境，但是实参已经被修改了。无法还原成调用前的值。
gsm模块什么意思:
PLS-00526: A MAP or ORDER function is requ
lc_rs是cursor Java里所有对象都可以toString plsql里不行
打log只能是varchar2类型的， lc_rs是游标
过滤目录：
applypatch:
右键create patch:
grep -c ‘Index’ att_merged02_2_16.patch
| grep ‘^?’
install.sql
install_common.sql
dppqc_new.sql
(调用了api)自己写
test_aaa.sql(data.sql/table.sql/test01.sql)
l_cust_info_type (l_tag_number1 + 1).set_main_telephone(l_in_country .get_main_phone());
_cust_info_type (l_tag_number1+ 1).main_telephone :=_in_country .main_telephone. ; _cust_info_type (l_tag_number1+ 1).isset_main_telephone := ‘T’;
delete the duplicate type and body of the wsheader_dppqcb
unless type
REM INSERTING into BCI_DPPCO.CONTRACT
SET DEFINE OFF;
l_is_contract_available
:= get_property_dppqcb (‘Is_Contract_Available’);
SQL& SELECT ECATSNUMBER FROM bci_dppco.CONTRACT WHERE CONTRACTID =1;
ECATSNUMBER
lc_ecats_num_rs
/* NOT TRANSLATED: getEcatsNumPstmt.executeQuery() */ NULL;
游标改成这个：
open lc_ecats_num_rs for replace_question_marks(l_get_ecats_num_pstmt) using tmp_1 ;
执行update
EXECUTE IMMEDIATE replace_question_marks(l_update_ecats_num_pstmt) using tmp_1, tmp_2;
NVL (column1 , 0)什么意思？
。它的格式是NVL( string1, replace_with)。它的功能是如果string1为NULL，则NVL函数返回replace_with的值，否则返回string1的值，如果两个参数都为NULL ，则返回NULL。
EXECUTE IMMEDIATE
replace_question_marks (l_cstmt ) USING tmp , tmp_1 , tmp_2 ;
select * from CONTRACT where CONTRACTID=”’|| l_contract_id1
rs = pstmt.executeQuery();
if(rs.next())
/* NOT TRANSLATED: rs.next() */ NULL then
l_contractquery
:= ‘select * from CONTRACT where CONTRACTID=”’
|| l_contract_id1
OPEN lc_rs FOR l_
FETCH lc_rs INTO pager_number_1;
pager_number_1
BCI_dppco.CONTRACT%
if lc_rs%rowcount &0 then
l_contract_status_flg
UPPER (TRIM (l_contract_status ))
= UPPER (‘CustomerSigned’)
只要if 下面有句子，是还要走的。
还有找标签类型：
l_contract:
ContractType–&tyb
MEMBER FUNCTION get_contract_status (SELF IN ContractType ) RETURN
IS BEGIN RETURN SELF .contract_ END;
–&soapdecsetcontractreqt.pkb
contract_status–&l_name
= ‘ContractStatus’ THEN
BEGIN l_obj .contract_status := SoapDecCommon_dppqcb.decode_string (l_child ); END;
l_obj ContractT
svn ：记得mine
preference:
“word_wrap”:true,
“wrap_width”:80
记得写分号
@plsql/com/att/edb/dppco/query/SetContract.tyb
@query_properties_insert.
@tests/SetContract/setContract_table.
How to effectivly work on Steyr project?
How to quickly adapt yourself to Steyr RE project 1
Steyr project expericce sharing 1
Steyr project expericce sharing 1
Steyr project expericce sharing 1
Steyr project expericce sharing 1
Steyr project expericce sharing 1
Roy Steyr project expericce sharing 1
How to develop tool/script for RE project? 1
Steyr project expericce sharing 1
How to effectivly work in Steyr project? 1
Steyr project expericce sharing 1
Steyr project expericce sharing 1
LLINGINSTANCETYPE) = ”PRICEPLANINSTANCE” 最后这个改成单引号里面套上单引号
FOR l_idx_1 IN
1..l_to_be_iterated .getKeys().getNumEntries()
l_tmp_2 := l_to_be_iterated.getKeys ();
l_instance_id := l_tmp_2.getByIndex(l_idx_1 );
SitesummaryinstancetypeArr1Add (l_result_list ,
l_to_be_iterated .get(l_instance_id ));
其实需要将getkeys()放在最开始，最先初始化。
FOR l_idx_1 IN
l_tmp_2 := l_to_be_iterated.getKeys ();
FOR l_idx_1 IN
1..l_tmp_2.getNumEntries()
l_instance_id := l_tmp_2.getByIndex(l_idx_1 ); –step 3
SitesummaryinstancetypeArr1Add (l_result_list ,
l_to_be_iterated .get(l_instance_id ));
先后顺序FETCH
lc_rs%ISOPEN
( lc_rs%FOUND
IS NULL OR
lc_rs%FOUND
= TRUE) THEN
/* FETCH VARS GUESSED */ FETCH lc_rs
ctnumber , contractedbusinessname ,
contractindicator , sourcesystemid ,
priceplaninstanceid ,
attcontractsolutionnumber ,
fetch lc_rs into
ctnumber , contractedbusinessname ,
contractindicator , sourcesystemid ,
priceplaninstanceid ,
attcontractsolutionnumber ,
if lc_rs%isopen and lc_rs%found then/by script end/
EXECUTE IMMEDIATE l_ins_pstmt_ctrt_
EXECUTE IMMEDIATE replace_question_marks(l_ins_pstmt_ctrt_unavailable) using tmp_29,tmp_30
,tmp_31,tmp_32,tmp_33,tmp_34,tmp_35,tmp_36,tmp_37,tmp_38,tmp_39,tmp_40,tmp_41,tmp_42;
l_discount_details_it%FOUND
/* NOT TRANSLATED: discountDetailsIt.next() */ NULL;
– l_tmp_2
:= l_tmp_1 ;
l_tmp_2 := l_tmp_1.
IS NOT NULL THEN
IGNORE_PLS_INTEGER (l_tmp_2.
getObject (l_discount_det_1 ));
for i in 1..l_discount_details_list.count
/* NOT TRANSLATED: discountDetailsIt.next() */ NULL;
if l_discount_details_list(i) is not null then
l_discount_det_1 := l_discount_details_list(i);
/* NOT TRANSLATED: pricePlanInstanceIdIt.next() */ NULL;
l_price_plan_instance_id
:= objectToString (l_tmp );
need to changed :
l_price_plan_instance_id_it%FOUND
for i in 1..l_price_plan_instance_id_list.count
/* NOT TRANSLATED: pricePlanInstanceIdIt.next() */ NULL;
l_price_plan_instance_id
:= l_price_plan_instance_id_list(i)/objectToString (l_tmp )/;
l_discount_percent_list
:= AnydataList ();
不用方法了，直接赋值
l_tmp:=l_country_info_set.getByIndex(i);
l_country_code
:= /safeAccessVarChar2 (l_tmp );/l_
l_contract_end_date
IS NOT NULL THEN
l_cal_contract_end_date
:= l_contract_end_date /* NOT TRANSLATED: new Date(contractEndDate.getTime()) / /*NULL/;
getInteger(custStrata)
TO_NUMBER(l_cust_strata)
– pricing_plan_inst_id_lt
pricing_plan_inst_id_lt := Varchar2List();
后面的赋值给前面的
Varchar2ListAdd(pricing_plan_inst_id_lt,priceplaninstanceid);
/* NOT TRANSLATED: rs.next() */ NULL
changed to
IF lc_rs%FOUND then
l_customer_id ||””;
l_request_mis .set_serviceperiod( /* NOT TRANSLATED: new Integer(contractPeriod) */ NULL);
l_request_mis .set_serviceperiod(cast(l_contract_period as INTEGER));
– l_in_put_list .transactionid := objectToString (p_hm .correlation_id);
l_in_put_list .transactionid := safeAccessVarChar2 (p_hm .correlation_id);
不能注释别人的方法
ls_rc 类型错误
DBMS_XMLDOM可以查找文档
若是直接改成ment不行的要改成getlength()&0
ignore_pls_integer(p_ref.getvarchar2(l_tmp));
l_tmp（varchar2(32767);）转换为anydata类型
Varchar2Array1Add (l_vararray , l_tmp);
//l_tmp赋值给l_arry
Varchar2Array1Add (list IN OUT NOCOPY Varchar2Array , v IN VARCHAR2 ) IS
BEGIN list. list (list.count ) := END ;
p.map.put(p_key,l_varrray)
function getvarchar2 (anydata_p in sys.anydata) return varchar2;
MEMBER FUNCTION GETOBJECT(
IN ANYDATASET,
OUT NOCOPY “”)
PLS_INTEGER;
查阅方法的东西
这里面可以直接查找 用到的方法
getcustumer
test_setcontract.sql里面是只能写一个log
但是test_01里面可以写log.在
SET SERVEROUTPUT ON ;
request CONSTANT CLOB :=to_clob(’
test_sxxxxxx.sql
xxxxxxxxxxx_test01.sql
set serveroutp
spool test_setcontract.
=============
getNetworkElementAssetDetails.tyb
get_net_el_asset_det
查找你要用的： （看responsedocument）
erged_03_21/plsql/webservice/DboripnaiSvc.typ:
public NetworkElementAssetDetailsResponseDocument getNetworkElementAssetDetails (com.monheader.v3.WSHeaderDocument WSHeader, java.lang.String assetQueryType, java.lang.String deviceID, java.lang.String slotID, java.lang.String cardSerialNumber, java.lang.String portName)
in java you can find:
e/dboripnai/src/DBOR_IPNAI_Svc/src/DBORIPNAISvcContract.wsdl:
DBOR_IPNAI_Svc.java
public com.att.dbor.ip.nai.v1.NetworkElementAssetDetailsResponseDocument getNetworkElementAssetDetails(com.att.dbor.ip.nai.v1.
DboripnaiSvc_
里面的方法：
MEMBER FUNCTION get_net_el_asset_det
有时候是缩写
做一个完整api的步骤
/sandbox/attworkspace/dboripnai/src/DBOR_IPNAI_Svc/src/DBORIPNAISvcContract.wsdl
大家都用的是一个
打开点soap-&
wsdl生成xml/ create test files (table.sql,data.sql,test_01.sql)
decode/encode
api_interface define(pkg.pkb)
Steps to run the test cases:
进入到sql里面去执行这个命令
0. execute “create user GDB identified by {password}” then give privilege to the user GDB
1. @getContractPackage_table.sql to create the tables
2. @getContractPackage_data.sql to insert data
3. execute @dppqcb.sql to create related packages
4. execute @GetContractPackage_test01.sql to run the test script
create user mynew identified by 123456
create user mynewtest
identified by 123456;
grant connect,dba,resource,unlimited tab
grant all privileges to s_
设置全部权限，授权全部可用
– set linesize 180;
– set serveroutp
– spool test01.
– @plsql/com/att/edb/dppco/query/GetContractPackage.
– @plsql/com/uniquesoft/utils/properties_dppqcb.
request_clob clob :=’
SELF .document :=
/* NOT TRANSLATED: documentBuilder.parse(xmlIn) */ NULL;
SELF .document := to_clob(SELF .response_string);
– SELF.bws_endpoint_url
SELF.bws_endpoint_url
SELF.bws_user_id
:= ‘EDFAdmin@bwas1-hcomm.att.net’;
SELF.bws_password
:= ‘EDFTrinity!1’;
SELF.bw_encoding_format
:= ‘ISO-8859-1’;
SELF.response_string
EXCEPTION WHEN others
log_exception();
======================================
成propty insert 脚本：
gen-prop-insert.sh properties_dppqcb /sandbox/projects/att2/working/trunk/ibm_8_03/DPPQCB.161/gcp_dppqcb.161/dppqcBc/src/Utilities/src/com/att/edb/dppco/util/ContractBillingQuery.properties getBillAccount
[3:04:17 PM] Paul Lu: gen-prop-insert.sh
l_response_values
:= Varchar2Varchar2arrayMap_gdb ();
/* NOT TRANSLATED: this.document.getDocumentElement() .normalize() */ NULL;
log_debug ((‘debug’) || ‘: ’
|| (‘Root element :’
/* NOT TRANSLATED: this.document.getDocumentElement() .getNodeName() */ NULL));
l_tn_un_assigned_list
/* NOT TRANSLATED: this.document.getElementsByTagName(“phoneNumber”) */ NULL;
/* NOT TRANSLATED: tnUnAssignedList.getLength() */ NULL
changed to :
l_xml_doc := dbms_xmldom.newDOMDocument(self.document);
l_root_element := DBMS_XMLDOM.GETDOCUMENTELEMENT(l_xml_doc);
l_root_node := DBMS_XMLDOM.MAKENODE(l_root_element);
log_debug ((‘debug’) || ‘: ’
|| (‘Root element :’ ||
dbms_xmldom.getNodeName(l_root_node)));
l_tn_un_assigned_list
DBMS_XMLDOM.getElementsByTagName(l_xml_doc,’phoneNumber’);
FOR l_temp IN 0..( DBMS_XMLDOM.GETLENGTH(l_tn_un_assigned_list) - 1 )
SELF .add_to_map(l_response_values , ‘tnUnAssigned’,
AnyData.convertVarChar2 (DBMS_XMLDOM.GETNODEVALUE(xmldom.item(l_tn_un_assigned_list,l_temp))));
ibm_11_12/gcp_gdp.153/attmerged23_2/plsql/com/att/gcp/gdb/util/ OciclientLogin.tyb
===============
OPEN lc_rs FOR replace_question_marks (l_pstmt )
lc_rs%ISOPEN
( lc_rs%FOUND
IS NULL OR
lc_rs%FOUND = TRUE) THEN
/* FETCH VARS GUESSED */ FETCH lc_rs
[3:06:39 PM] Paul Lu: 要改成：
OPEN lc_rs FOR replace_question_marks (l_pstmt )
/* FETCH VARS GUESSED */ FETCH lc_rs
lc_rs%ISOPEN
AND lc_rs%FOUND THEN
:= l_tmp_1 ;
:= ApplicationUtil.execute_type_sql_1 (l_tmp ,
'OBJECT_ID');
……………
:= AnydataArray();
for l_id_x in 1.. l_tmp_1.count
AnydataArray1Add(l_tmp, anydata.convertNumber(l_tmp_1(l_id_x)));
:= ApplicationUtil.execute_type_sql_1 (l_tmp ,
‘OBJECT_ID’);
– l_request
:= l_request_doc .get_bill_account_write_request();
l_request :=
……………….
log_debug (‘debug’
|| ‘:’|| ‘unknown_function’
|| ‘:’||
脚本可以改
response := l_bill_account_write_
projects url
NULL IS OF (InvalidInputException ) THEN
IF sqlcode = -20024 THEN
NULL IS OF (DataNotFoundException ) THEN
IF sqlcode = -20027 then
NULL IS OF (BackEndSysDown ) THEN
if sqlcode = -20028 then
CONSTRUCTOR FUNCTION GetVrfNameByEvc(p_req GetVrfNameByEvcRequest) RETURN SELF AS RESULT IS BEGIN SELF.request :=p_ RETURN;END;
MEMBER FUNCTION get_response RETURN Ge
constructor function RETURN SELF AS RESULT IS BEGIN request :=p_RETURN; END;
==============
table name:
bci_dppco.
‘csi_dppco.
==========
现在执行顺序：
sql:命令：
sqlplus sherryzhu/123456@localhost:1522/
—-链接数据库
rlwrap sqlplus GDB/GDB_PWD@localhost:1522/
screenshot 截图命令
gnome-screenshot -wd 10
[sherryzhu@rat196 Desktop]$ gnome-screenshot -wd 12
drop type Varchar2anydataarraymap1
接口(Java Naming and Directory Interface),在J2EE规
locate_field.pl ~/Desktop/aa.sql PVC pvc_lsite_id
drop table <>.<>;
changed to
drop table <>;
create table
select * from a,b
where a.id=b.id(+)
这里的意思就是a，b表连接，a表先全部展示，然后b表id和a表一致的就连接上，没有的就补些空格在后边。
shift+ 右键， 操作快速组成表
====================
rocCon.Create
这个就是链接
stmtInstar = instarConn.createStatement();
=================
issue: 0321
/sandbox/attworkspace/modified01_merged/plsql/com/att/edb/ctp/query/GetEthVplsDetailsStatics.pkb
Line ：314
premise 改为了premise_instarConn
’ from site s, premise_instarConn p, SITE_CONTACT sc, instar.country
’ || ’ where s.loc_id = p.loc_id (+) and s.site_id = sc.site_id (+) ‘
==============
to_date(‘05-JUN-15’,’DD-MON-RR’),
--set back for add new by julia
l_resp.customer_info :=l_cust_
l_resp.site_info :=l_site_
l_resp.access_port_info :=l_
l_resp.pvc_info_list :=l_
log_debug_configure.enable_logging();
是返回当前元素， 并指向下一个元素。
hasNext()， 则是判断当前元素是否存在，并指向下一个元素（即所谓的索引
顺序问题；
/* NOT TRANSLATED: ps34.executeQuery() */ NULL;
:= GetEthVplsDetailsStatics.qry_3_4 ;–add by sherry
dbms_output.put_line(‘sql:
‘||replace_question_marks(l_ps341));
open lc_rs34 for replace_question_marks(l_ps341) using tmp_10 ;
query_statistics_afs.init_stats (replace_question_marks (l_ps341 ), 'get_eth_vpls_detail');
disallowed 调用不允许
select 选出几个fetch就是要几个，不能少
返回字符串str与尾部的空格字符去掉
in.hasnext();判断有没下个元素，返回boolean
next()方法是取下个元素
SppInstarContext_ipnai2_install 这些怎么生成
workload :0322——
l_request.put(‘ServiceType’, anydata.convertvarchar2(‘si’));
l_request.put(‘QueryType’, anydata.convertnumber(IpnaiMethodsStatics_ipnai2.listassetbykia));
==========
写在括号里面
CONSTRUCTOR FUNCTION NetElAssetDetReqstDocument RETURN SELF AS RESULT IS BEGIN RETURN; END;
‘dd-mm-yyyy hh24:mi:ss
‘14-08-:00’
YYYY-MM-DD”T”HH24:MI:SS”Z”
T22:12:00Z
varchartoanydata?
Varchar2AnydataMap
cStatics_ipnai2.logger .method_enter( /* NOT TRANSLATED: currentThread() */ NULL, l_method_name );
方法里面直接赋值：
ignore_pls_integer(p_request.request.getObject(l_net_el_asset_det_reqst));
:= l_net_el_asset_det_reqst.asset_query_
:= l_net_el_asset_det_reqst.device_
为空的要改的：
:= IpnaiFacadeStatics_ipnai2.spp_instar_context .get_net_el_asset_det(p_s1 , p_s2 , p_s3 , p_s4 , p_s5 );
l_spp_instar_context SppInstarContext_ipnai2;
l_spp_instar_context := SppInstarContext_ipnai2();
:= l_spp_instar_context .get_net_el_asset_det(p_s1 , p_s2 , p_s3 , p_s4 , p_s5 );
l_result NetElAssetDetRespD
l_eq_instl_date
:= to_date(equipment_installed_dt,’yyyy-mm-dd hh24:mi:ss’) ;
l_utildate :=l_eq_instl_
l_xml_cal_cur2
/* NOT TRANSLATED: new XmlCalendar(utildate) */ NULL;
l_installdate_xml
/* NOT TRANSLATED: new
XmlCalendar(xml_cal_cur2.toString()
.substring(0, xml_cal_cur2.toString() .indexOf(‘.’))) */ NULL;
-- GregorianCalendar gc = new GregorianCalendar(eqInstlDate.getYear(),eqInstlDate.getMonth(),eqInstlDate.getDay());
l_result .equipment_installed_dt := l_
l_nai_edw_ipnai
NaiEdwDao_ipnai2;
l_nai_edw_ipnai := NaiEdwDao_ipnai2();
l_net_list :=l_nai_edw_ipnai.get_net_el_asset_query_final(p_str2);
:= l_net_el_asset_det_reqst.slot_
表名要重写
如果重新命名
昨天可以得到的结果，今天为什么一个得不到了？
需要运行一遍，执行get_net_el_()这个方法的tyb
– l_param1
:= safeAccessVarChar2 ( /* NOT TRANSLATED: request.getParameter(“assetQueryType”) */ NULL);
果然是要改的，改成：
l_net_el_asset_det_reqst NetElAssetDetR
l_net_el_asset_det_reqst :=
NetElAssetDetReqst();
ignore_pls_integer(p_request.request.getObject(l_net_el_asset_det_reqst));
:= l_net_el_asset_det_reqst.asset_query_
log_debug (replace_question_marks (l_statement ));
query_statistics.init_stats (replace_question_marks (l_statement ), ‘get_net_el_asset_query_final’);
atttables:
create table linkeduser.gcp_Service( ); 相同的是在
@/sandbox/attworkspace/atttables/tables/GCP_Circuit+EDF_TO_IDIS..table.sql
table drop/table create
select count(*) from gcp_Service@EDF_TO_IDIS.;
desc gcp_Service
drop table
create synonym
gcp_service@EDF_TO_IDIS.;
delete gcp_circuitcircuit 删除里面的数据
drop synonym gcp_node_1
空格写的有问题，也要删掉的
l_statement
:= SppIdisSqlStringIntfStatics.get_clfi_info_
log_debug (replace_question_marks (l_statement ));
/* NOT TRANSLATED: rs.next() */
/* NOT TRANSLATED: rs.next() */
l_rs.next()
–l_a_clfi_uni_holder .clfi_id := NVL(clficircuitid , 0);
/* FETCH VARS GUESSED */ FETCH lc_rs
uni_circuit_id , acna , ban , cs_name , in_effect_indicator , ubid , uverse_ban , customer_
lc_rs%NOTFOUND ;
l_a_clfi_uni_holder
:= ClfiUniHolder ();
l_a_clfi_uni_holder .uni_ckt := uni_circuit_
ctrl+ 右键 也是复制的意思
l_result .set_device_description(l_rr_1 .device_description);
用就用，不用就不用管。
l_result .install_date:=(l_rr .equipment_installed_dt);
create table
to_date(‘05-JUN-15’,’DD-MON-RR’)
to_date(‘ 20:47:00’,’yyyy-mm-dd hh24:mi:ss’)
to_date(‘T22:12:00Z’,’YYYY-MM-DD”T”HH24:MI:SS”Z”’)
NAI_EDW_EQUIPMENT_USER_ATTR_naiEdw
EQUIPMENT_USER_ATTR_naiEdw
nai_edw_server_parameter_naiEdw
server_parameter_naiEdw
nai_edw_network_equipment_mfr_naiEdw
network_equipment_mfr_naiEdw
NAI_EDW_PATH_USER_ATTRIBUTE_naiEdw
PATH_USER_ATTRIBUTE_naiEdw
SVN失败了然后再更新一下，出现delete才对了
不用在上面直接删
uniSvc.In_Effect_Indicator
uniSvc.”In-Effect_Indicator”
① 表示字符串常量
② 字符串中的双引号仅仅被当作一个普通字符进行处理。此时，双引号不需要成对出现
安装的时候把那个contract那个选项关了，要不然特别慢
你把下载的文件解压，应该有两个文件一个是piugin 和feature这两个文件，接着将这些文件分别放入到eclipse的对应文件夹下面，就可以了，eclipse提供这种安装插件的方法，类似如接口。很方便。下次启动eclipse时它会自动加载插件
消除勾选的从官网检查的选项
pi返回是array的在写package的时候，将array封装到相对应的response里面
[4:47:14 PM] Julia Zhang: 然后进行encode
[4:49:14 PM] Julia Zhang: ========================比如================================
—————————————-declare————————————————–
ContactdetailA
l_result_list ContactdetailL
WsHeaderDocument_bvoip2;
——————————–body———————————————-
l_wsh_doc :=WsHeaderDocument_bvoip2();
l_wsh_doc.ws_header :=request.ws_
l_result := api.list_contact_detail_by_site_id(l_wsh_doc,request.site_id,request.remote_site_id,request.site_status);
l_result_list.contact_detail_array :=l_
response.contact_detail_list :=l_result_
if response is not null then
– ignore_pls_integer(resp_hm.response.getObject(response_doc));
– response := response_doc .vrf_name_
res_dom_doc := SoapEncListCntcDetBySiteIdResp .encd_root_list_cntc_det_by (response);
In-Effect_Indicator
create table a(“in-d” varchar2(200));
insert into a (“in-d”)values(‘ll’);
DborbvoipsdSvc.tyb
not translated function : arraycopy()
/* NOT TRANSLATED: arraycopy(convertToAnyData(_response1), 0, convertToAnyData(_response), 0,
_response1.length) */ NULL;
使用arraycopy() 时注意数组的索引从1开始，不是从0 开始
++++++++++++++++++++++++++++++++++++++++++++++++++++
translated code:
create or replace procedure arraycopy
(src in anydataarray,srcpos in integer,dest in out nocopy anydataarray,destpos in integer,length in integer)
procedure arrayextend(array in out nocopy anydataarray,endindex in integer) is
if array is null then array := anydataarray();
l_count := array.
if l_count &= endindex then
l_length := endindex - l_
array.extend(l_length);
if src is not null and src.count & 0 then
if dest is null then dest := anydataarray();
if srcpos is null or destpos is null or length is null and (srcpos+length-1 & src.count)then
dbms_output.put_line(‘java.lang.system error : IndexOutOfBoundsException’);
arrayextend(dest,destpos+length-1);
for i in 0..(length-1)
dest(destpos+i) := src(srcpos+i);
dbms_output.put_line(‘java.lang.system error : NullPointerException’);
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
test code:
l_array:= anydataarray();
l_array_1 := anydataarray();
l_array_1.extend(3);
l_array_1(1):= anydata.convertvarchar2(‘my’);
l_array_1(2):= anydata.convertvarchar2(‘plsql’);
l_array_1(3):= anydata.convertvarchar2(‘test’);
arraycopy(l_array_1,1,l_array,1,3);
if l_array is not null and l_array.count &0 then
dbms_output.put_line(‘=======get array success’);
dbms_output.put_line(‘array count is: ‘||l_array.count);
dbms_output.put_line(‘element_1 is: ‘||safeaccessvarchar2(l_array(1)));
dbms_output.put_line(‘element_2 is: ‘||safeaccessvarchar2(l_array(2)));
dbms_output.put_line(‘element_3 is: ‘||safeaccessvarchar2(l_array(3)));
dbms_output.put_line(‘=======get array failure’);
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
———————-victor
[2:29:13 PM] Julia Zhang: 为什么不直接用arrayaddall
[2:29:29 PM] Julia Zhang:
AnydataArray1AddAll(l_response,l_response1);
AnydataArray1AddAll(l_response,l_response2);
[2:29:42 PM] Julia Zhang: ——————————————————————————
/* NOT TRANSLATED: arraycopy(convertToAnyData(_response1), 0, convertToAnyData(_response), 0,
_response1.length) */ NULL;
/* NOT TRANSLATED: arraycopy(convertToAnyData(_response2), 0, convertToAnyData(_response),
_response1.length, _response2.length) */ NULL;
[2:29:43 PM] Charlene Chen : 索引的位置
=================================
增加了arrayaddall.sql（victor写的）, 翻译 NOT TRANSLATED: arraycopy(….)， 用到的更新下吧
[3:31:53 PM] Charlene Chen : arraycopy(l_response1, 1, l_response, 1,l_response1.count);
arraycopy(l_response2, 1,l_response,l_response1.count +1, l_response2.count);
nonquoted identifiers can contain only alphanumeric characters from your database character set and the underscore (_), dollar sign (),&and&pound&sign&(#).&Database&links&can&also&contain&periods&(.)&and&"at"&signs&(@).&Oracle&strongly&discourages&you&from&using and # in nonquoted identifiers.
Quoted identifiers can contain any characters and punctuations marks as well as spaces. However, neither quoted nor nonquoted identifiers can contain double quotation marks or the null character (\0).
不能识别的句子总结：
oracle dms
==============
getSipIcSummary
===============
在根目录下运行
installapi.pl name
FETCH lc_rs
BULK COLLECT INTO l_smplx
LIMIT l_rs_limit
“SYS.UTL_INADDR”, line 19
at “SYS.ANYDATA”, line 48
dbms_output.put_line(UTL_INADDR.GET_HOST_ADDRESS);
/sandbox/attworkspace/generated01_nmap/plsql/com/att/dbor/rubyweb/common/RubyWebUtils.tyb
at line 54
–l_ws_context .set_source_ip_address(UTL_INADDR.GET_HOST_ADDRESS);
(RubyWebConstantsStatics.icore_ds_name );
from vpn_ICoreDbor,ipfr_ICoreDbor
‘PsocDataSource’;
listIpagNteClfiPortInfo
select * from service_office_basic_info where to_date(date_month,’yyyy-mm-dd’)=’’
select sysdate,to_char(sysdate,’yyyy-ddd hh:mi:ss’) from dual
SQLSelectFetchItem returns SQLExpression:
SQLSelectFetchColumnItem | SQLAggrFunction
{SQLSelectFetchColumnItem}
(isDistinct = ‘distinct’)? (‘(‘)?columnRef = SQLColumnReferenceExpression (aliasName=ID)? (‘)’)?
SQLColumnReferenceExpression
returns SQLExpression:
{SQLColumnReferenceExpression}
(aliasName = ID’.’)? columnName = ID (joinTag ?=’(’ ‘+’ ‘)’| newaliasname ?=’as’ newname?=ID)?
SELECT DISTINCT Company FROM Orders
SQLSelectFetchColumnItem | SQLAggrFunction|SQLPrimaryExpression
select insert分为两个布局
3.日期写成固定格式的
date: “to_date(‘ 20:47:00’,’yyyy-mm-dd hh24:mi:ss’)”
3.trim太复杂（层层 套）
update t_test t set t.password= ?, t.remark = ‘*’
columns+=SQLSelectFetchItem (‘=’ ‘?’ ‘,’ columns+=SQLSelectFetchItem )* (‘=”?”,’)?
/////////////
(‘update’)((sqlDataReferences+=SQLDatasetReference) (‘,’tableReferences += SQLDatasetReference)*)(‘set’)
(((‘,’)? condition1 += SQLConditionExpression ) | ( columns+=SQLSelectFetchItem (‘=’ ‘?’ ‘,’ columns+=SQLSelectFetchItem )* (‘=”?”,’)?) )*
((‘where’) condition += SQLConditionExpression)?
如果指定leading参数，oracle数据库将去除任何等于trim_character的开头字符。
SQL& select trim(leading ‘x’ from ‘xdylan’) “test_trim”
TO_CHAR(ipa.total_port_state_date, ‘YYYY-MM-DD’)
decode(round(co.port / 1000 - 1), -1, NULL, round(co.port / 1000 - 1)) AS basePort, mod(co.port, 1000) AS port,
shift + 鼠标右键， 然后按住Tab键可以整体右移
英 [??’m?t?d]
美 [o?’m?t?d]
遗漏; 省略( omit的过去式和过去分词 ); 删掉; 忘记做
cardinality
英 [kɑ:d?’nael?t?]
美 [?kɑ:d?’nael?t?]
英 ['kaer?t]
美 [‘kaer?t]
脱字号，补字号; 补字符号
tree rewrite action
expression 42
Operation {
left=Operation {
left=IntLiteral {
指定; 指派; 分配( assign的第三人称单数 ); （作为说明或原因） 提出
if (isTrue())
if (isTrueAsWell())
doStuff();
dontDoStuff();
Condition:
'if' '(' condition=BooleanExpression ')'
then=Expression(这里应该是if else内部的条件)
(=&'else' else=Expression)?
（这里应该是又写了一个else）
英 ['t??k?n]
美 ['to?k?n]
象征; 记号; 代币;
象征性的; 作为对某事的保证的; 作为标志的;
** is not accessible due to restriction on required library”的错误出现。
顾名思义，错误意思为是所需要的类库由于受限制无法访问。
println(” ddddddddddddd”)
VALUES’ ‘(’
+= SQLPrimaryExpression
(‘,’(value +=SQLPrimaryExpression))*
要value全写value
= SQLPrimaryExpression 这种形式的会导致覆盖的可能
2.变量名要一致。 否则导致后面xtend用的时候会找不到文件
3.source 在xtend-gen
src-gen 都是源代码文件
4。xtextResource.allContents.filter(SQlInsertStatement).forEach[e|
println(“)_)))))) insert .. “)
这个后面加e是可以的
val values = e.
val tableRef = ((e.sqlDataReferences.head as SQLDatasetReference).refbase as SQLTableReference)
val tableName =tableRef.tableName
val schemaName = tableRef.schemaName
val tableRef = resolve(e.leftOperand as SQLColumnReferenceExpression).refbase as
var columns = datamodel.findOrCreateSchema(schemaName.nullsafe[‘DEFAULT’].toUpperCase).
findOrCreateTable(tableName.toUpperCase).columns
columns.forEach[
c, i|c.addValue(
NodeModelUtils.getNode(values.get(i)).text
DEC_NUM BIN_DOUBLE
.235E+003 1.235E+003
The following example returns bin_float if it is a number. Otherwise, 0 is returned.
SELECT bin_float, NANVL(bin_float,0)
FROM float_point_
BIN_FLOAT NANVL(BIN_FLOAT,0)
1.235E+003
1.235E+003
不是数字返回0
get_equipment_details
getEquipmentDetails_api
执行本文件需要的所有api文件脚本里面:
执行本tyb需要的所有api文件那个脚本:/sandbox/attworkspace/common_objects_shanghai/bin:
objects_shanghai/bin/installapi.pl
在工作目录下面：比如我的/sandbox/attworkspace/modified01_merged_0808 这个里面
install.pl
CMDC_API_PKG
GetEquipDetRespDocument ,
TYPE里面一定也要改呀 否则报错了
get_equipment_details
CmdcMethodsStatics.getequipmentinfo 539
EquipmentDetailQueryStatics
定位数据的位置和值的那个脚本是哪个
locate_field.pl
file path that contains insert sql you want to deal with
locate_field.pl ~/Desktop/a.sql PVC pvc_lsite_id
chmod -R 777 *
chmod 777 .
CmdcUtils.checkNull(rs.getString(“deviceTid”)) !
l_equip_details .set_device_model(l_device_mdl );
fetch 跟select保持一致，不参考java代码。域要跟它一致。
FETCH lc_rs2
BULK COLLECT INTO
l_devicename_array,
l_deviceptnii_array,
l_deviceclli_array,l_nodetype_array , l_nodesubtype_array,l_nodeid_array
:= ResultSet_cmdc (lc_stmt_rs );
@ /sandbox/attworkspace/modified01_merged_0808/tests/gcp/getEquipmentDetails/getEquipmentDetails_data.sql
Oracle 树操作(select…start with…connect by…prior) …_博客园
日 - oracle树查询的最重要的就是select…start with…connect by…prior语法了。依托于该语法,我们可以将一个表形结构的以树的顺序列出来。在下面列述了or…
prior 在谁的前面就表示已查出数据的这个字段 作为将要查找下一条字段符合的条件。
“working_dir” : “folder”,“cmd”:[“bash”,“-c”,“echo-e‘showerrors;\nexit′|sqlplussherryzhu/123456@localhost:1522/xe@file”]
Click on Tools -& Build System -& New Build System
copy and paste the code below:
“working_dir” : “folder”,“shellcmd”:“echo-e‘showerrors;\nexit′|sqlplus64paulgdb/paulgdb@localhost:1522/xe@file”,
modify the password and user name.
click on File -& Save, save the file with the name: sqlplus.sublime-build
create a file named login.sql
under the opened folder in sublime with the content:
delete gcp_
值是空的就选不出来
CONNECT BY PRIOR org_id = parent_id就是说上一条记录的org_id 是本条记录的parent_id
SVN: ‘0x: Compare with Revision’ operation finished with error: svn: E195002: PREV, BASE or COMMITTTED revision keywords are invalid for URL
CmdcUtils.print_to_string (l_temp));
response_map.exception_1 :=SELF.process_exception(l_temp);
svn: E195002: PREV, BASE or COMMITTTED revision keywords are invalid for URL
lc_rs_rmt_dvc_ip_for_clfi
IS NOT NULL AND
lc_rs_rmt_dvc_ip_for_clfi%ISOPEN
THEN CLOSE lc_rs_rmt_dvc_ip_for_
when other then
log_exception();
关掉fetch后面的游标，写在循环的外面。
close lc_rs3b_1;
:= ResultSet_cmdc (lc_stmt_rs );
resultset关闭的时候：
l_rs3b_2.close();
getSCIDByCable
自己造requst时候字段从哪个文件找。
alter sherry 123456 identified by 654321;
getComponentBySCID_ap
alter user sherry identified by 654321;
getUniCktDetailsbyCLCI
same as getEvcByClci
l_request_SCIDByCable := ScidByCableRequest();
l_request_a := p_request.
if l_request_a is not null then
ignore_pls_integer(l_request_a.getObject(l_request_SCIDByCable));
:= to_char (l_request_SCIDByCable.start_row);
:= to_char ( l_request_SCIDByCable.max_rows);
:= to_char ( l_request_SCIDByCable.cable_id);
:= to_char ( l_request_SCIDByCable.cableloc_aclli);
:= to_char ( l_request_SCIDByCable.cableloc_zclli);
执行sql语句没翻译的这种改法：
:= ResultSetHelper_cmdc ( /* NOT TRANSLATED: statement.executeQuery(uniCktQuery) */ NULL);
其中 l_buf是The SQL query is
OPEN l_cursor for l_
:= ResultSetHelper_cmdc (ResultSet_cmdc(l_cursor));
open l_cursor_2 for (l_query_s
|| l_query
|| l_query_e);
:= ResultSetHelper_cmdc (ResultSet_cmdc(l_cursor_2));
l_rsh .next_1()
可通过level 关键字查询所在层次.
select a.*,level from persons.dept a start with paredeptid=0 connect by prior deptid=paredeptid
start with 后面所跟的就是就是递归的种子。
递归的种子也就是递归开始的地方 connect by 后面的”prior” 如果缺省：则只能查询到符合条件的起始行，并不进行递归查询；
onnect by prior 后面所放的字段是有关系的，它指明了查询的方向
prior 表示上一条记录：
上一条记录的deptid是本条记录的pardptid. 上一条记录是本记录的父亲。
getConnectionSummaryReportData
spool getConnectionSummaryReportData_test.log
注释一对儿的是“
– l_lst_log_service_types
/* NOT TRANSLATED: asList(arSvcTypes) */ NULL;
l_lst_log_service_types :=AnydataArray();
FOR i in 1..l_ar_svc_types.COUNT LOOP
l_lst_log_service_types.EXTEND;
l_lst_log_service_types(i)
anydata.convertvarchar2(l_ar_svc_types(i));
( SELF .b_is_cpe_data_requested
翻译成java就是 this.bIsCPEDataRequested,
NOT FINAL (重写）
(1)方法重载是一个类中定义了多个方法名相同,而他们的参数的数量不同或数量相同而类型和次序不同,则称为方法的重载(Overloading)
(2)方法重写是在子类存在方法与父类的方法的名字相同,而且参数的个数与类型一样,返回
值也一样的方法,就称为重写(Overriding)
因此你参数类型都不一样，所以不算做是重写，顶多是重载
oracle with table as 的用法
where 条件只是满足最近的 一条select 语句的条件
SQL中操作符&&表示“不等于”；
作为一个常量： ‘?VPNTACountry?’
AS vpn_ta_country, 增加一个新的列
grant execute on utl_mail TO test_.
alt 文件负责权限设置的。
svn+ssh://shoreline.dnsalias.net/localproj/svn/steyr/trunk/ibm_4_25_2016/gcp_cmdc.162/modified01_merged/tests/gcp/getEquipmentDetails
查看进程 top
cd .Skype/
mv a b 移除并且替换
cd .Skype/
类似的还有一个_6 :::
/sandbox/attworkspace/modified01_merged_bduis/plsql/com/att/grdb/services/helper/externalgeocodes/AbstrctGcdQryHndlrSttcs.pkb
这个要不要改？？
AbstrctGcdQryHndlrSttcs.query_text_where_end_1
:= ‘and (skv.source_value in ( ”’ || CHR (10);
AbstrctGcdQryHndlrSttcs.query_text_where_end_2
:= ”’))’ || CHR (10);
inout 可读可写
encode也要执行
httpheader主要来存放cookie 信息的
httpbody主要用来存放post的一些数据，比如username =”xxxx”&password=”124”还有就是要上传的图片的nsdata数据
AnydataSetHasNext_bduis 有没有下一个数值RtrtcrctlnktmSetHasNext
AnydataSetNext_bduis 设置下一个数值RoutertocircuitlinkitemSetNext
ignore_pls_integer(l_anydata.getobject(l_rtc_link_item_curr));
/sandbox/attworkspace/modified01_merged_bduis/plsql/com/att/grdb/services/interfaces/dataprovider/IGetDataForIPAddressSvc/DataForIpAddressItem.tyb
定义写在begin的前面
哪里设置 body 哪里设置header?
行数查找快捷方式： 出现两个冒号
vim ~/.bashrc
GetAllConnectedManagedPVCSummaryFromVPNSvc.this.
指的是父类的方法
AnydataSet_bduis ()
for i in 1..l_ar_str.coutn
l_ar_strs.
l_ar_strs(i) := l_ar_str(i) ;
可以直接转换/////varchaarry 和varchar2arry
Character.isDigit(arStrs[3].charAt(iIdx)) 翻译明天问
显示类的名字
dbms_output.put_line(’ SELF .query_handler.TYPE======’||anydata.convertobject(SELF .query_handler).gettypename());
this.medxItemCurr.setInstallDate(argRs.getDate( “InstallDate”));
\t router.swdateinstalled
InstallDate, \n” +
l_set_items
p_arg_ret_in .list_mpsfv_is IS NOT NULL AND
p_arg_ret_in .list_mpsfv_is.COUNT & 0 THEN
l_set_items
AnydataSet_bduis();
/sandbox/attworkspace/modified01_merged_bduis/plsql/com/att/grdb/services/interfaces/dataprovider/IGetDataForIPAddressSvc/ReturnType_11.tyb
这里类似没有翻译的方法
l_ip_addr_item
l_pvc_item
FOR l_i IN 0..(p_arg_ret_in .list_mpsfv_is.COUNT - 1)
l_pvc_item
:= p_arg_ret_in .list_mpsfv_is(l_i
l_ip_addr_item
:= DataForIpAddressItem.convert_from_managed_pvc_smry (l_pvc_item );
l_set_items .put(anydata.convertobject (l_ip_addr_item) );
l_set_items
IS NOT NULL THEN
:= AnydataArray ();
l_fcall_tmp
:= AnydArryAddAllFromSet_bduis (l_ret , l_set_items );
InterfaceDetailItem
DtfrpddrsstmArr1AddAllFromSet (p_dest_lst IN OUT NOCOPY DataforipaddressitemArray , p_source_set IN OUT NOCOPY
/* UNTRANSLATED TYPE: Set */ AnydataSet_bduis ) RETURN
BOOLEAN IS
l_modified BOOLEAN ; l_set_elem_iterator MapI l_set_elem DataForIpAddressI
l_modified
l_set_elem_iterator
:= MapIterator ();
DataforipaddressitemSetHasNext (p_source_set , l_set_elem_iterator )
WHILE AnydataSetHasNext_bduis(p_source_set,l_set_elem_iterator)
– l_set_elem
:= DataforipaddressitemSetNext (p_source_set , l_set_elem_iterator );
l_anydata :=AnydataSetNext_bduis (p_source_set , l_set_elem_iterator );
ignore_pls_integer(l_anydata.getobject(l_set_elem));
DataforipaddressitemArray1Add (p_dest_lst , l_set_elem );
l_modified
GetManagedEquipDetailSvc
– l_lst_req_gems_ids
/* NOT TRANSLATED: asList(arGemsIds) */ NULL;
FOR i in 1..l_ar_gems_ids.COUNT LOOP
l_lst_req_gems_ids.EXTEND;
l_lst_req_gems_ids(i)
anydata.convertvarchar2(l_ar_gems_ids(i));
dbms_output.put_line(’ ======118===GetDataForIpAddress=======’ );
elseif的写法
var_number := 10;
if var_number & 100 then
dbms_output.put_line(var_number||’ is greater than 100’);
elsif var_number & 100 then
dbms_output.put_line(var_number||’ is less than 100’);
dbms_output.put_line(var_number||’ is equal to 100’);
GetManagedEquipDetailSvc
SqlQueryHandlerForEquipDetail
get_icr_vpn_data_for_curr_btch没做
schema 获取到值
l_str_prop :=get_property_bduis(CpeDataByAibPiidRtrvrSttcs.prop_key_clarify_base||’.Clarify.Schema’);
l_str_prop
IS NOT NULL THEN CpeDataByAibPiidRtrvrSttcs.db_schema
:= l_str_ END IF;
log_debug (‘CpeDataByAibPiidRetriever: _prepareValuesFromAppProps(): dbSchema:
”’ || CpeDataByAibPiidRtrvrSttcs.db_schema
– l_str_prop
:= AppProperties.get_app_property_as_string (IcrVpnDataFromPvcIdHndlrSttcs.prop_key_icore_schema );
l_str_prop := get_property_bduis(IcrVpnDataFromPvcIdHndlrSttcs.prop_key_icore_schema);
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-06512: at “SHERRY.GETDATAFORIPADDRESS”, line 246
就是前面是空值不能调用函数
CREATE OR REPLACE FUNCTION inst_of_mngd_eqp_det_ext_item (p_obj IN ANYDATA ) RETURN BOOLEAN IS
l_tmp_1 AnyD l_tmp ManagedEquipDetailExtI l_t_obj ManagedEquipDetailExtI
target_type VARCHAR2 (32767);
BEGIN l_tmp_1
IS NOT NULL THEN
target_type := l_tmp_1.gettypename();
IF upper(target_type) = upper(‘ManagedEquipDetailExtItem’) THEN
IGNORE_PLS_INTEGER (l_tmp_1.getObject (l_tmp ));
RETURN FALSE;
RETURN TRUE;
EXCEPTION WHEN others
THEN BEGIN log_exception();RETURN FALSE; END; END;
map_clli_to_addr_id
往下看的时候若是类型转来转去那么还是保留原来的类型不变。
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：4518次
排名：千里之外
原创：10篇
(1)(2)(1)(1)(1)(1)(3)(2)(1)