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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Return Codes from PL/SQL Execute...

Re: Return Codes from PL/SQL Execute...

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Mon, 25 Jun 2001 08:21:38 -0700
Message-ID: <F001.00336898.20010625075101@fatcity.com>

look at the "source" code for it,
 

$ORACLE_HOME/rdbms/admin/dbmssql.sql
 

for execute:
 
 function execute(c in integer) return integer; 
--  Execute the given cursor and return the number of rows processed  --  (valid and meaningful only for INSERT, DELETE or

UPDATE statements;  --  for other types of statements, the return 
value is undefined and  --  should be ignored).  --  
Input parameters:  --    c  

--      Cursor id number of the cursor to execute.  --  Return value:  --    Number of rows processed if the statement in the cursor is  --    either an INSERT, DELETE or UPDATE statement or undefined otherwise.  --
 

joe
>>> lisa_at_cog.ufl.edu 06/25/01 11:01AM >>>Hi all,Can anyone tell me where I can find out what the return code values mean forexecuting procedures--e.g. feedback := DBMS_SQL.EXECUTE (cursor). Where arethe values/meanings found that are assigned to the variable feedback?Thanks much,lc-- Please see the official ORACLE-L FAQ: http://www.orafaq.com--
Author: Lisa Clary  INET: lisa_at_cog.ufl.eduFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing
Lists--------------------------------------------------------------------To 
REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing). Received on Mon Jun 25 2001 - 10:21:38 CDT

Original text of this message

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