Click here to Skip to main content
15,885,985 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: A small doubt Pin
isidor719-May-07 8:36
isidor719-May-07 8:36 
Questionstrarting to learn remoting need help Pin
maytel mynt18-May-07 15:24
maytel mynt18-May-07 15:24 
AnswerRe: strarting to learn remoting need help Pin
MatrixCoder18-May-07 16:15
MatrixCoder18-May-07 16:15 
AnswerRe: strarting to learn remoting need help Pin
Dave Kreskowiak19-May-07 4:15
mveDave Kreskowiak19-May-07 4:15 
GeneralRe: strarting to learn remoting need help Pin
maytel mynt21-May-07 14:28
maytel mynt21-May-07 14:28 
QuestionDriver File name .SYS Pin
somchoto18-May-07 15:12
somchoto18-May-07 15:12 
AnswerRe: Driver File name .SYS Pin
Christian Graus18-May-07 15:30
protectorChristian Graus18-May-07 15:30 
QuestionOracle stored procedures with VB.net Pin
Larry Gaukel18-May-07 9:09
Larry Gaukel18-May-07 9:09 
Has anyone had experience executing Oracle stored procedures with input & output parameters with VB.net? I've researched online help, articles websites etc. but it does not work. The stored procedure has 5 parameters. The first 3 are Ouput, the 4th is In/Out and the 5th is Input. Here is a sample of the code being used:

Dim cmdAPI As OracleClient.OracleCommand
Dim drAPI As OracleClient.OracleDataReader


'specify API and setup command
pstrSQL = "Oracle_API_test"

cmdAPI = New OracleClient.OracleCommand(pstrSQL, pcnnOra)
cmdAPI.CommandType = CommandType.StoredProcedure

'setup stored procedure parameters
Dim info_ As New OracleClient.OracleParameter("info_", OracleClient.OracleType.VarChar, 256)
Dim objid_ As New OracleClient.OracleParameter("objid_", OracleClient.OracleType.VarChar, 256)
Dim objversion_ As New OracleClient.OracleParameter("objversion_", OracleClient.OracleType.VarChar, 256)
Dim attr_ As New OracleClient.OracleParameter("attr_", OracleClient.OracleType.VarChar, 2000)
Dim action_ As New OracleClient.OracleParameter("action_", OracleClient.OracleType.VarChar, 256)

'set value of parameters
cmdAPI.Parameters.Add(info_)
cmdAPI.Parameters(0).Direction = ParameterDirection.Output
cmdAPI.Parameters.Add(objid_)
cmdAPI.Parameters(1).Direction = ParameterDirection.Output
cmdAPI.Parameters.Add(objversion_)
cmdAPI.Parameters(2).Direction = ParameterDirection.Output
cmdAPI.Parameters.Add(attr_)
cmdAPI.Parameters(3).Direction = ParameterDirection.InputOutput
cmdAPI.Parameters(3).Value = "'PART_NO'||chr(31)||'LG003'||chr(30)||" _
& "'DESCRIPTION'||chr(31)||'Test Part3'||chr(30)||" _
& "'UNIT_CODE'||chr(31)||'EA'||chr(30)||" _
& "'CONDITION_CODE_USAGE'||chr(31)||'Not Allow Condition Code'||chr(30)"
cmdAPI.Parameters.Add(action_)
cmdAPI.Parameters(4).Direction = ParameterDirection.Input
cmdAPI.Parameters(4).Value = "'DO'"

'execute stored procedure
cmdAPI.ExecuteOracleNonQuery(0)

'analyze parameter values
strTmp = IIf(IsDBNull(cmdAPI.Parameters(0).Value), "null", cmdAPI.Parameters(0).Value)
TextBox1.Text = strTmp
strTmp = IIf(IsDBNull(cmdAPI.Parameters(1).Value), "null", cmdAPI.Parameters(1).Value)
TextBox2.Text = strTmp
strTmp = IIf(IsDBNull(cmdAPI.Parameters(2).Value), "null", cmdAPI.Parameters(2).Value)
TextBox3.Text = strTmp
strTmp = IIf(IsDBNull(cmdAPI.Parameters(3).Value), "null", cmdAPI.Parameters(3).Value)
TextBox4.Text = strTmp
strTmp = IIf(IsDBNull(cmdAPI.Parameters(4).Value), "null", cmdAPI.Parameters(4).Value)
TextBox5.Text = strTmp

cmdAPI.Dispose()
pcnnOra.Close()

Larry G
Prodev Solutions

AnswerRe: Oracle stored procedures with VB.net Pin
mr_lasseter19-May-07 5:22
mr_lasseter19-May-07 5:22 
AnswerRe: Oracle stored procedures with VB.net Pin
Larry Gaukel23-May-07 9:46
Larry Gaukel23-May-07 9:46 
Questionmultiline ListView vb.net 2005 Pin
Allwin0718-May-07 7:33
Allwin0718-May-07 7:33 
AnswerRe: multiline ListView vb.net 2005 Pin
Dave Kreskowiak18-May-07 9:56
mveDave Kreskowiak18-May-07 9:56 
Questioncaret line number (not the "just" line number ) Pin
NANCO18-May-07 5:48
NANCO18-May-07 5:48 
AnswerRe: caret line number (not the "just" line number ) Pin
Dave Kreskowiak18-May-07 6:36
mveDave Kreskowiak18-May-07 6:36 
GeneralRe: caret line number (not the "just" line number ) Pin
NANCO19-May-07 1:08
NANCO19-May-07 1:08 
GeneralRe: caret line number (not the "just" line number ) Pin
Dave Kreskowiak19-May-07 4:06
mveDave Kreskowiak19-May-07 4:06 
QuestionConvert image from 24bpp to 1bppindexed Pin
stuinstra35118-May-07 5:42
stuinstra35118-May-07 5:42 
AnswerRe: Convert image from 24bpp to 1bppindexed Pin
Dave Kreskowiak18-May-07 6:25
mveDave Kreskowiak18-May-07 6:25 
AnswerRe: Problem Fixed Pin
stuinstra35118-May-07 7:44
stuinstra35118-May-07 7:44 
Questioncheck database for fields Pin
jds120718-May-07 4:40
jds120718-May-07 4:40 
QuestionDataGridView databound to textboxes and CellValidating Pin
Marcus J. Smith18-May-07 4:00
professionalMarcus J. Smith18-May-07 4:00 
AnswerRe: DataGridView databound to textboxes and CellValidating Pin
kubben18-May-07 5:52
kubben18-May-07 5:52 
GeneralRe: DataGridView databound to textboxes and CellValidating Pin
Marcus J. Smith18-May-07 7:24
professionalMarcus J. Smith18-May-07 7:24 
GeneralRe: DataGridView databound to textboxes and CellValidating Pin
kubben18-May-07 7:30
kubben18-May-07 7:30 
GeneralRe: DataGridView databound to textboxes and CellValidating Pin
Marcus J. Smith18-May-07 7:46
professionalMarcus J. Smith18-May-07 7:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.