2 Replies Latest reply on Apr 28, 2010 4:14 PM by Octopus Rex

    Bind variable not fully enabled

    Octopus Rex
      Hello to everyone.

      I'm debugging a VBA macro with the following code:

      Dim qry_1 As String
      OraDatabase.Parameters.Add "ext_var1", UserForm3.TextBox1.Text, 1
      qry_1 = "begin SELECT max(name) into :clinom FROM sap_customers WHERE & " cust_number = :ext_var1; end;"
      OraDatabase.Parameters.Add "clinom", 0, ORAPARM_OUTPUT

      While executing the last code line i'm receiving the following message:
      OIP-04122:Bind variable not fully enabled

      Can please anyone tell me what am i doing wrong?

      Thanks in advance.