SPONSORS:






User Tag List

Results 1 to 6 of 6
  1. #1
    Junior Member
    Join Date
    Dec 2001
    Location
    CA
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Calling Stored Procedures Using SilkTest!

    Hi All,
    I am trying to call a stored Procedure using silk Test.I tried what was mentioned in the
    newsgroup i.e
    Use DB_Connect to connect to the database
    And use DB_ExecuteSql to call the stored proc.For eg to call the stored proc in SQL+
    of Oracle i would use execute procname();
    This runs fine in SQL+ .But when i give it as
    a query string in DB_ExecuteSql ,It gives me invalid SQL statement Error.

    Is there any way of doing this ?


    ------------------

  2. #2
    Junior Member
    Join Date
    Dec 2001
    Location
    CA
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Calling Stored Procedures Using SilkTest!

    Thanx Rob,
    This is the Exact Error Message I am getting:
    *** Error: (42000) [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

    Also i am using a Oracle ODBC driver.
    I also tried Microsoft ODBC driver for Oracle.That too didnt seem to work !

    Any Other ideas ?



    ------------------

  3. #3
    Senior Member
    Join Date
    Jun 2000
    Location
    Chicago, IL USA
    Posts
    383
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Calling Stored Procedures Using SilkTest!

    You must give more information.

    There are many different software components (from different companies) working together here. This can make debugging very difficult. I am not sure if "invalid SQL statement Error" is coming from the database or the ODBC driver. I would guess that this is a limitation of the ODBC driver that you are using. But I need the full text of the error to be sure.

    Try another ODBC driver and see if anything changes.

    ------------------
    Rob Kapteyn
    Rob Kapteyn, CSTE
    RobKapteyn@gmail.com

  4. #4
    Member
    Join Date
    May 2001
    Posts
    56
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Calling Stored Procedures Using SilkTest!

    Hi Sandeep,
    I think there is an error in your SQL statement. Can you post your DB_connect statements?


    ------------------

  5. #5
    Junior Member
    Join Date
    Dec 2001
    Location
    CA
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Calling Stored Procedures Using SilkTest!

    Hi,
    I managed to solve the problem .
    Thanx for all your inputs .

    I was initially calling
    hdbc = DB_Connect (connectURL)
    hstmnt = DB_ExecuteSql (hdbc,execute prabi_claimgen.generateclaim('Sandeep',SYSDATE))

    The syntax works on SQL+ prompt .But its starangely not the right way of calling a stored proc using Oracle driver.This works with MS SQL server.

    the right syntax for oracle is as follows:This worked for me
    hstmnt = DB_ExecuteSql (hdbc,"begin prabi_claimgen.generateclaim('Sandeep',SYSDATE); COMMIT; end;")


    thanx,
    Sandeep

    ------------------

  6. #6
    Senior Member
    Join Date
    Jun 2000
    Location
    Chicago, IL USA
    Posts
    383
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Calling Stored Procedures Using SilkTest!

    Interesting ...
    Thanks for posting your solution.

    ------------------
    Rob Kapteyn
    Rob Kapteyn, CSTE
    RobKapteyn@gmail.com

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin 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 07:44 AM.

Copyright BetaSoft Inc.