Re: EXECUTE ... SELECT COUNT(*) ... INTO ?

p_row_cnt should be INT. Use FETCH instead of EXECUTE. HTH. On 2 Dec 96 at 21:14, system PRIVILEGED account wrote: > I'm creating a WHERE clause from parameters given in an HTML > form. The resulting SELECT statement is a simple COUNT(*) of > records. Problem is, how do I get the returned value for COUNT(*)? > > The following is my best try: > LET p_sql_stmt = "SELECT COUNT(*) FROM v3 WHERE ", p_where_clause > PREPARE pre_count FROM p_sql_stmt > EXECUTE pre_count INTO p_row_cnt > |_________________________^ > | > | A grammatical error has been found on line 169, character 27. > | The construct is not understandable in its context. > | See error number -4373. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...