SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3

Thread: PL/SQL in QTP

  1. #1
    Junior Member
    Join Date
    Oct 2004
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    PL/SQL in QTP

    I have used ADODB for retreiving data from database, but now i have a PL/SQL like the one below
    declare
    a integer;
    b integer;
    c integer;
    begin
    select sum(Marks)into a
    from ...
    where..
    select sum(Marks)into b
    from..
    where..
    c=(a/b)*100;
    dbms_output.put_line('Percentage.."||c );
    end;


    If it is not a PL/SQL then
    Set QryRslt = CreateObject("ADODB.Recordset")
    QryRslt.Open "select * from table",Conn

    How will i define QryRslt now?
    Thanks as always

  2. #2
    Senior Member
    Join Date
    Jan 2005
    Posts
    359
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: PL/SQL in QTP

    Use ADODB Command Object

  3. #3
    Advanced Member
    Join Date
    Jan 2004
    Location
    UK
    Posts
    817
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: PL/SQL in QTP

    First of all you would have used sql or pl/sql to get the data from your database. Defining your Qryrslt, i assume in this case, would be the form the result takes i.e. spool the QryRslt to a file?

    Hope this helps
    I like what i know and I know what i like

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.71%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 09:42 PM.

Copyright BetaSoft Inc.