dbTalk Databases Forums  

How to put a comment in SQL in a package which can be seen in apex?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss How to put a comment in SQL in a package which can be seen in apex? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin
 
Posts: n/a

Default How to put a comment in SQL in a package which can be seen in apex? - 02-27-2009 , 05:07 AM






Hi,

Hoping someone can help me here. I have an Oracle package which
contains a lot of SQL and I can view the top SQL using apex but it
does not show the comments. I'd like to add comments to identify where
the SQL is.

e.g.,
-- sql in oracle package
update mytable set mycolumn = 1 /*a comment*/;

the "a comment" does not appear in apex presumably because it is an
Oracle package and Oracle has removed it. Is there any way to get
comments in SQL written in a package through to Oracle so apex can
show them?

Thanks

Martin

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.