By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,594 Members | 2,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,594 IT Pros & Developers. It's quick & easy.

hi output parameter value in vb.net(stored Procedure)

P: 21
hi can anyone let me know how to get a output param value from stored procedure
i used following code to get the o/p value from stored procedure
so near .value what i need to give
if keep it blank it is giving me error
for input we can give a value but not for output
what i need to write near "?????"

sqlComm = New OracleCommand

sqlComm.Parameters.Add(New OracleParameter("p_title", OracleType.VarChar)).Value = title
sqlComm.Parameters.Item("p_title").Direction = ParameterDirection.Input
sqlComm.Parameters.Add(New OracleParameter("pid", OracleType.VarChar)).Value = "???????"
sqlComm.Parameters.Item("pid").Direction = ParameterDirection.Output
thanks in advance
Nov 28 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 5K+
P: 8,434
I don't understand what you mean. You're just creating new parameters at this point, so how could it have any output value?
Nov 29 '07 #2

P: 21
I don't understand what you mean. You're just creating new parameters at this point, so how could it have any output value?
i already created package in oracle database
and these are the 2 param im passing if i send the input param il get the output param value
but how to put the value there
im getting following error
ORA-01036: illegal variable name/number

can you help me with this
Nov 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.