www.Orasql.Com
 
用户名: 密码:  验证码: 注册|找回密码 oracleawen's blog  
 
         当前位置 >> 技术论坛  发表帖子     论坛版块     查找帖子
昨日碰到的一個delphi程式問題-技术论坛||Oracle高手之路—Orasql.Com!
            昨日碰到的一個delphi程式問題
 
发贴人:oracle_awen
oracleawen@gmail.com448315233127.0.0.1
用户级别:管理员
发贴总数:1245
注册时间:2011-05-05 09:23:03
2011-06-01 08:15:45
昨日碰到的一個delphi程式問題 delphi程式每次執行存儲過程時會調用tadostoredproc控件的 parameters.refresh方法得到存儲過程的參數列表 這玩意一調用就會執行一個很閘的sql,邏輯讀1600多,程式修改中 / formatted on 2010/12/03 1416 (formatter plus v4.8.8) / select procedure_catalog, procedure_schema, procedure_name, parameter_name, ordinal_position, parameter_type, parameter_hasdefault, parameter_default, is_nullable, data_type, character_maximum_length, character_maximum_length character_octet_length, numeric_precision, numeric_scale, description, type_name, type_name, overload from (select null procedure_catalog, owner procedure_schema, decode (package_name, null, object_name, package_name || '.' || object_name ) procedure_name, decode (position, 0, 'return_value', nvl (argument_name, chr (0)) ) parameter_name, position ordinal_position, decode (in_out, 'in', 1, 'in/out', 2, 'out', decode (argument_name, null, 4, 3), null ) parameter_type, null parameter_hasdefault, null parameter_default, 65535 is_nullable, decode (data_type, 'char', 129, 'nchar', 129, 'date', 135, 'float', 139, 'long', 129, 'long raw', 128, 'number', 139, 'raw', 128, 'rowid', 129, 'varchar2', 129, 'nvarchar2', 129, 13 ) data_type, decode (data_type, 'char', decode (data_length, null, 2000, data_length ), 'long', 2147483647, 'long raw', 2147483647, 'rowid', 18, 'raw', decode (data_length, null, 2000, data_length), 'varchar2', decode (data_length, null, 4000, data_length ), 'date', null, 'float', null, 'number', null, null ) character_maximum_length, decode (data_type, 'date', 19, 'float', 15, 'number', decode (data_precision, null, 0, data_precision ), 'char', null, 'nchar', null, 'long', null, 'long raw', null, 'raw', null, 'varchar2', null, 'nvarchar2', null, null ) numeric_precision, decode (data_type, 'date', 0, 'number', decode (data_scale, null, 0, data_scale), 'char', null, 'nchar', null, 'float', null, 'long', null, 'long raw', null, 'raw', null, 'varchar2', null, 'nvarchar2', null, null ) numeric_scale, null description, data_type type_name, overload from all_arguments where data_level = 0 and data_type is not null) procedure_parameters where procedure_name = 'count_rec' order by 1, 2, 3, 5;

      
 
  
 Orasql.Com|E-Mail:oracleawen@gmail.com|Phone:15271942915|Copyright © 2011|All Rights Reserved|