分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
1,ORA-00600:内部错误代码
Oracle从11.2.0.1升级到11.2.0.4,开发人员报告说一个job运行失败,调试有报错信息,ORA-00600:内部错误代码,参数:[rwoirw: check ret val],[],[],[],[],ORA-06512:…,如下图所示:
C:\pic\oracle\2017040501.png
查看这个2000行的包体,查看到454行代码是一个create table as的很长的sql,如下所示:
PROCEDURE ads_amp_pd_ma_merchant_sale AS v_createsql varchar2(32767); BEGIN PKG_COMMON.drop_table('ads_amp_pd_ma_merchant_sale'); v_createsql := ' create table ads_amp_pd_ma_merchant_sale as (select PKG_ADS_AMP_PD.PARTNER_ID as PARTNER_ID, 0 as PROJECT_ID, 0 as CONT_ID, zjwgsals.bis_shop_name as BRAND_NAME, zjwgsals.sales_money as SALE_AMOUNT, 0 as BUDGET_AMOUNT, decode(zjwgsals.rent_square, 0, 0, round(zjwgsals.sales_money / zjwgsals.rent_square, 2)) as PERFORMANCE_VALUE, decode(zjwgsals.sales_money, 0, 0, round(zjwgsals.must_zj / zjwgsals.sales_money, 2)) as RENT_SALE_RATE, decode(zjwgsals.sort_name_root, ''超市'', ''100'', ''影院'', ''200'', ''百货'', ''300'', ''服装'', ''400
|