Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: using stored procedures from pro*c

Re: using stored procedures from pro*c

From: Tim Gorman <>
Date: Wed, 31 Jul 2002 17:33:29 -0800
Message-ID: <>

using stored procedures from pro*cIt is meaningless. PL/SQL blocks handle their own cursors within a single cursor employed by PRO*C, so the contents of "sqlca.sqlerrd[2]" are likely leftover from a previous call? You may have gotten the value you wanted in one version, but I wouldn't count on that functionality surviving from version to version...

>From the "PRO*C Reference" for v9.2 (page c-12):

For the purposes of cursor management, an embedded PL/SQL block is treated just

like a SQL statement. When an embedded PL/SQL block is executed, a parent

cursor is associated with the entire block and a link is created between the cache

entry and the private SQL area in the PGA for the embedded PL/SQL block. Be

aware that each SQL statement inside the embedded block also requires a private

SQL area in the PGA. These SQL statements use child cursors that PL/SQL

manages itself. The disposition of the child cursors is determined through its

associated parent cursor. That is, the private SQL areas used by the child cursors are

freed after the private SQL area for its parent cursor is freed.

  When calling a stored procedure (to do a select)   from a pro*c program, does the sqlca.sqlerrd[2]   row counter get set? Or does that
  happen only if you are putting the selects into   the Pro*C program?

  It seems to act differently for different   versions. It is working for Oracle 7.2,   but does not appear to function that way on the 8.1.7.

  Anbody have any insight.

  Matt Adams - GE Appliances -   My computer beat me at chess, but I won   when it came to kick boxing.
Please see the official ORACLE-L FAQ:
Author: Tim Gorman

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Jul 31 2002 - 20:33:29 CDT

Original text of this message