背景

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 broker_realtime_req istype cur_regus is ref cursor;
/*****************************  3.3    自  营  业  务  检  查  *********************************************************************/procedure qo_selfRun_transactionWater( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2,vc_stockcode_p in varchar2);procedure qo_selfRun_takePosition( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_querydate_p in varchar2, l_typeid_p in varchar2);procedure qo_selfRun_movementOfMarket( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure fo_selfRun_digestcls(v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, vc_id_p in varchar2);procedure fo_selfRun_digest(v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, vc_id_p in varchar2);procedure qo_selfRun_currentAcct_list( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_market_p in varchar2, l_secustatus_p in varchar2);procedure qo_selfRun_qryAcctFrmTrdflow( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_market_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);PROCEDURE qo_selfRun_role_list( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_pagesize in varchar2, v_pageindex in varchar2 );PROCEDURE qo_selfRun_operatorQuery( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_roleid_p in varchar2, vc_opername_p in varchar2);procedure qo_selfRun_stock_sort( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2,l_querydate_p in varchar2, l_sorttype_p in varchar2, l_querycount_p in varchar2);procedure qo_selfRun_singleStk_holdInfo( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2,l_market_p in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_selfRun_businessHoldInfo( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2,l_busincode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_selfRun_businHldDtls_byDate( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2,l_busincode_p in varchar2, l_querydate_p in varchar2);procedure qo_selfRun_specailStockQeury( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcodes_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_selfRun_fundflow_query( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_selfRun_commandflow_query( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_selfRun_menu( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2);procedure qo_selfRun_operator_authority( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_operatorid_p in varchar2);procedure qo_selfRun_specialstk_holdsum( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2,vc_stockcode_p in varchar2, l_querydate_p in varchar2);procedure qo_selfRun_specialstk_holdlist( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcode_p in varchar2, l_querydate_p in varchar2);procedure qo_selfRun_specstk_matchstat( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_selfRun_matchstat_bydate( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2,vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_selfRun_profitquery( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);
/***********************************************************************************************************************************/
/****************************  3.4	   资  产  管  理  检  查  *********************************************************************/procedure qo_product_select( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_pagesize in varchar2, v_pageindex in varchar2);procedure qo_product_marketvalue( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_productid_p in varchar2     );procedure qo_product_marketvalue_list( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_productid_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure fo_cam_digestcls(v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, vc_id_p in varchar2);procedure fo_cam_digest(v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, vc_id_p in varchar2);procedure qo_cam_currentAcct_list( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2,  l_market_p in varchar2, l_secustatus_p in varchar2    );procedure qo_cam_qryAcctFrmTrdflow( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_market_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2  );procedure qo_cam_role_list( v_errcode out INT, v_errmsg out varchar2,  cursor_result out broker_realtime_req.cur_regus,  v_length out varchar2,  v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2 );PROCEDURE qo_cam_operatorQuery( v_errcode out int, v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_roleid_p in varchar2, vc_opername_p in varchar2);procedure qo_cam_FundQuery( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in VARCHAR2);procedure qo_cam_stock_sort( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_querydate_p in varchar2, l_sorttype_p in varchar2, l_querycount_p in varchar2);procedure qo_cam_singleStk_holdInfo( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_cam_businessHoldInfo( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_busincode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_cam_businHldDtls_byDate( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_busincode_p in varchar2, l_querydate_p in varchar2);procedure qo_cam_specailStockQeury( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcodes_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2 );procedure qo_cam_fundflow_query( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_cam_commandflow_query( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_cam_menu( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2 );procedure qo_cam_operator_authority( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_operatorid_p in varchar2 );procedure qo_cam_specialstk_holdsum( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 该字段为空表示所有账号，非空表示指定账号；vc_stockcode_p in varchar2, l_querydate_p in varchar2);procedure qo_cam_specialstk_holdlist( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcode_p in varchar2, l_querydate_p in varchar2);procedure qo_cam_specstk_matchstat( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_cam_matchstat_bydate( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure fo_dam_digestcls(v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, vc_id_p in varchar2);procedure fo_dam_digest(v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, vc_id_p in varchar2);procedure qo_dam_currentAcct_list( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_market_p in varchar2, l_secustatus_p in varchar2);procedure qo_dam_qryAcctFrmTrdflow( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_market_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);PROCEDURE fo_dam_role_list( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2);PROCEDURE fo_dam_operatorQuery( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_roleid_p in varchar2, vc_opername_p in varchar2);procedure qo_dam_FundQuery( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_dam_stock_sort( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_querydate_p in varchar2, l_sorttype_p in varchar2, l_querycount_p in varchar2);procedure qo_dam_singleStk_holdInfo( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_dam_businessHoldInfo( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_busincode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_dam_businHldDtls_byDate( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_busincode_p in varchar2, l_querydate_p in varchar2);procedure qo_dam_specailStockQeury( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcodes_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_dam_fundflow_query( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_dam_commandflow_query( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_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 qo_dam_menu( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2 );procedure qo_dam_operator_authority( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, l_operatorid_p in varchar2 );procedure qo_dam_specialstk_holdsum( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 该字段为空表示所有账号，非空表示指定账号；vc_stockcode_p in varchar2, l_querydate_p in varchar2);procedure qo_dam_specialstk_holdlist( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcode_p in varchar2, l_querydate_p in varchar2);procedure qo_dam_specstk_matchstat( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_dam_matchstat_bydate( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。vc_stockcode_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2);procedure qo_cam_ProductDataCompare( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_fundid_p in varchar2, l_querydate_p in varchar2);
/***********************************************************************************************************************************/
/************************  b  a  s  i  c      p  u  b  l i  c  *********************************************************************/function get_qo_businame_byassetclass(c_asset_class_p in char) return varchar2;function get_qo_businame_bybusincode(l_busincode_p in number) return varchar2;function get_assetclass(l_busincode_p in number) return varchar2;function get_marketno(l_market_p in VARCHAR2) return varchar2;function get_qo_marketname(c_market_no_p in char) return varchar2;function get_stockholder_status(l_secustatus_p in VARCHAR2) return varchar2;function get_qo_stockholderstatus_name(c_stockholder_status_p in char) return varchar2;function get_qo_fundstatus_name(c_status_p in char) return varchar2;
/***********************************************************************************************************************************/
/************************  b  u  s  i  n  e  s  s       p  u  b  l i  c  ***********************************************************/procedure get_qo_digestcls(vc_id_p in varchar2,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);procedure get_qo_digest(vc_id_p in varchar2,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);procedure qo_currentAcct_list( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, l_market_p in varchar2, l_secustatus_p in varchar2,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_qryAcctFrmTrdflow( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in CHAR, l_market_p in varchar2, l_startdate_p in number, l_enddate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_role_list( v_pageindex in varchar2, v_pagesize in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_operatorQuery( v_pageindex in varchar2, v_pagesize in number,  c_fundtype_p in char, -- 内部调用时传入，vc_roleid_p in varchar2, vc_opername_p in varchar2, v_errcode out number,v_errmsg out varchar2,cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_stock_sort( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_querydate_p in number, l_sorttype_p in number, l_querycount_p in number, v_errcode out number,v_errmsg out varchar2,cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_singleStock_holdInfo( v_pageindex in varchar2, v_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, v_errcode out number,v_errmsg out varchar2,cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_businessHoldInfo( v_pageindex in varchar2, v_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, v_errcode out number,v_errmsg out varchar2,cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_businessHoldDetails_byDate( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。l_busincode_p in number, l_querydate_p in number, v_errcode out number,v_errmsg out varchar2,cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_specailStockQeury( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_stockcodes_p in varchar2, l_startdate_p in number, l_enddate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_fundflow_query( v_pageindex in varchar2, v_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,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_commandflow_query( v_pageindex in varchar2, v_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,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_menu( v_pageindex in varchar2, v_pagesize in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_operator_authority( v_pageindex in varchar2, v_pagesize in number, l_operatorid_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_specialstock_holdsum( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2, -- 该字段为空表示所有账号，非空表示指定账号；vc_stockcode_p in varchar2, l_querydate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_specialstock_holdlist( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_stockcode_p in varchar2, l_querydate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_specailstock_matchstat( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_stockcode_p in varchar2, l_startdate_p in number, l_enddate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_specstk_matchstat_bydate( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2, -- 基金类型是自营时，该字段为空；非自营时，该字段必须传入值。vc_stockcode_p in varchar2, l_startdate_p in number, l_enddate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_profitquery( v_pageindex in varchar2, v_pagesize in number, l_startdate_p in number, l_enddate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_FundQuery(v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, -- 内部调用时传入，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,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);procedure qo_ProductDataCompare( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, vc_fundid_p in varchar2, l_querydate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2 , v_sql out varchar2);procedure qo_transactionWater( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in varchar2, l_startdate_p in number, l_enddate_p in number,vc_stockcode_p in varchar2,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);procedure qo_takePosition( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, l_querydate_p in number, l_typeid_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);procedure qo_movementOfMarket( v_pageindex in varchar2, v_pagesize in number, c_fundtype_p in char, l_startdate_p in number, l_enddate_p in number,v_errcode out number,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_sql out varchar2);procedure q_product_select( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2, v_pagesize in varchar2, v_pageindex in varchar2, v_sql out varchar2);procedure q_product_marketvalue( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_productid_p in varchar2 , v_sql out varchar2    );procedure q_product_marketvalue_list( v_errcode out int,v_errmsg out varchar2, cursor_result out broker_realtime_req.cur_regus, v_length out varchar2, v_pagingstr out varchar2,v_pagesize in varchar2, v_pageindex in varchar2, vc_productid_p in varchar2, l_startdate_p in varchar2, l_enddate_p in varchar2 , v_sql out varchar2);
/***********************************************************************************************************************************/
end broker_realtime_req;
/