fmmain.~dfm

delphi中调用oracle的存储过程[分带返回游标

object frm_Main: Tfrm_Main
  Left = 192
  Top = 107
  Width = 421
  Height = 330
  Caption = 'frm_Main'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 32
    Top = 16
    Width = 320
    Height = 120
    DataSource = DS
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object GroupBox1: TGroupBox
    Left = 32
    Top = 152
    Width = 313
    Height = 129
    Caption = 'GroupBox1'
    TabOrder = 1
    object Edit1: TEdit
      Left = 11
      Top = 21
      Width = 121
      Height = 21
      TabOrder = 0
      Text = 'Edit1'
    end
    object Edit2: TEdit
      Left = 11
      Top = 53
      Width = 121
      Height = 21
      TabOrder = 1
      Text = 'Edit2'
    end
    object Edit3: TEdit
      Left = 11
      Top = 85
      Width = 121
      Height = 21
      TabOrder = 2
      Text = 'Edit3'
    end
    object btnCallProc: TBitBtn
      Left = 152
      Top = 21
      Width = 75
      Height = 25
      Caption = 'CallProc'
      TabOrder = 3
      OnClick = btnCallProcClick
    end
    object btnQuery: TButton
      Left = 152
      Top = 53
      Width = 75
      Height = 25
      Caption = 'Query'
      TabOrder = 4
      OnClick = btnQueryClick
    end
    object Button1: TButton
      Left = 150
      Top = 83
      Width = 75
      Height = 25
      Caption = 'PNone'
      TabOrder = 5
      OnClick = Button1Click
    end
    object btnGetProc: TButton
      Left = 240
      Top = 24
      Width = 65
      Height = 25
      Caption = 'btnGetProc'
      TabOrder = 6
      OnClick = btnGetProcClick
    end
  end
  object dbConn: TADOConnection
    ConnectionString = 
      'Provider=OraOLEDB.Oracle.1;Password=jtest;Persist Security Info=' +
      'True;User ID=jtest;Data Source=lotto'
    LoginPrompt = False
    Provider = 'OraOLEDB.Oracle.1'
    Left = 88
    Top = 72
  end
  object DS: TDataSource
    DataSet = Query
    Left = 144
    Top = 72
  end
  object DSet: TADODataSet
    Connection = dbConn
    CursorType = ctStatic
    CommandText = '{call JxfOracleProc(?,?,?)}'
    Parameters = <>
    Left = 192
    Top = 72
  end
  object Query: TADOQuery
    Connection = dbConn
    Parameters = <>
    Left = 304
    Top = 72
  end
  object ADOQuery1: TADOQuery
    Connection = dbConn
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'SID'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 10
        Value = 'query'
      end
      item
        Name = 'SNAME'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 10
        Value = 'query'
      end
      item
        Name = 'INUM'
        Attributes = [paSigned, paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 131
        Value = '10'
      end>
    SQL.Strings = (
      '{call JxfOracleProc(?,?,?)}')
    Left = 264
    Top = 72
  end
  object sp: TADOStoredProc
    Connection = dbConn
    Parameters = <>
    Left = 232
    Top = 72
  end
end