E
Edwinah63
Hi everyone,
very quick question:
am trying to create a pass through query (not in a code module, just
the "point and click" new query/query/sql specific/pass through thang)
to run an oracle stored proc. am using msaccess 2000/ microsoft odbc
for oracle driver/oracle 9i.
keeps coming back to me saying that the syntax is incorrect.
here's the call syntax in sql plus:
exec TTADM.AST005_CLIENTRPT_ALLx, 'AA','ZZ','AA','ZZ',
'11/06/2004','08:00', '11/06/2004', '09:00');
where :x is the variable for the cursor to return to.
and here's the call syntax in vb6/ADO:
{call ttadm.AST005_CLIENTRPT_ALL
(
{resultset 0, cur},
'AA','ZZ','AA','ZZ', '11/06/2004','08:00', '11/06/2004', '09:00'
)
}
have tried:
exec TTADM.AST005_CLIENTRPT_ALLx, 'AA','ZZ','AA','ZZ',
'11/06/2004','08:00', '11/06/2004', '09:00')
exec TTADM.AST005_CLIENTRPT_ALL('AA','ZZ','AA','ZZ',
'11/06/2004','08:00', '11/06/2004', '09:00')
TTADM.AST005_CLIENTRPT_ALL('AA','ZZ','AA','ZZ', '11/06/2004','08:00',
'11/06/2004', '09:00')
all no good
is it possible to use a non-code pass through query from access to an
oracle stored proc?
if so what's the syntax in ms access??
regards
Edwinah63
very quick question:
am trying to create a pass through query (not in a code module, just
the "point and click" new query/query/sql specific/pass through thang)
to run an oracle stored proc. am using msaccess 2000/ microsoft odbc
for oracle driver/oracle 9i.
keeps coming back to me saying that the syntax is incorrect.
here's the call syntax in sql plus:
exec TTADM.AST005_CLIENTRPT_ALLx, 'AA','ZZ','AA','ZZ',
'11/06/2004','08:00', '11/06/2004', '09:00');
where :x is the variable for the cursor to return to.
and here's the call syntax in vb6/ADO:
{call ttadm.AST005_CLIENTRPT_ALL
(
{resultset 0, cur},
'AA','ZZ','AA','ZZ', '11/06/2004','08:00', '11/06/2004', '09:00'
)
}
have tried:
exec TTADM.AST005_CLIENTRPT_ALLx, 'AA','ZZ','AA','ZZ',
'11/06/2004','08:00', '11/06/2004', '09:00')
exec TTADM.AST005_CLIENTRPT_ALL('AA','ZZ','AA','ZZ',
'11/06/2004','08:00', '11/06/2004', '09:00')
TTADM.AST005_CLIENTRPT_ALL('AA','ZZ','AA','ZZ', '11/06/2004','08:00',
'11/06/2004', '09:00')
all no good
is it possible to use a non-code pass through query from access to an
oracle stored proc?
if so what's the syntax in ms access??
regards
Edwinah63