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 -> SQLCODE, SQLERRM, SQLNROWS

SQLCODE, SQLERRM, SQLNROWS

From: Liam Caffrey <Liam.dot.Caffrey.dot.caffreyl_at_nortel.dot.ie>
Date: 10 Aug 1998 11:20:01 GMT
Message-ID: <01bdc450$5fa33080$bb0a552f@nt-02188.europe.nortel.com>


Is the 'Number of Rows' operated on available like the SQLCODE and SQLERRM are.

e.g.

INSERT INTO table1
(

    col1
,col2
,col3

)
SELECT col1

,col2
,col3

  FROM table2 ;

nrows_out_var := SQLNROWS ;

How about it? Received on Mon Aug 10 1998 - 06:20:01 CDT

Original text of this message

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