I'm having trouble with a stored procedure. In VB I am setting a passed parameter like this :-
IN_SQL = "SELECT * FROM SUMMARIES WHERE client = 1234 and driver = 'SMITH' "
This is then being sent to a stored procedure which is using this paramater to fill a cursor ref :-
OPEN cursor_ref FOR IN_SQL;
Can anyone help, please ?
n.b
( I haven't included the rest of the stored procedure as I'm positive the error lies in how I've passed the SELECT statement, I've previously executed the stored procedure with the select statement hardcoded in it and it works )
IN_SQL = "SELECT * FROM SUMMARIES WHERE client = 1234 and driver = 'SMITH' "
This is then being sent to a stored procedure which is using this paramater to fill a cursor ref :-
OPEN cursor_ref FOR IN_SQL;
Can anyone help, please ?
n.b
( I haven't included the rest of the stored procedure as I'm positive the error lies in how I've passed the SELECT statement, I've previously executed the stored procedure with the select statement hardcoded in it and it works )