473,387 Members | 1,342 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

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
2 2843
Killer42
8,435 Expert 8TB
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
riyap
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

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

Similar topics

1
by: A Rothberg | last post by:
Is it possible to use NEWID() as a parameter to a stored procedure in SQL Server 2000. I keep getting a "Line 1: Incorrect syntax near ')'" error. ALTER PROCEDURE dbo.StoredProcedure1 ( @x...
1
by: Thilo-Alexander Ginkel | last post by:
Hello, I am currently trying to assign some string to a TEXT output parameter of a stored procedure. The basic structure of the stored procedure looks like this: -- 8< -- CREATE PROCEDURE...
4
by: ronloxton | last post by:
Hi All: I am attemting to write some Visual Basic Scripts that will call a DB2 stored procedure and get the return value. The test scripts are shown below. Not sure why I cannot get the...
8
by: Christopher Weaver | last post by:
I'm having trouble accessing the value of an output parameter of a stored procedure. The SP looks like this: SET TERM ^ ; CREATE PROCEDURE SP_NEW_TASK RETURNS ( "uidTask" INTEGER) AS begin
1
by: rAinDeEr | last post by:
Hi, I am writing a stored procedure in db2, and I want to return a cursor as an out parameter of the stored procedure How can I accomplish that.... Thanks in advance RaInDeEr
0
by: Sudarsana | last post by:
How to retrieve output parameter value in ASp from Stored Procedure
0
by: pisgasys | last post by:
Hi, I need to send xml file as a parameter to SQL stored procedure from Access VBA form.. I wrote code that handle sending parameters from a textbox input.. but if I need to send xml file, what...
0
by: somadritadas23 | last post by:
How to view a CLOB Output parameter returned from a procedure in DB2 control Center(DB2 9.5).I have a procedure ABC having an output parameter ORET of CLOB datatype.This is ideally a long sql query...
0
vavc1980
by: vavc1980 | last post by:
I'm using a stored procedure from an ASP page using a ADODB connection, the sproc returns a value and also has an output parameter. Both are being read in the page but they are both empty, I...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.