calling a PL/SQL Script

[ToeJamNEarl]

Hey guys,

I searched the forums and found a sort of related thread about running a PL/SQL script from VB, but I am kind of confused on that. It seems that the PL/SQL script has to be located on the oracle database?

I have the pl/sql script as a separate file on the computer's hard drive. What all is necessary to make the VB program execute this script? I would appreciate any help possible. It's hard to find any data wit GOOGLE


Thanks,

-Diran

 

[DaveMere]

Call the stored procedure by name, in the same fashion as you would pass through any SQL string from VB. For example. you might pass a simple SQL string like so;

strSQL = "SELECT * FROM <tablename>"
Set mRs = mCn.Execute(strSQL)

To call a stored procedure you should replace strSQL with the name of the procedure, like so;

strSQL = "MyStoredProc"
Set mRs = mCn.Execute(strSQL)

Remember to include any variables the procedure requires, in single quotes if necessary.

DaveMere

 

[ToeJamNEarl]

Thanks a bunch Dave

I'll be giving that a shot in the next couple of days.

I'll keep you all posted.