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

Home -> Community -> Usenet -> c.d.o.misc -> getting the current line in PL/SLQ functions

getting the current line in PL/SLQ functions

From: paul cluiss <paul_cluiss_at_intervoice.com>
Date: Thu, 14 Oct 1999 12:59:41 -0500
Message-ID: <6438F7F2F00B0AF6.7E274BA04710A339.F90C953ACE7A1C80@lp.airnews.net>


Hello everyone,

I would like to know if anyone knows how to programmatically determine the line number of the package at the current point of execution. For all you 'C' programmers out there, this is roughly equivalent to the __LINE__ and __FILE__ macros, which will give the line number and filename of the point at which they are invoked. I would like to use this to help me pass some debugging information from a PL/SQL package back to a Pro*C client over an Oracle pipe. As is, my PL/SQL code is totally ignorant of the current line.

Thanks,

Paul Cluiss
Dallas, Texas Received on Thu Oct 14 1999 - 12:59:41 CDT

Original text of this message

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