Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: EXEC_SQL Question

Re: EXEC_SQL Question

From: <rtproffitt_at_my-deja.com>
Date: Fri, 22 Oct 1999 17:47:09 GMT
Message-ID: <7uq7ut$7tf$1@nnrp1.deja.com>


Although it is two sql statements, would this work:

take the text of sql you would use to open the cursor and create another string which is principally SELECT COUNT(1) xxxxx
You could then run the count query, get your answer, then run the second query to open the cursor formally...

Robert Proffitt

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 12:47:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US