I have pasted the code of my make file. Here I am getting the warning message when sampleora.pc file is converted to sampleora.c file. # Executables built by this makefile PROC=$(ORACLE_HOME)/bin/proc all: sample # Oracle environment setup include $(ORACLE_HOME)/rdbms/lib/env_rdbms.mk # Debug & Development Compiler Flags are below CFLAGS=-g -DSOCKSELECT -DSUN_SRC_COMPAT -I$(ORACLE_HOME)/rdbms/demo # Final Production Compiler Flags are below CFLAGS=-O -DSOCKSELECT -DSUN_SRC_COMPAT -I$(ORACLE_HOME)/rdbms/demo # Link Editor Flags are below (shouldn't need to change anything here) LDFLAGS=-L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib -lsocket -lnsl ECHO=$(ORACLE_HOME)/bin/echodo LLIBPSO=`cat $(ORACLE_HOME)/rdbms/lib/psoliblist` FC=f77 COB=cob COBFLAGS=-C IBMCOMP -x COBGNTFLAGS=-C IBMCOMP -u CPLPL=CC LLAIO= # directory that contain oratypes.h and other oci demo program header files INCORASTUFF= -I$(ORACLE_HOME)/rdbms/demo -I$(ORACLE_HOME)/rdbms/public -I. INCLUDE= $(INCORASTUFF) -I # CONFIG = $(ORACLE_HOME)/rdbms/lib/config.o # module to be used for linking with non-deferred option NDFOPT= $(ORACLE_HOME)/rdbms/lib/kpundf.o # flag for linking with non-deferred option (default is deferred mode) NONDEFER=false # libraries for linking oci programs OCILDLIBS=-lclntsh # $(LIBCLIENT) $(DEVTTLIBS) $(LLIBCORE) # object for linking oci programs in Fortran OCIFOR=$(ORACLE_HOME)/rdbms/lib/ocifor.o # object for linking oci programs in Cobol OCICOB=$(ORACLE_HOME)/rdbms/lib/ocicob.o PSOLIBLIST=$(ORACLE_HOME)/rdbms/lib/psoliblist CLEANPSO=rm -f $(PSOLIBLIST); $(GENPSOLIB) PROFLAGS=sqlcheck=semantics userid=/ dbms=v6_char dbms=v7 DEFINE=UNIX DEFINE=SUN_SRC_COMPAT DEFINE=linux EXE=sample OBJS=sample.o sampleora.o sampletcp.o # Rule to compile any program (specify EXE= and OBJS= on command line) build: $(OBJS) $(ECHO) $(CC) $(LDFLAGS) -o $(EXE) $(OBJS) -L$(LIBHOME) -lclntsh # "Shorthand" Rule to compile all the sample program samples: $(SAMPLES) $(SAMPLES): $(MAKE) -f $(ORACLE_HOME)/proc/demo/proc.mk OBJS=$@.o EXE=$@ build # Suffix rules .SUFFIXES: .exe .o .c .pc .pc.c: $(PROC) $(PROFLAGS) iname=$*.pc .pc.o: $(PROC) $(PROFLAGS) iname=$*.pc $(CC) $(CFLAGS) $(SQLPUBLIC) -c $*.c .c.o: $(CC) $(CFLAGS) $(SQLPUBLIC) -c $*.c sample.o: sample.h sampleora.c: sampleora.pc $(PROC) iname=$*.pc $(PROFLAGS) icim: $(OBJS) $(CC) $(LDFLAGS) -o $(EXE) $(OBJS) -L$(LIBHOME) -lclntsh LIBDIR= $(ORACLE_HOME)/proc/li

Hi all, First of all I am not exactly sure whether I can post this problem in this forum. If its wrong I am sorry for that. I am delibrately need a solution to this problem. I am trying to create an executable, but when the .pc file converting to .c file I am getting lots of warning message like warning: old-style declaration or incorrect type for: main warning: implicit function declaration: warning: no explicit type given of these 3 lines. Any idea why I am getting these lines? Any configuration issues? What exactly needs to be done to solve these warning messages? I am trying to compile this is new environment. Any kind of suggestion would be helpful. Thanks in advance

Dear All, I am using server/Client application which will communicate through winsock Control. Coding for all the database transactions done in the server application. Only the data is passed to Client. For each transaction client will request the Server to do the transaction. Here my problem is between the transaction if Database is down/Network is down I am getting "End of communication channel/Oracle not available/TNS-packet failure" errors. I am using ADO connectivity for database transactions. I tried by checking the socket.state, On Error goto. But nothing seems to be helpful. Any suggetions/Solutions are welcome Thanks in advance Regards N.Surendran

Hi, I think, Getting a salary slip from a person is not that much easy. Instead, you can search the net for sample salary slip formats. Surendran

Hi all, I am trying to call a pl/sql procedure which is defined inside a package thru Visual Basic. I am getting an error message saying that ".... ... Description=ORA-06550:line 11, column 1:PLS-00201:identifier 'LOCALBOARDING.UPDATEMOVEMENTDETAILS' must be declared ORA-06550:line11, column 1: PL/SQL statement ignored." Here LOCALBOARDING is the package name and UpdateMovementDetails is the procedure name. I am using ExecSQL method in VB. ie inside BEGIN and END block, I am trying to call the packagename.procedure with parameters. If I copy the code in the backend means, its executing properly. But no thru VB. Kindly help. Thanks in advance. Surendran

Hi, I want to convert an audio file to text format. I donno what kind of control or API or tool to use. Can any one help me? Rgds, Surendran

Dear All, I tried to get the views that are defined using a particular table name. Can any one give me the query for that? I already tried with user_views in the following way. select view_name from user_views where text like '%tablename%'; The problem here is that the text column datatype is LONG. So I am getting inconsistent datatype err. Thanks Surendran

Hai, I am trying to compile my application in VC++, I am getting error "file not found: ..\lib\ScriptHost.tlb". That file is not available in my machine. how to get that file? That file is included in the file "..\Rogue Wave\Stingray Studio 2006\Include\toolkit\ActvHost\ScriptHost.rc" Can anyone suggest me what I could do for this Thanks Surendran

Hai, I am trying to compile my application in VC++, I am getting error "file not found: ..\lib\ScriptHost.tlb". That file is not available in my machine. how to get that file? That file is included in the file "..\Rogue Wave\Stingray Studio 2006\Include\toolkit\ActvHost\ScriptHost.rc" Can anyone suggest me what I could do for this Thanks Surendran

Hi, From a CPP program, I am creating a service. And from that service I am invoking an exe with CreateProcess function. The problem here is that, when that service is started locally then the exe's GUI is visble. But if the service is started from the machine thru remotedesktop connection, the exe's GUI is not visible. But I can see the exe process in task manager. Please help me in this regards. Thanks in advance. Surendran

Yes in my program CreateService is mentioned like this only. One thing I have to mention here is that, I found that the application GUI is launching when the service starts from the local machine, if the same machine is accessed from remote as Remotedesktop connection to start the service, the GUI is running only in the background. GUI is not visible. Rgds., Surendran

Hi, I want to run an exe(say for eg: Calculator) from the windows service when it started. In the OnInit() I have used CreateProcess function, toget the exe path from the command line argument. My problem here is that, Exe and service is running in task manafer after I started the service, But I couldnt see the application window(Calculator) visible to user. After getting some valuable suggestion from this site, I replaced CreateProcess function with CreateProcessAsUser() function to get the window. But Still the same problem exists. Here is the code I place in the Init menthod BOOL b; HANDLE hToken; HANDLE hNewToken; b = OpenProcessToken(GetCurrentProcess(), TOKEN_ASSIGN_PRIMARY|TOKEN_DUPLICATE, &hToken); b = DuplicateTokenEx(hToken, TOKEN_ASSIGN_PRIMARY|TOKEN_ALL_ACCESS, NULL, SecurityImpersonation, TokenPrimary, &hNewToken); b = CreateProcessAsUser(hNewToken, NULL,ArgPBU,NULL, NULL, FALSE, NORMAL_PRIORITY_CLASS | CREATE_NEW_CONSOLE, NULL, Cwd, &si, &m_piPBU); CloseHandle(hNewToken); ----------------------- Thanks in advance. Rgds., Surendran N

Hi , My problem is that, I want to run an .exe from the windows service. But the application window is not visible to the user. Exe and Service is running in task manager. Previously I was using CreateProcess funtion. Then after getting suggestion from this site, I changed that into CreateProcessAsUser and the Code is like below. But Still I am facing same problem. BOOL b; HANDLE hToken; HANDLE hNewToken; b = OpenProcessToken(GetCurrentProcess(), TOKEN_ASSIGN_PRIMARY|TOKEN_DUPLICATE, &hToken); b = DuplicateTokenEx(hToken, TOKEN_ASSIGN_PRIMARY|TOKEN_ALL_ACCESS, NULL, SecurityImpersonation, TokenPrimary, &hNewToken); b = CreateProcessAsUser(hNewToken, NULL,ArgPBU,NULL, NULL, FALSE, NORMAL_PRIORITY_CLASS | CREATE_NEW_CONSOLE, NULL, Cwd, &si, &m_piPBU); CloseHandle(hNewToken); ------------- After executing this I am getting same result. Rgds., N.Surendran

Hi , Thanks for the info. I wrote the code like below. In that ArgPBU is command line args (exe name to run) cwd is current working directory path BOOL b; HANDLE hToken; HANDLE hNewToken; b = OpenProcessToken(GetCurrentProcess(), TOKEN_ASSIGN_PRIMARY|TOKEN_DUPLICATE, &hToken); b = DuplicateTokenEx(hToken, TOKEN_ASSIGN_PRIMARY|TOKEN_ALL_ACCESS, NULL, SecurityImpersonation, TokenPrimary, &hNewToken); b = CreateProcessAsUser(hNewToken, NULL,ArgPBU,NULL, NULL, FALSE, NORMAL_PRIORITY_CLASS | CREATE_NEW_CONSOLE, NULL, Cwd, &si, &m_piPBU); CloseHandle(hNewToken); ------------- After executing this I am getting same result. Can you help me in this regards? Surendran N

Mike, Thanks for the info. In the CreateProcessAsUser( hToken, NULL, "cmd.exe" or cmdline args, NULL, NULL, FALSE, NORMAL_PRIORITY_CLASS | CREATE_NEW_CONSOLE, NULL, NULL, &si, &pi ) This I got from one site, I want to know, apart from calling this function, anyotherfunction needs to be called?And for the "htoken" parameter any objects or assignments needs to be done? and FYI is now I am using CreateProcess method in the program Thanks N.Surendran

Better you can use datareport or crystal reports for billing format.

Hi All, I wrote a C++ program which will create a service in windows. By starting that service I want to run a particular .exe The issue here is that, after starting that service, that .exe is running in the task manager but the application window is not visible. I am giving the .exe path as a command line argument while executing the C++ exe. rgds., Surendran