i am using visual studio to connect to oracle data base and insert records into a table.
my package and store procedure are as under
CREATE OR REPLACE PACKAGE pkg_supplier as PROCEDURE sp_insert_hpsuppliers(a_companyname IN VARCHAR2, a_contactname IN VARCHAR2, a_address IN VARCHAR2, a_city IN VARCHAR2); end; /
create or replace package body pkg_supplier as procedure sp_insert_hpsuppliers (a_companyname in varchar2,a_contactname in varchar2,a_address in varchar2,a_city in varchar2) as begin
insert into hp_suppliers values (a_companyname,a_contactname,a_address,a_city); end sp_insert_hpsuppliers ; end pkg_supplier; /
and here is the code which i use to call store procedure
' Declare variables Dim li_rc As Integer Dim myString As String Dim myConn As New OleDb.OleDbConnection()
' Create new connection myString = "Provider=msdaora;Data Source=orcl;User Id=id;Password=pass;" Try myConn.ConnectionString = myString myConn.Open() Catch ex As OleDb.OleDbException MessageBox.Show(ex.Message) Exit Sub End Try
' CALL ACI SP Dim companyname As String Dim contactname As String Dim address As String Dim city As String
rapatel83
Member
7 Points
4 Posts
ORA-06550: line 1, column 7: PLS-00306 ERROR!!
Dec 07, 2011 07:11 AM|LINK
Hello to all members out there.
I am very new to .net ado
i am using visual studio to connect to oracle data base and insert records into a table.
my package and store procedure are as under