Hello friends, I want to create 1 stored procedure in Oracle. I have written it & when trying to execute, its giving some error message...i am using Ora 8i. While creating SP, Oracle gave me error msg :- "Warning: Procedure created with compilation errors." :doh::doh::doh: Will anybody please help me in solving the issue??? Here I am giving that SP... Looking forword to see your reply.. ;) Thanks in advance... Regards, Rohan CREATE OR REPLACE PROCEDURE usp_Security_IsAuthorisedUser (strUserName IN VARCHAR2(40), strPassword IN VARCHAR2(16), blnIsValidUser OUT BOOLEAN, strInfo OUT VARCHAR(10)) AS BEGIN DECLARE intCount NUMBER; intCount := 0; SELECT COUNT(*) INTO intCount FROM USERS WHERE UserID = strUserName AND Password = strPassword; --If count = 1 then only user information is correct IF intCount = 1 THEN BEGIN blnIsValidUser := TRUE; intCount := 0; strInfo := 'SP'; SELECT COUNT(*) INTO intCount FROM UnitRights WHERE HoU = strUserName; IF intCount = 1 THEN strInfo := 'UH'; EXIT; ELSE SELECT COUNT(*) INTO intCount FROM GENCODES WHERE FLD_NAME = 'MARKET_REG' AND UDF_ST3 = strUserName; --If count = 1 then this is Region Manager IF intCount = 1 THEN strInfo := 'RM'; EXIT; END IF END IF END; ELSE BEGIN blnIsValidUser := FALSE; SELECT COUNT(*) INTO intCount FROM USERS WHERE CODE = strUserName; IF intCount = 1 THEN strInfo := 'PI'; ELSE strInfo := 'UU'; END IF END; END IF END;

Hey..thanx buddy.... but where this table is stored??? and there must be some log files also generated behind the scene...like SQL Server...???:doh: looking 4ward 2 see ur reply...

Hello friends, I am working on 1 application where I want to send some data to WebApplication from VB.NET application. The situation is like this:- There is one Web App developed in ASP.NET. The desktop application is being developed in VB.NET which will be installed at remote computer. If internet is connected to it, then one class will start communicating with the ASP.NET Application i.e. on Web Server(Say, on click event of some button on some form). I want to send(some login info required to get access to web server) & receive(the records from database) the data within these 2 applications without user to open a IE browser. VB itself shud be able to do this. Since its only retriving some data from Web Server in String format, i don't want user to go and do something by opening new IE window...I want to do it using VB.NET only... Will you please help me????? Looking forward to see reply.... Regards, Rohan

Thanx for replying... I have seen that document...and accordingly I have installed "Microsoft VS.NET 2003 Bootstrapper Plug-in Setup". As I have mentioned, I have also added "Custom Action" and "Launch Condition" to my setup project. But "Launch Condition" only determines whether the condition specified is true or not and if its true then proceeds to install the application. Also "Custom Action" is executed after my application's installation...wherein I have specified to install .NET framework. Now, I don't know how to take the custom action before doing nething else... Can u please tell me, if according to current situation, if .NET framework is installed after my application's installation is completed, then will it work on target machine??? Looking forward to see your reply... Regards, Rohan

Hello, I am developing one application using VB.NET & Access + Oracle as a databases, and I want to install it on client machine. I want to make setup of my application in such a way that it will determine immidiately that .NET Framework should be installed before starting installation of my appl.(and obviously it shoud install it...) I read some MSDN stuff and I was trying to do something as follows :- 1. I have tried it by adding "Launch Condition" to Setup Project that checks whether framework is present or not and displays message box that it must be installed b4 but does not installs it automatically. 2. If I add "Custom Action" to Setup Project, the action is taken after installation of my application. Can anyone please suggest me how i should go about it??? :doh: This is VERY URGENT and I hope ne1 of you will help me sure...:-O Thannks in advance.... Regards, Rohan

Hey Kalyan, Thanks a lot..... You have helped me exactly when I wanted.... Thanx once again.... Regards, Rohan...

Hello Friends, I am currently developing one application using VB.NET & Access + Oracle as a databases, and I want to install it on client machine. Since, we can not say for sure, whether .NET Framework is already installed on clients machine. I don't want my client to install it manually/separately, instead the framework (if required) should get installed automatically. I want to make setup of my application in such a way that it will determine immidiately that .NET Framework should be installed before proceding to its own installation. (and obviously it shoud install it...:)) Can anyone please suggest me how i should go about it??? Thannks in advance....

Hi all... I want to find whether a table exists in Access Database or not. I know how to do it in MS SQL Server, we can see the result using Select query from sysobjects table and we have the list of all Tables, SPs, Views, functions...etc. But if my program gets .mdb file i.e. Access Database, my program must find whether a perticular table is created in that database or not. Is there any way to do it??? Thanx in advance....:)