Home -> Usenet -> comp.databases.oracle -> ProC Dynamic SQL method 4 question

ProC Dynamic SQL method 4 question

From: Lars Karlsson <larkar_at_u30005.rsv.svskt.se>
Date: Wed, 11 Jan 1995 12:47:18 GMT
Message-ID: <1995Jan11.124718.18226_at_rsv.svskt.se> 






Hello!



I am constructning a program that uses ProC dynamic sql method
4 and I have one problem with this.


When I do the FETCH, how can I recognise how many rows the query
will give back after the first row. Is there someway I can get this
information? Is it possible to use a array with method 4?
My problem is that I have to now if the query will return more than
500 rows. If it dont then I have to process each row but if more than
500 rows then I should not do anything.



Please help me!



// Lars 
Received on Wed Jan 11 1995 - 13:47:18 CET












Original text of this message