Highlighted
Absent Member.
Absent Member.
2007 views

How to script Oracle request with VUGen ?

Jump to solution
Hi all,

I need help on scripting oracle requests with VUGen. I've seen some Oracle protocols available in VUGen : Oracle (2-Tier), Oracle NCA, Oracle Web Applcations 11i, Siebel Oracle ....
But only ODBC seems to be the right protocol.

I've installed sqlplus on my workstation and I need to record some selects on my database. But I failed to record anything. The Start Recording ask me for Win32 Applications (Program to record, ... Working directory) and when I launch sqlplus or sqldeveloper, VUGen didn't record any instruction. Evenif the requests are running well and displaying information on my database (so oraclesid, login, passws are good)

Have you an exemple or a howto guide that may explain me all the steps to record Oracle 9 and 10 selects ?

Thanks a lot for your help,
Georges Lima
0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: How to script Oracle request with VUGen ?

Jump to solution
SQLPlus needs to be recorded with Oracle 2-tier.

If you want to use ODBC just google for a free ODBC client and use it for your queries with the ODBC protocol.

Alan

View solution in original post

0 Likes
3 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: How to script Oracle request with VUGen ?

Jump to solution
SQLPlus needs to be recorded with Oracle 2-tier.

If you want to use ODBC just google for a free ODBC client and use it for your queries with the ODBC protocol.

Alan

View solution in original post

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: How to script Oracle request with VUGen ?

Jump to solution
Thanks Alan
You give me all information that I need.

I've successfully record all the selects using sqlplus (Oracle Client) in VUGen with Oracle 2-tier protocol

Best regards,
Georges
0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: How to script Oracle request with VUGen ?

Jump to solution
This info is very helpful. I am able to record the connection to an Oracle database. I can also run a select statement. The replay is fine to. I want to validate return result from the select statment. How can I do that?
Rufeng
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.