Calling an Oracle stored procedure from VB
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
Hi all, I am trying to call a pl/sql procedure which is defined inside a package thru Visual Basic. I am getting an error message saying that ".... ... Description=ORA-06550:line 11, column 1:PLS-00201:identifier 'LOCALBOARDING.UPDATEMOVEMENTDETAILS' must be declared ORA-06550:line11, column 1: PL/SQL statement ignored." Here LOCALBOARDING is the package name and UpdateMovementDetails is the procedure name. I am using ExecSQL method in VB. ie inside BEGIN and END block, I am trying to call the packagename.procedure with parameters. If I copy the code in the backend means, its executing properly. But no thru VB. Kindly help. Thanks in advance. Surendran