This discussion is archived
2 Replies Latest reply: Apr 28, 2010 9:14 AM by Octopus Rex RSS

Bind variable not fully enabled

Octopus Rex Expert
Currently Being Moderated
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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points