Click here to Skip to main content
15,902,908 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questioncalculator Pin
lefa mokoena27-May-21 2:16
lefa mokoena27-May-21 2:16 
AnswerRe: calculator PinPopular
Richard Deeming27-May-21 3:04
mveRichard Deeming27-May-21 3:04 
QuestionAlign icon to the center in ListSubItem ListView VB6 Pin
Sal Sal19-May-21 3:41
Sal Sal19-May-21 3:41 
QuestionRe: Align icon to the center in ListSubItem ListView VB6 Pin
CHill6021-May-21 2:58
mveCHill6021-May-21 2:58 
AnswerRe: Align icon to the center in ListSubItem ListView VB6 Pin
Sal Sal21-May-21 4:00
Sal Sal21-May-21 4:00 
GeneralRe: Align icon to the center in ListSubItem ListView VB6 Pin
Victor Nijegorodov21-May-21 6:26
Victor Nijegorodov21-May-21 6:26 
GeneralRe: Align icon to the center in ListSubItem ListView VB6 Pin
CHill6021-May-21 6:44
mveCHill6021-May-21 6:44 
QuestionSimple But Professional Visual Basic Auto Typer Pin
ThomasEngine113-May-21 7:46
ThomasEngine113-May-21 7:46 
AnswerRe: Simple But Professional Visual Basic Auto Typer Pin
Dave Kreskowiak13-May-21 9:00
mveDave Kreskowiak13-May-21 9:00 
Questionget colour at pixel Pin
ducpkh22-Apr-21 4:40
ducpkh22-Apr-21 4:40 
AnswerRe: get colour at pixel Pin
Richard Deeming22-Apr-21 5:00
mveRichard Deeming22-Apr-21 5:00 
AnswerRe: get colour at pixel Pin
Dave Kreskowiak22-Apr-21 6:02
mveDave Kreskowiak22-Apr-21 6:02 
AnswerRe: get colour at pixel Pin
Ralf Meier22-Apr-21 22:12
mveRalf Meier22-Apr-21 22:12 
AnswerRe: get colour at pixel Pin
Eddy Vluggen3-May-21 6:49
professionalEddy Vluggen3-May-21 6:49 
QuestionVBA add child and 2 attributes Pin
mhnCPF2-Apr-21 17:29
mhnCPF2-Apr-21 17:29 
AnswerRe: VBA add child and 2 attributes Pin
Richard Deeming6-Apr-21 0:31
mveRichard Deeming6-Apr-21 0:31 
GeneralVBA add child and 2 attributes Pin
mhnCPF6-Apr-21 9:30
mhnCPF6-Apr-21 9:30 
QuestionWinForms RDLC Chart Object, Sizes to Screen Zoom level on print, bug, setting or can be fixed with more code? Pin
jkirkerx2-Apr-21 6:24
professionaljkirkerx2-Apr-21 6:24 
AnswerRe: WinForms RDLC Chart Object, Sizes to Screen Zoom level on print, bug, setting or can be fixed with more code? Pin
jkirkerx2-Apr-21 9:45
professionaljkirkerx2-Apr-21 9:45 
QuestionLogin form using Oracle Stored Procedure with return value Pin
kerek228-Mar-21 22:05
kerek228-Mar-21 22:05 
Hi Sir,

I'm trying to use oracle Stored Produce with my login form as below :-

SQL
<pre>package cms is
    -- 1 => OK, 0 => ERROR
  

    function validateUser(  username    in  cms_user.cu_username%TYPE,
                            passwd      in  varchar2,
                            errmsg      out varchar2 )
                    return number;


END;




Here my Vb.Net Code :

VB
<pre>Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        
        conn.Open()

   
        Dim oracmd As New OracleCommand
        oracmd.Connection = conn
        oracmd.CommandText = "cms.validateUser( username, passwd, msg )"
        oracmd.CommandType = CommandType.StoredProcedure
        oracmd.Parameters.Add(New OracleParameter("username", OracleType.VarChar)).Value = TxtUsername.Text.Trim
        oracmd.Parameters.Add(New OracleParameter("passwd", OracleType.VarChar)).Value = TxtPassword.Text.Trim
        '  oracmd.Parameters.Add(New OracleParameter("msg", OracleType.VarChar)).Value = Label1.Text.Trim
      

        oracmd.Parameters.Add("msg", OracleType.VarChar).Value = Label1.Text
       

        oracmd.Parameters("msg").Direction = ParameterDirection.Output
        oracmd.ExecuteNonQuery()
        conn.Close()

   

    End Sub


and got this Error :

ORA-06550: line 1, column 7:
PLS-00801: internal error [22503]
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



Can anyone guide me plz....tq
AnswerRe: Login form using Oracle Stored Procedure with return value Pin
Richard Deeming28-Mar-21 22:23
mveRichard Deeming28-Mar-21 22:23 
GeneralRe: Login form using Oracle Stored Procedure with return value Pin
kerek229-Mar-21 15:50
kerek229-Mar-21 15:50 
GeneralRe: Login form using Oracle Stored Procedure with return value Pin
Richard Deeming29-Mar-21 21:24
mveRichard Deeming29-Mar-21 21:24 
AnswerRe: Login form using Oracle Stored Procedure with return value Pin
Victor Nijegorodov29-Mar-21 0:46
Victor Nijegorodov29-Mar-21 0:46 
GeneralRe: Login form using Oracle Stored Procedure with return value Pin
kerek229-Mar-21 15:52
kerek229-Mar-21 15:52 

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.