Albert Ho

Wow finally there's a reply. Thanks. The app server is running and I can see the main index page of the webclient web site. The error msg poped up when i clicked the service name and the error window seems to belong to IE with "PROIV" as a title on the title bar.

I did check the server log but could not find anything else apart from the server startup log. Could it be that the activex component wasn't registered successfully during installation? I have done around 4 times installation on the same machine and couple of time on another machine but the error keep on repeating itself.

Oh forgot to mention that the example script above is use for Linux. So if you are running on other OS you may need to add some platform dependent stuff in it.

Hi Dave, you could do the following

1. You can have 1 proiv user to 1 oracle user by having a saperate bootstrap scripts for each of them. Just change the SQL_USERNAME and SQL_PASSWORD line.

2. Well generally if you include Referential Integrity (RI), it is slower for proiv to process. But nevertheless this is an important feature that RDBMS has over ISAM and in ISAM I'm sure you would have to control RI at application level. As for function compatibility, I think you have to leave out that cascade option feature and rollback to manually delete the child record. This is to ensure maximum compatibility across Oracle and ISAM database.

3. For this I have not tried it on SL, only manage to implement on VIP, but it could work also. To call a oracle stored proc or function this is what you must include in your code

for function:

SQL
CALL FUNCTION1 (:$VAR1, $VAR2) INTO :#RTNVAL
ENDSQL

for procedure:

SQL
CALL PROCEDURE1 (:$VAR1, $VAR2)
ENDSQL

Be aware that proiv is not capable of receving a return value (#RTNVAL) from oracle function which is NOT numeric. You have to include the clause SQL..ENDSQL to indicate to proiv that this is a SQL stmt execution.
For Oracle packages it is similar I supposed, I have not tried before.

4. I wish to help you on Oracle sequences, but to start off I don't even know enough to talk about it, sorry.

I got this error when I tried to open a function in VIP. I'm using PROIV v5.5 b 210 kernel

Well Thanks Rob, must be the long hours of work, I actually missed out some settings