OIP-04122: Bind variable not fully enabled

From: iCS <oldos_at_wanadoo.fr>
Date: Tue, 12 Aug 2003 11:25:49 +0200
Message-ID: <bhabr5$am7$1_at_news-reader5.wanadoo.fr>



Hi !

I would like to execute a stored procedure from an ASP page but the folowing  line code would get OIP-04122 error :

OraDatabase.Parameters.Add "DIR", DIR, ORAPARM_OUTPUT, 1

could someone help me ....
thanks

here is the entire procedure :

Public Sub GET_NOM_FIC(ByRef DIR, ByRef NOM, FICHIER, ByRef OraDatabase)

   OraDatabase.Parameters.Add "DIR", DIR, ORAPARM_OUTPUT, 1 [Quoted]     OraDatabase.Parameters.Add "NOM", NOM, ORAPARM_OUTPUT, 1     OraDatabase.Parameters.Add "FICHIER", FICHIER, ORAPARM_INPUT, 114   'OraDatabase.ExecuteSQL ("Begin asp.GET_NOM_FIC(:DIR, :NOM, :FICHIER); end;",0)

  DIR = OraDatabase.Parameters("DIR").Value   NOM = OraDatabase.Parameters("NOM").Value

  OraDatabase.Parameters.Remove "DIR"
  OraDatabase.Parameters.Remove "NOM"
  OraDatabase.Parameters.Remove "FICHIER"
End Sub Received on Tue Aug 12 2003 - 11:25:49 CEST

Original text of this message