up vote 0 down vote favorite

In my case , I want store image to database(postgresql) using storeprocedure. my database is in server. I am converting the image into byte array in front end. Now i need to know How to pass the converted byte array to the store procedure.

I am using the following code right now,

  Dim xImgPath() As Byte = ConverttoByte(mPath)

  Dim xQry As String = "select public.fn_employee(row(" & id &,"," & xImgPath &"))::public.employee

but the above piece of code is not working,It is simply displaying compile time error in the front end, can anybody tell me how to pass a byte array into the storeprocedure in postgresql?

share|improve this question
what's the type of the column containing the byte array? – Davide Berra 5 hours ago
@DavideBerra Column type is bytea – GLOIER TECH. 5 hours ago
What's the compile time error say? – gsiems 1 hour ago

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.