Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
I added a data source right on stored procedures
I do not understand what I'm doing wrong ;(
also
test:
SQL
exec TEST(1);
test:
SQL
exec dbo.TEST(1);
;(((
My stored procedure without returning any recordset: (non query)
Running a stored procedure without returning any recordset: (non query)
Use the function CALL to specify the name of the stored procedure.
Example (Launches XYZ with the two parameters 2 & 5):
sql call XYZ ( 2 , 5 );
This works for both ODBC and OLE DB. However, when opening the connection using OLE DB, make sure to add (mode is write) before the finishing semi colon in the connection string.
and it still does not work:
sp:
SQL CALL TEST2;
test:
SQL
EXEC "ShemaName".TEST '1';
Thanks to myself.