LightDB24.1 lt_package系统表字段 pkgboby一行长度限制为8160

背景

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;
/