From lisa@cog.ufl.edu Mon, 25 Jun 2001 08:08:52 -0700 From: "Lisa Clary" Date: Mon, 25 Jun 2001 08:08:52 -0700 Subject: RE: Return Codes from PL/SQL Execute... Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 -----Original Message-----From: root@fatcity.com [mailto:root@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@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@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@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).