Click here to Skip to main content
15,917,652 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionI need help....!! Pin
Member 374662916-Jul-08 17:07
Member 374662916-Jul-08 17:07 
AnswerRe: I need help....!! Pin
Christian Graus16-Jul-08 17:59
protectorChristian Graus16-Jul-08 17:59 
GeneralRe: I need help....!! Pin
Paul Conrad17-Jul-08 16:43
professionalPaul Conrad17-Jul-08 16:43 
AnswerRe: I need help....!! Pin
Paul Conrad17-Jul-08 16:43
professionalPaul Conrad17-Jul-08 16:43 
Questionformatting numbers from a text box Pin
digicd116-Jul-08 11:06
digicd116-Jul-08 11:06 
AnswerRe: formatting numbers from a text box Pin
Mycroft Holmes16-Jul-08 20:17
professionalMycroft Holmes16-Jul-08 20:17 
GeneralRe: formatting numbers from a text box Pin
digicd122-Jul-08 10:49
digicd122-Jul-08 10:49 
QuestionORA-06502: PL/SQL: numeric or value error: character string buffer too smal Pin
ljammala16-Jul-08 10:39
ljammala16-Jul-08 10:39 
I installed Oracle 9.2.0.1.0 client on my machine and wrote the following piece of code to call a stored function from my asp.net application

Imports System
Imports System.Data.OracleClient
Imports System.Data.Common
Imports System.Configuration
Imports System.Data


Dim connection As OracleConnection = Nothing


connection = New OracleConnection(ConfigurationManager.ConnectionStrings("Conn1").ToString())
Dim command As OracleCommand = New OracleCommand("dtx_ivr_sf", connection)
'command.Connection = connection
'command.CommandText = "dtx_ivr_sf(P_parcel_id)"
command.CommandType = CommandType.StoredProcedure

Dim RetVal As New OracleParameter("RetVal", OracleType.VarChar, 200)

Dim P_parcel_id As New OracleParameter("P_parcel_id", OracleType.VarChar, 10)

RetVal.Direction = ParameterDirection.ReturnValue

P_parcel_id.Direction = ParameterDirection.Input
P_parcel_id.Value = "0000006611"

command.Parameters.Add(RetVal)
command.Parameters.Add(P_parcel_id)


connection.Open()
command.ExecuteNonQuery()

Dim str As String = RetVal.Value.ToString()
If Not String.IsNullOrEmpty(str) Then
m_boo_IsDelinquent = True
End If

But I am getting an exception on "command.ExecuteNonQuery()" as

"ORA-06502: PL/SQL: numeric or value error: character string buffer too smal"

Do I need to install odp.net for this? Please help. I know my Oracle stored function is working fine, as I can run it from Oracle forms. Any help is appreciated
AnswerRe: ORA-06502: PL/SQL: numeric or value error: character string buffer too smal Pin
Mycroft Holmes16-Jul-08 20:22
professionalMycroft Holmes16-Jul-08 20:22 
GeneralRe: ORA-06502: PL/SQL: numeric or value error: character string buffer too smal Pin
ljammala17-Jul-08 2:15
ljammala17-Jul-08 2:15 
GeneralRe: ORA-06502: PL/SQL: numeric or value error: character string buffer too smal Pin
ljammala17-Jul-08 2:24
ljammala17-Jul-08 2:24 
QuestionNew Data Row Pin
zzsoulzz16-Jul-08 5:50
zzsoulzz16-Jul-08 5:50 
AnswerRe: New Data Row Pin
nlarson1116-Jul-08 6:52
nlarson1116-Jul-08 6:52 
AnswerRe: New Data Row Pin
paas16-Jul-08 6:59
paas16-Jul-08 6:59 
QuestionCalculating intervals using Dates Pin
KrisnNala16-Jul-08 5:41
KrisnNala16-Jul-08 5:41 
AnswerRe: Calculating intervals using Dates Pin
Luc Pattyn16-Jul-08 6:20
sitebuilderLuc Pattyn16-Jul-08 6:20 
GeneralRe: Calculating intervals using Dates Pin
KrisnNala16-Jul-08 7:21
KrisnNala16-Jul-08 7:21 
GeneralRe: Calculating intervals using Dates Pin
Luc Pattyn16-Jul-08 7:24
sitebuilderLuc Pattyn16-Jul-08 7:24 
GeneralRe: Calculating intervals using Dates Pin
KrisnNala16-Jul-08 7:34
KrisnNala16-Jul-08 7:34 
AnswerRe: Calculating intervals using Dates Pin
Guffa16-Jul-08 10:18
Guffa16-Jul-08 10:18 
AnswerRe: Calculating intervals using Dates Pin
Guffa16-Jul-08 10:18
Guffa16-Jul-08 10:18 
GeneralRe: Calculating intervals using Dates Pin
KrisnNala16-Jul-08 22:39
KrisnNala16-Jul-08 22:39 
GeneralRe: Calculating intervals using Dates Pin
Guffa17-Jul-08 1:15
Guffa17-Jul-08 1:15 
GeneralRe: Calculating intervals using Dates Pin
KrisnNala17-Jul-08 4:13
KrisnNala17-Jul-08 4:13 
QuestionHow to compile solution with mutliple project types properly? Pin
Jon_Boy16-Jul-08 4:09
Jon_Boy16-Jul-08 4:09 

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.