.NET Stored Procedure: Reading a Text File into an Oracle Table - Testing the Oracle-based .NET CLR stored procedure
(Page 3 of 5 )
I already introduced a way to test the stored procedure from within the Visual Studio.NET environment. To test the above stored procedure, I just proceed with iSQLPlus from now on.
Open any browser and go to “http://server:port/isqlplus.” Provide “Username,” “password” and “connect identifier” according to your configuration and click “login.”
Once it opens workspace, just type the following code and press “execute.”
Begin
read;
End;
You should see output something like the following (Fig 4).
That’s it. Actually, the above three lines are nothing but some simple PL/SQL statements, generally used to call (or execute) any stored procedure stored in an Oracle database.
Next: How to read all the lines from the text file >>
More .NET Articles
More By Jagadish Chaterjee
/ 12 
