Compile it in SQLPLUS
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
do a select from user_source (or dba_source) for that package and that
line number
--- [EMAIL PROTECTED] wrote:
> Hi All
>
> Oracle 8.1.6/NT.
>
> I am using DB Studio. The package spec compiles. I have 3 errors in
> package
> body. When I do show errors it states line#/column# of error
> howev
Try following ...
SELECTDECODE(TO_CHAR(us.line), '1', ue.text||'
Pkg:'||us.name||chr(10)||chr(10)||
' '||TO_CHAR(us.line,'0')||' '||us.text,
TO_CHAR(ue.line-7),ue.text||' Pkg:'||us.name||'
',
Hi All
Oracle 8.1.6/NT.
I am using DB Studio. The package spec compiles. I have 3 errors in package
body. When I do show errors it states line#/column# of error
however these do not match line# in editor. How can I tell exactly what
line of code the show error is stating?
Thanks
Rick
--
Plea