2 Replies Latest reply: Aug 7, 2013 10:50 AM by Tatiana Trishevskaya RSS

    Problem with StoredProc

      Hello

      I have simple oracle storedproc, it succeeds in Toad: exec shemaname.test(1);

       

      But I can't run it in QV ;( Pls, HELP!!!

       

      I gave script permission to read / write

       

      ww.jpg

      With my ODBC CONNECT I can get the data from the table:

       

      test:

      LOAD *;

      SQL

      select * from mapping;

       

      But I can not start the StoredProc ;(

      I have tried to do this:

       

      test:

      LOAD *;

      SQL

      select TEST(1) from dual;

       

      test:

      LOAD *;

      SQL

      exec TEST(1);

       

      test:

      LOAD *;

      SQL

      call TEST(1);

       

      test:

      LOAD *;

      SQL

        begin

          exec TEST(1);

        end;


      I always get an errors:

       

      q1.jpg

      q2.jpg

       

      q3.jpg

       

      I added a data source right on stored procedures

       

      q4.jpg


      I do not understand what I'm doing wrong ;(