Results 1 to 2 of 2

Thread: Call to database function.

  1. #1
    Join Date
    Sep 2009
    Posts
    2
    Qt products
    Qt4
    Platforms
    Windows

    Default Call to database function.

    Hi all,

    I need to call database function within in qt applications fails with below error;

    QOCIResult::exec: unable to execute statement: ORA-06576: not a valid function or procedure name

    DB: Oracle
    Driver: QOCI

    The Function returns record table.

    C++ code:
    QString qs = "CALL func()";
    QSqlQuery query;
    query.exec(qs);

    Qt documentation says at QSqlQuery Class Reference:

    "Stored procedures that uses the return statement to return values, or return multiple result sets, are not fully supported. For specific details see SQL Database Drivers. "

    this means QOCI does not work with functions which returns parameter ????

    Is there any way doing this ?

    Thanks in Advance

  2. #2
    Join Date
    Sep 2009
    Posts
    2
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: Call to database function.

    Is anybody know this issue ?? Why anybody answers to question ?? I think this question is not hard

    Thanks.

Similar Threads

  1. QPSQL problem
    By LoneWolf in forum Installation and Deployment
    Replies: 60
    Last Post: 4th November 2009, 14:22
  2. Regading Driver to connect Postgresql Database
    By dummystories in forum Installation and Deployment
    Replies: 38
    Last Post: 12th March 2009, 07:19
  3. QPSQL driver in windows
    By brevleq in forum Installation and Deployment
    Replies: 31
    Last Post: 14th December 2007, 12:57
  4. how to add static library into qmake
    By Namrata in forum Qt Tools
    Replies: 1
    Last Post: 20th November 2007, 17:33
  5. use qpsql
    By raphaelf in forum Installation and Deployment
    Replies: 34
    Last Post: 22nd August 2006, 12:52

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.