Re: PRO*C problem

Delfosse Vincent wrote:
>
> Hello
>
> I've got a problem with a program written in PRO*C, with oracle 6 on unix
> I post this program in attach.
>
> The same SQL query, written in sqlplus, give "no rows selected".
> In this program, the statement "EXEC SQL WHENETHER NOT FOUND goto .."
> doesn't work when i wrote the query into the form of a string
> (EXEC SQL IMMEDIATE :stmt);
> He works well when i wrote the same statement in the form
> (EXEC SQL SELECT ...)
>

[SNIP] You can't execute immediate a query unless it returns exactly one row.

-- 
S. Lott
Consultant, NE Region
CTG
SLOTT_at_DELPHI.COM
S.LOTT_at_CTG.COM
800-992-5350 box 7053