Highlighted
Absent Member.. Absent Member..
Absent Member..
373 views

Oracle 2 Tier Protocol Problem

Hi All,

 

I have recorded the script using Oracle 2 Tier Protocol, accessing a
9i databse using 6i forms. We are currently upgrading our databases
and have recently upgraded from 8.06 database using 4.5 forms. I can
record the test script OK through the GUI but when I replay the
script through Loadrunner it falls over very early on.

The loadrunner error message reads:

vuser_init.c(75): Error: lrdo.c/fjParse: "oparse" LDA/CDA return-
code=06550: vuser_init.c(75): Error:ORA-06550: line 1, column 89: PLS-
00221: 'F_CHK_USER_LOGINS' is not a procedure or is undefined ORA-
06550: line 1, column 89: PL/SQL: Statement ignored vuser_init.c(75):
lrd_stmt: ERROR, return-code=LRDE2009. /* select text from
sys.all_source where owner = 'CIS' and name = 'PKG_MENU'; */ BEGIN
PKG_MENU.F_CHK_USER_LOGINS(/* INSERT PARAMETERS HERE */); END;

The line in the Loadrunner script which fails is:

lrd_stmt(Csr5, "/* select text from sys.all_source where owner
= 'CIS' and name = 'PKG_MENU'; */ BEGIN PKG_MENU.F_CHK_WORK_ALLOCS
(/* INSERT PARAMETERS HERE */); END;", -1, 0 /*Non deferred*/,
1 /*Dflt Ora Ver*/, 0);

It looks to me like it can't run a particular package, 'PKG_MENU' in
this case. However the package does exist within our database. I
have spoken to one of our developers and he thought it loooked like
loadrunner is trying to compile code from within the database and he
couldn't understand why it would do that. As I am new to Loadrunner
I couldn't really answer that question ! Does anyone have any ideas ?

It has been suggested that it had something to do with database
access rights. However the access rights for the users used in the
script have since been granted explicit execute rights and the exact
same error still occurs.

We did not have the problem when using 4.5 forms. I've set up all
the relevant parameter lists and correlated all necessary values
within the loadrunner script. I can't understand why the script will
record OK but falls over when playing back. Does anyone have any
ideas ?

Any suggestions gratefully accepted....

Thanks

Kapil

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.