Subject | Re: ResulSet not follow |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-08-30T06:55:22Z |
> cs = con.prepareCall("{call OBTENER_TIPOS_ID}");Replace this with:
cs = con.prepareCall("SELECT * FROM OBTENER_TIPOS_ID");
> When I run, only show the first row and exists from the while loop.{call ....} is translated into EXECUTE PROCEDURE .., and this SQL
>
> What happen?
statement returns only one result. For selectable procedures you have
to use SELECT statement.
Best regards,
Roman Rokytskyy