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

From: Lisa Clary <lisa_at_cog.ufl.edu>
Date: Mon, 25 Jun 2001 08:08:52 -0700
Message-ID: <F001.003369DA.20010625081939@fatcity.com>

I thought this too, but when
doing a truncate table, it returned a code=113, stated that it successfully completed, but yet the table did not truncate. Just thought I was missing something--any ideas?
 
thanks,
lc

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of JOE TESTASent: Monday,   June 25, 2001 11:51 AMTo: Multiple recipients of list   ORACLE-LSubject: Re: Return Codes from PL/SQL   Execute...
  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: <A
  href="http://www.orafaq.com">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:08:52 CDT