背景
oracle
plsql支持创建package和package boby,且支持的长度超过postgres所限定的8192个字节的长度(实际上postgres出去元组头部分所占的空间,长度肯定是小于8192字节的)。目前遇到的情况就是oracle环境下包的长度远远大于LightDB支持的长度。
LightDB
在建lt_package时,我们清楚的知道肯定会有字段超长的情况。因此我们在建表的时候就已将将toast属性赋给可能超长的字段了。
但是实际执行创建包和包体时,却报错。
那是那一块出现问题了?只能找相同模块看看可能出现遗漏的地方了。果然被找到了。
方法
原来定义的toast属性,会在toasting.h文件中利用DECLARE_TOAST去设置toast属性的OID。像text类型的字段需要toast存储,系统表的OID都是预置并且不允许修改,所以它们的TOAST同样需要预设。
设置OID时需要查询可执行文件unused_oids,查询未使用的OID。
测试
用一个超长sql测试即可
CREATE OR REPLACE package other_q_package_create_broker_realtime_req is
type cur_regus is ref cursor;
procedure test_for_package_length_transactionWater( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_startdate_p_in in varchar2, enddate_p_in in varchar2,vc_stockcode_p in varchar2
);
procedure test_for_package_length_takePosition( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, querydate in varchar2, l_typeid_p in varchar2);
procedure test_for_package_length_movementOfMarket( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);
procedure other_procedure_create_digestcls(other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, vc_id_p in varchar2);
procedure other_procedure_create_digest(other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, vc_id_p in varchar2);
procedure test_for_package_length_currentAcct_list( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_market_p in varchar2, l_secustatus_p in varchar2);
procedure test_for_package_length_qryAcctFrmTrdflow( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_market_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);
PROCEDURE test_for_package_length_role_list( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, pagesize in varchar2, pageindex in varchar2 );
PROCEDURE test_for_package_length_operatorQuery( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_roleid_p in varchar2, vc_opername_p in varchar2);
procedure test_for_package_length_stock_sort( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2,
querydate in varchar2, l_sorttype_p in varchar2, l_querycount_p in varchar2);
procedure test_for_package_length_singleStk_holdInfo( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2,
l_market_p in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure test_for_package_length_businessHoldInfo( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2,
l_busincode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure test_for_package_length_businHldDtls_byDate( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2,
l_busincode_p in varchar2, querydate in varchar2
);
procedure test_for_package_length_specailStockQeury( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcodes_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);
procedure test_for_package_length_fundflow_query( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_secuid_p in varchar2, l_market_p in varchar2, vc_digestids_p in varchar2, l_fundmin_p in varchar2, l_fundmax_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure test_for_package_length_commandflow_query( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, l_managerid_p in varchar2, l_executorid_p in varchar2, l_cmdserialno_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure test_for_package_length_menu( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2
);
procedure test_for_package_length_operator_authority( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_operatorid_p in varchar2
);
procedure test_for_package_length_specialstk_holdsum( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2,
vc_stockcode_p in varchar2, querydate in varchar2
);
procedure test_for_package_length_specialstk_holdlist( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcode_p in varchar2, querydate in varchar2
);
procedure test_for_package_length_specstk_matchstat( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure test_for_package_length_matchstat_bydate( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2,
vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure test_for_package_length_profitquery( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_select( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, pagesize in varchar2, pageindex in varchar2
);
procedure other_create_marketvalue( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_productid_p in varchar2 );
procedure other_create_marketvalue_list( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_productid_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_cam_digestcls(other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, vc_id_p in varchar2);
procedure other_create_cam_digest(other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, vc_id_p in varchar2);
procedure other_create_cam_currentAcct_list( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_market_p in varchar2, l_secustatus_p in varchar2 );
procedure other_create_cam_qryAcctFrmTrdflow( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_market_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2 );
procedure other_create_cam_role_list( other_errcode out INT, other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2 );
PROCEDURE other_create_cam_operatorQuery( other_errcode out int, other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_roleid_p in varchar2, vc_opername_p in varchar2
);
procedure other_create_cam_FundQuery( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in VARCHAR2);
procedure other_create_cam_stock_sort( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
querydate in varchar2, l_sorttype_p in varchar2, l_querycount_p in varchar2
);
procedure other_create_cam_singleStk_holdInfo( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
l_market_p in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_cam_businessHoldInfo( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
l_busincode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_cam_businHldDtls_byDate( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
l_busincode_p in varchar2, querydate in varchar2
);
procedure other_create_cam_specailStockQeury( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcodes_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2 );
procedure other_create_cam_fundflow_query( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_secuid_p in varchar2, l_market_p in varchar2, vc_digestids_p in varchar2, l_fundmin_p in varchar2, l_fundmax_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_cam_commandflow_query( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, l_managerid_p in varchar2, l_executorid_p in varchar2, l_cmdserialno_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_cam_menu( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2 );
procedure other_create_cam_operator_authority( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_operatorid_p in varchar2 );
procedure other_create_cam_specialstk_holdsum( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, querydate in varchar2
);
procedure other_create_cam_specialstk_holdlist( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcode_p in varchar2, querydate in varchar2
);
procedure other_create_cam_specstk_matchstat( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_cam_matchstat_bydate( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_digestcls(other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, vc_id_p in varchar2);
procedure other_create_dam_digest(other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, vc_id_p in varchar2);
procedure other_create_dam_bb_currentAcct_list( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_market_p in varchar2, l_secustatus_p in varchar2
);
procedure other_create_dam_bb_qryAcctFrmTrdflow( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_market_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
PROCEDURE other_create_dam_role_list( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2
);
PROCEDURE other_create_dam_operatorQuery( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_roleid_p in varchar2, vc_opername_p in varchar2
);
procedure other_create_dam_bb_FundQuery( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_custom_name_p in varchar2, vc_idcard_p in varchar2, vc_secuid_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_bb_stock_sort( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
querydate in varchar2, l_sorttype_p in varchar2, l_querycount_p in varchar2
);
procedure other_create_dam_bb_singleStk_holdInfo( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
l_market_p in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_bb_businessHoldInfo( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
l_busincode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_bb_businHldDtls_byDate( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
l_busincode_p in varchar2, querydate in varchar2
);
procedure other_create_dam_bb_specailStockQeury( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcodes_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_bb_fundflow_query( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_secuid_p in varchar2, l_market_p in varchar2, vc_digestids_p in varchar2, l_fundmin_p in varchar2, l_fundmax_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_bb_commandflow_query( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, l_managerid_p in varchar2, l_executorid_p in varchar2, l_cmdserialno_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_bb_menu( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2 );
procedure other_create_dam_bb_operator_authority( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, l_operatorid_p in varchar2 );
procedure other_create_dam_bb_specialstk_holdsum( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, querydate in varchar2
);
procedure other_create_dam_bb_specialstk_holdlist( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcode_p in varchar2, querydate in varchar2
);
procedure other_create_dam_bb_specstk_matchstat( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_dam_bb_matchstat_bydate( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2
);
procedure other_create_cam_ProductDataCompare( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_fundid_p in varchar2, querydate in varchar2
);
function other_function_create_qo_businame_byassetclass(c_asset_class_p in char) return varchar2;
function other_function_create_qo_businame_bybusincode(l_busincode_p in number) return varchar2;
function other_function_create_assetclass(l_busincode_p in number) return varchar2;
function other_function_create_marketno(l_market_p in VARCHAR2) return varchar2;
function other_function_create_qo_marketname(c_market_no_p in char) return varchar2;
function other_function_create_stockholder_status(l_secustatus_p in VARCHAR2) return varchar2;
function other_function_create_qo_stockholderstatus_name(c_stockholder_status_p in char) return varchar2;
function other_function_create_qo_fundstatus_name(c_status_p in char) return varchar2;
procedure other_function_create_qo_digestcls(vc_id_p in varchar2,other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);
procedure other_function_create_qo_digest(vc_id_p in varchar2,other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);
procedure other_qo_function_create_currentAcct_list( pageindex in varchar2, pagesize in number, c_fundtype_p in char, l_market_p in varchar2, l_secustatus_p in varchar2,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_qryAcctFrmTrdflow( pageindex in varchar2, pagesize in number, c_fundtype_p in CHAR, l_market_p in varchar2, l_startdate_p in number, l_enddate_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_role_list( pageindex in varchar2, pagesize in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_operatorQuery( pageindex in varchar2, pagesize in number, c_fundtype_p in char,
vc_roleid_p in varchar2, vc_opername_p in varchar2, other_errcode out number,other_errmsg out varchar2,
result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_stock_sort( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
querydate in number, l_sorttype_p in number, l_querycount_p in number, other_errcode out number,other_errmsg out varchar2,
result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_singleStock_holdInfo( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
l_market_p in number, vc_stockcode_p in varchar2, l_startdate_p in number, l_enddate_p in number, other_errcode out number,other_errmsg out varchar2,
result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_businessHoldInfo( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
l_busincode_p in number, l_startdate_p in number, l_enddate_p in number, other_errcode out number,other_errmsg out varchar2,
result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_businessHoldDetails_byDate( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
l_busincode_p in number, querydate in number, other_errcode out number,other_errmsg out varchar2,
result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_specailStockQeury( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_stockcodes_p in varchar2, l_startdate_p in number, l_enddate_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_fundflow_query( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
vc_secuid_p in varchar2, l_market_p in number, vc_digestids_p in varchar2, l_fundmin_p in number, l_fundmax_p in number, l_startdate_p in number, l_enddate_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_commandflow_query( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, l_managerid_p in number, l_executorid_p in number, l_cmdserialno_p in number, l_startdate_p in number, l_enddate_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_menu( pageindex in varchar2, pagesize in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_operator_authority( pageindex in varchar2, pagesize in number, l_operatorid_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_specialstock_holdsum( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
vc_stockcode_p in varchar2, querydate in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_specialstock_holdlist( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_stockcode_p in varchar2, querydate in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_specailstock_matchstat( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_stockcode_p in varchar2, l_startdate_p in number, l_enddate_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_specstk_matchstat_bydate( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);
procedure other_qo_function_create_ProductDataCompare( pageindex in varchar2, pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2, querydate in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);
procedure other_qo_function_create_transactionWater( pageindex in varchar2, pagesize in number, c_fundtype_p in varchar2, l_startdate_p in number, l_enddate_p in number,vc_stockcode_p in varchar2,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);
procedure other_qo_function_create_takePosition( pageindex in varchar2, pagesize in number, c_fundtype_p in char, querydate in number, l_typeid_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);
procedure other_qo_function_create_movementOfMarket( pageindex in varchar2, pagesize in number, c_fundtype_p in char, l_startdate_p in number, l_enddate_p in number,
other_errcode out number,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);
procedure other_q_procedure_create__select( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, pagesize in varchar2, pageindex in varchar2, v_sql out varchar2);
procedure other_q_procedure_create__marketvalue( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_productid_p in varchar2 , v_sql out varchar2 );
procedure other_q_procedure_create__marketvalue_list( other_errcode out int,other_errmsg out varchar2, result out other_q_package_create_broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,
pagesize in varchar2, pageindex in varchar2, vc_productid_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2 , v_sql out varchar2
);
/***********************************************************************************************************************************/
end other_q_package_create_broker_realtime_req;
/