• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Oracle & VB

Oracle & VB

Oracle & VB

API Declarations



procedure Test(inPARM in varchar2,outPARM out varchar2);

Test is the name of oracle procedure, it has two parameters, one is IN type parameter (inPARM) and one is OUT type parameter (outPARM).



Rate Oracle & VB

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Public Function call_Test( )
 
Dim Cmd As New ADODB.Command
Dim inPARM As New ADODB.Parameter
Dim outPARM As New ADODB.Parameter
        
   
    inPARM.Direction = adParamInput
    inPARM.Type = adBSTR
    inPARM.Value = “Value of in type parameter”
    
    outPARM.Direction = adParamOutput
    outPARM.Type = adBSTR
    outPARM.Size = 100

    Cmd.ActiveConnection = lCon  ‘***ADO Active Connection
    Cmd.CommandText = "Test"
    
    Cmd.Parameters.Append inPARM
    Cmd.Parameters.Append outPARM
    Cmd.Execute

   
End Function