Jump to content


Surajit

Member Since 12 Oct 2001
Offline Last Active Oct 31 2007 02:53 AM
-----

Topics I've Started

Error 385 - SQL ERRROR: UNKNOWN SQL DRIVER

06 July 2004 - 05:30 AM

Hi ,

Our customer who is using Sun OS 5.7, with Oracle 8.1.7 and PROIV 4.6 has encounter error 385. This error is very strange since they have using PROIV with Oracle for a year. It just occur today.

Here is environment setting in Unix;
#------------------------- DATABASE ------------------------------
ORACLE_HOME=/oracle/product/8.1.7 ; export ORACLE_HOME
ORACLE_SID=tyg ; export ORACLE_SID
ORACLE_TERM=$TERM ; export ORACLE_TERM
LD_LIBRARY_PATH=$ORACLE_HOME/lib ; export LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin:$PATH ; export PATH
#------------------------- GLOVIA ------------------------------
GLOVIA_HOME=/oracle/tyg ; export GLOVIA_HOME
GLOVIA_PRO=/u6/pro4bin/pro ; export GLOVIA_PRO
GLOVIA_DATA=$GLOVIA_HOME/userdata ; export GLOVIA_DATA
#
PATH=/u1/pro4bin:$PATH ; export PATH
#------------------------- PROIV ------------------------------
# Note: Do NOT alter the SQL_DATE_FORMAT parameter unless the Oracle
# parameter NLS_DATE_FORMAT has also been altered
#
CDATE_50=Y ; export CDATE_50
DATE_SC_50=Y ; export DATE_SC_50
SQL_AGGREGATE_KEY=A ; export SQL_AGGREGATE_KEY
SQL_CURSORS=64 ; export SQL_CURSORS
SQL_DATE_FORMAT=MM-DD-YYYY ; export SQL_DATE_FORMAT
SQL_DBNAME=$ORACLE_SID ; export SQL_DBNAME
SQL_DBTYPE=ORACLE ; export SQL_DBTYPE
#
PRODATA=$GLOVIA_HOME/userdata ; export PRODATA
PROPATH=$GLOVIA_HOME/bs ; export PROPATH
#
SUPPRESS_CLOSEWIN=Y ; export SUPPRESS_CLOSEWIN
TP_ROLLBACK=Y ; export TP_ROLLBACK
V22_EODCAN=Y ; export V22_EODCAN

Does anyone have some suggestions to solve it ?

Surajit

How can I search for word in Oracle's procedure ?

28 June 2004 - 04:05 AM

Hi,

I have found an unknown source of a record in Oracle table which is updated from a Glovia's function. :( I have searched all the source codes (SLLGC.PRO) for any clues (field's value, column name) that may lead to the creation of that record, but found none. So I suspect that it might created by Oracle' store procedures.

Can anybody tell me how can I search the Oracle' store procedures (packages/functions) for a keyword ?

Thank a lot.

Surajit

Oracle error: 01410 invalid ROWID

15 June 2004 - 05:10 AM

Hi,

I have an input window which is constructed like this;

LS1 MAIN
FILE1 B
FILE2 B
LS2 PAGING
FILE3 B B N L
FILE4 B B N L

When exit from this window and return back to the calling screen, I have got error invalid rowid (as the topic's title). Then I searched from this forum (Rob Donovan's Embeded SQL' in Nov 2002 and Vol Yip 'SQL invalid ROWID error' in Jul 2002) and found that the primary file is prohibited from change mode so I accessed FILE1 and FILE3 again in lookup mode then add/change mode.

LS1 MAIN
FILE1 L L L L
FILE1 A C N L
FILE2 A C N L
LS2 PAGING
FILE3 L L L L
FILE3 A C N L
FILE4 A C N L

Regen and execute the function still give the same error.

Do anybody have experience with this problem ?

Surajit

Timeout and imcomplete PRO ISAM data update

10 June 2004 - 09:34 AM

Hi all,

My customer who is using PROIV 5.5 application with PRO ISAM files want to use timeout feature. However, if user is creating a purchase order and is interrupted during enter an ordered item, the screen is terminated and exit. It causes the detail file to be update without its corresponding header file. How can I prevent the child process from update file or force the parent process to update file when encouter timeout ? The customer want the idle process to be terminated to return the available license seat for another users.

Thanks,
Surajit

How can I create a large screen from Studio ?

27 May 2004 - 08:16 AM

Hi all,

I want to develop a screen from Develper Studio, the screen will have 2 paging screens on the left and right. Each paging screen should be able to display 60+ characters in one line. So the total width should be 132 column width.
I have changed the &#@SCRCOL to 160 to allow screen's width to 160 column.
I can define the each screen's width to 60 chars. But when the function is gened and run, the right paging screen display just the left 10+ characters only.

My PROIV is 4.6 r 218 and client is 4.6 r 205, MS Windows. I use notebook with XGA (1024 x 768) display.

Surajit.