Question How to read the oracle procedure

[bhushanpawar]

Hello Friends,

I have created Stored Procedure in Oracle which is as below

CREATE OR REPLACE
PROCEDURE TEST_TABLE_SEL
(
LTest_Name OUT NOCOPY VARCHAR2
)

AS

BEGIN
SELECT TEST_NAME INTO LTest_Name FROM TEST_TABLE WHERE TEST_ID=9;

END TEST_TABLE_SEL;

This procedure returns Value of TEST_NAME FIELD when i run the procedure in Oracle database.

But, I have no idea how to read the value of TEST_NAME in Textbox thourgh vb.net 2008. Please suggest me the way how can i read the oracle stored procedure field value through vb.net and get the value in TextBox.

Thanks in Advance

Regards
Bhushan Pawar

 

[bhushanpawar]

Please help in the above issue