May I ask why you want to use a stored procedure? A simple "Select fullname from users where user = '<value>';" should work just fine.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
Hello,
Please, I just trying search in all WEB SITES about using STORED PROCEDURES with VISUAL BASIC, but I not found anything about this that can help me.
I have a table: USERS with colums IDUSER, USER, PASSWORD, FULLNAME
I need get the colum FULLNAME with parameter USER.
How I do to create and execute a STORED PROCEDURE in VISUAL BASIC 6 to resolve this litle problem ? (please, forgiven my english because I living in BRAZIL and not speak english).
Thanks,
Sandroyy