What's wrong with my SQL???

Hi all,

I can't for the life of me see what is wrong with this sql in a stored proc. Any help is greatly appreciated.
---------------code-------------
CREATE OR REPLACE PROCEDURE ReSeedSequences (v_seq_owner IN varchar2 , v_seq_name IN varchar2 , v_table_name IN varchar2 , v_error OUT varchar2) AS

seqno_val binary_integer;

sql_txt varchar2(200);

BEGIN DBMS_OUTPUT.PUT_LINE('Now processing Sequence ' || v_seq_name || ' for Trial ' || v_seq_owner || '.');

• Getting the max SEQNO + 1 from the table passed into procedure

sql_txt := 'select max(seqno) + 1 SEQNO from ' || v_seq_owner || '.' || v_table_name || ' Returning SEQNO into :1';

DBMS_OUTPUT.PUT_LINE('SQL: ' || sql_txt);

EXECUTE IMMEDIATE sql_txt RETURN INTO seqno_val;

...

-----------------end code--------------

The "sql_txt" line is the problem. Oracle error is: "Error: ORA-00933: SQL command not properly ended"

Using Oracle 8.1.7.0 EE.

Thanks so much,

Wells... Received on Wed Aug 14 2002 - 00:25:17 CDT