Stored procedures oracle parameter marker


Author
Message
John Frankewicz
John Frankewicz
StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)StrataFrame Beginner (40 reputation)
Group: Forum Members
Posts: 36, Visits: 65
There is an example in your documentation regarding stored procedures in VB land: You need more C# examples Smile

  Dim loCommand As New SqlCommand()
   '-- Create the command
   loCommand.CommandText = "SELECT MAX(or_created) FROM Orders WHERE or_cust_pk = @cust_pk"
   loCommand.Parameters.Add("@cust_pk", SqlDbType.Int)
   loCommand.Parameters("@cust_pk").Value = CustomerPK
My question is are the parameter-marker the same for Oracle as they are for SQL?  I know in the ADO.NET world it's a '?'

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search